PostgreSQL 9.1 on Ubuntu Lucid fails to start - how to debug?

Posted by Tom Fakes on Server Fault See other posts from Server Fault or by Tom Fakes
Published on 2012-05-07T18:29:44Z Indexed on 2012/10/07 15:39 UTC
Read the original article Hit count: 292

I'm using Vagrant with Chef Solo to setup a Lucid 64 box.

I'm using a Chef recipe to install PostgreSQL 9.1 from Martin Pitt's backports.

The install goes ok until the point where the database is started with

/etc/init.d/postgresql start

There's a log pause and the command fails.

If I run pg_ctl manually, the database starts!

The entire contents of my postgresql-9.1-main log file is:

2012-05-07 11:01:18 PDT LOG:  database system was shut down at 2012-05-07 11:01:16 PDT
2012-05-07 11:01:18 PDT LOG:  database system is ready to accept connections
2012-05-07 11:01:18 PDT LOG:  autovacuum launcher started
2012-05-07 11:01:18 PDT LOG:  incomplete startup packet
2012-05-07 11:01:26 PDT LOG:  received fast shutdown request
2012-05-07 11:01:26 PDT LOG:  aborting any active transactions
2012-05-07 11:01:26 PDT LOG:  autovacuum launcher shutting down
2012-05-07 11:01:26 PDT LOG:  shutting down
2012-05-07 11:01:26 PDT LOG:  database system is shut down

I've tried to change the postgresql config file to get more info into the logfile, but that hasn't worked at all.

How do I debug this to find out what is failing so I can fix it?

© Server Fault or respective owner

Related posts about ubuntu

Related posts about postgresql