lmyho wrote:
Chris Travers <chris@xxxxxxxxxxxxxxxxxxxxxxxx> writes:
Things to check when PostgreSQL doesn't seem to start:
...
In your case, if PostgreSQL is hanging, I would suspect that the problem
is likely to be with something else. Hopefully there would be info in
the serverlog that would help.
What I'm guessing is that the server started just fine, but the Debian
initscript is trying to connect to it (to verify that it started) and
that's failing because of the change in authentication options. You
might have to remove the -w option from pg_ctl, or some such, in the
script ... or else fix things so that root is allowed to connect ...
To fix this you will ideally want to be familiar enough with the init
script system to be able to edit it. In most distros (never used
Debian) it is in /etc/init.d/ and is named something like postgresql.
Look in there. If you can't figure it out, you can post it in the email.
Best Wishes,
Chris Travers
Metatron Technology Consulting
Hi Tom, Thank you for the idea!
But how should I do this? I thought pg_ctl is a binary file, how should I make change of it? And for "or else fix things so that root is allowed to connect ...", what should I do with this? Would you please give me more hints? Thanksa lot!!!
leo
