From: | Wells Oliver <wellsoliver(at)gmail(dot)com> |
---|---|
To: | Giuseppe Broccolo <giuseppe(dot)broccolo(at)2ndquadrant(dot)it> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Couldn't start postgres, got no logging, ran postgres manually for info-- help? |
Date: | 2013-07-12 17:29:00 |
Message-ID: | 58263C4A-0786-4FA1-9AA3-C176A9C0ED35@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Alright but what's odd to me is that it's a standard out of the box ubuntu configuration, meaning:
log_destination is 'stderr'
logging_collector is on
log_directory is /var/log/postgresql/
log_filename is postgresql-%Y-%m-%d_%H%M%S.log
When I ran pg_ctlcluster start, I only received "please check the log output", but there were no errors logged. There are definitely log items when the server was running normally.
When I ran postgres manually, I saw the permissions issue. My question then is where was this error sent when running pg_ctlcliuster, or why was it squashed? It would have been helpful to have that from the start.
--
Wells Oliver
wellsoliver(at)gmail(dot)com
On Jul 12, 2013, at 2:23 AM, Giuseppe Broccolo <giuseppe(dot)broccolo(at)2ndquadrant(dot)it> wrote:
> Hi Oliver,
>
> Il 12/07/2013 04:07, Wells Oliver ha scritto:
>> 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.
>
> By default pg_ctlcluster script redirects postmaster's stderr into /var/log/postgresql/postgresql-9.1-main.log.
> This works only if log_destination is stderr and logging_collector is disabled, else the logs are stored where configured by log_destination, log_filename and log_directory in your postgresql.conf file.
> Advice is to look into your postgresql.conf how (and if) logging is configured.
>
> Regards,
> Giuseppe.
> --
> Giuseppe Broccolo - 2ndQuadrant Italy
> PostgreSQL Training, Services and Support
> giuseppe(dot)broccolo(at)2ndQuadrant(dot)it | www.2ndQuadrant.it
From | Date | Subject | |
---|---|---|---|
Next Message | Jerry Sievers | 2013-07-12 18:14:53 | Re: Couldn't start postgres, got no logging, ran postgres manually for info-- help? |
Previous Message | Scott Ribe | 2013-07-12 16:03:49 | Re: logging or debugging to report time to establish a database connection |