|
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
|
Attachment:
signature.asc
Description: OpenPGP digital signature
