Home > mailing lists

Couldn't start postgres, got no logging, ran postgres manually for info-- help? - Mailing list pgsql-admin

From	Wells Oliver
Subject	Couldn't start postgres, got no logging, ran postgres manually for info-- help?
Date	July 12, 2013 05:07:48
Msg-id	CAOC+FBXTnv4rro4Z26ZtaG35gTqO9vviRgH937ubD1BL9d4ZaA@mail.gmail.com Whole thread Raw
Responses	Re: Couldn't start postgres, got no logging, ran postgres manually for info-- help? (Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>)
List	pgsql-admin

I ran:

pg_ctlcluster 9.1 main start

Received:

The PostgreSQL server failed to start. Please check the log output.

But, hey, in /var/log/postgresql, there was absolutely no logging. Nothing. After some googling, I tried:

usr/lib/postgresql/9.1/bin/postgres -D /data/postgresql/9.1/main -c config_file=/etc/postgresql/9.1/main/postgresql.conf

From the command line, which spit out to the terminal:

2013-07-12 02:04:05 GMT [30091]: [1-1] FATAL: data directory "/data/postgresql/9.1/main" has group or world access

OK, so where the heck did this error message go when I was running pg_ctlcluster? It would have saved me a lot of time.

From: "Struckhoff, Kevin"
Date: 12 July 2013, 00:38:57
Subject: Re: Connecting to a remote db server

From: Wells Oliver
Date: 12 July 2013, 07:55:25
Subject: pg_upgrade (9.1 to 9.2) bombing on casts