On 14/12/2015 11:39 AM, John R Pierce wrote: > On 12/13/2015 4:22 PM, Peter Brady wrote: >> Again there appears to be nothing logged to indicate why the server >> is not starting at this point. > > the standard versions of postgres for RHEL/CentOS leave two sets of > logs... 1 is the startup log /var/lib/pgsql/9.2/pgstartup.log, and the > other is the regular PG logging, in /var/lib/pgsql/9.2/data/pg_log/* ... > > I'd run the /normal/ pg startup script as their may be site specific > environments configured by the original administrator... > > # service postgresql-9.2 start > > and then look at the startup log first. if it ends with... > > 2015-07-21 00:33:31.851 PDT @[]: LOG: redirecting log output to > logging collector process > 2015-07-21 00:33:31.851 PDT @[]: HINT: Future log output will appear > in directory "pg_log" > > then look in the data/pg_log directory for a new file dated today. Hi John,
Thanks for the heads up on that second log. I was focusing on: /var/lib/pgsql/9.2/pgstartup.log as that's what I found in the init.d script. It however was empty. The key was in the second log in: /var/lib/pgsql/9.2/data/pg_log/* which pointed to a typo in pg_hba for host ip specification. Clearly the typo had not been through a restart yet and when I restarted the machine it hit the bug. That was then a simple fix as the IP address was missing its CDIR mask. Cheers, -pete
signature.asc
Description: OpenPGP digital signature
