Ubuntu – postgres not starting after reboot on ubuntu

postgresqlstartup-scriptsUbuntu

I'm not familiar with ubuntu (raring), so could someone help me please:

I'm using postgresql 9.1 from apt. It installed the appropriate init script in /etc/init.d/postgresql. I can start the server manually using the script. However, postgres is not started on boot. I issued a update-rc.d postgresql defaults and update-rc.d postgresql enable (as root) but that did not help.

Is there a specific boot log as i could not find anything in syslog? Thanks guys

EDIT2: OK, the problem seems to be a sysvinit vs. upstart problem. If I remove the symlinks in /etc/rcX:

sudo update-rc.d -f remove postgresql

and add a upstart script to start postgresql, it starts on boot as expected. As the postgresql is from the official apt repo I wonder why it's not working out of the box?

Best Answer

Are you using server or desktop version.

Normally Postgres work perfectly out the box on ubuntu, but i always use ubuntu server LTS. I think to that issue was caused for some inconsistence on the raring version installer.

Related Solutions

Postgresql – What’s the default superuser username/password for postgres after a new install

CAUTION The answer about changing the UNIX password for "postgres" through "$ sudo passwd postgres" is not preferred, and can even be DANGEROUS!

This is why: By default, the UNIX account "postgres" is locked, which means it cannot be logged in using a password. If you use "sudo passwd postgres", the account is immediately unlocked. Worse, if you set the password to something weak, like "postgres", then you are exposed to a great security danger. For example, there are a number of bots out there trying the username/password combo "postgres/postgres" to log into your UNIX system.

What you should do is follow Chris James's answer:

sudo -u postgres psql postgres

# \password postgres

Enter new password:

To explain it a little bit. There are usually two default ways to login to PostgreSQL server:

By running the "psql" command as a UNIX user (so-called IDENT/PEER authentication), e.g.: sudo -u postgres psql. Note that sudo -u does NOT unlock the UNIX user.
by TCP/IP connection using PostgreSQL's own managed username/password (so-called TCP authentication) (i.e., NOT the UNIX password).

So you never want to set the password for UNIX account "postgres". Leave it locked as it is by default.

Of course things can change if you configure it differently from the default setting. For example, one could sync the PostgreSQL password with UNIX password and only allow local logins. That would be beyond the scope of this question.

Ubuntu update-rc.d problems

You need to add specific information for update-rc.d to your script. You'll find an example in /etc/init.d/skeleton

Best Answer

Related Solutions

Postgresql – What’s the default superuser username/password for postgres after a new install

Ubuntu update-rc.d problems

Related Topic