lmyho wrote:
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.
I will do to check about it. But I am not sure if I can fix something as I am new to Debian too,:( just installed it last week, one of the purpose is to use postgresql. Unfortunately, only a beginner at this time for both systems.:(
It is usually a simple shell script that starts/stops PostgreSQL. At
least the ones that come with the PostgreSQL source are pretty easy to
understand.
I may post back the info of the init file, I know there is postgresql in the init.d directory. And hope to get your further help from that.
That would be the file.
Best Wishes,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:chris@xxxxxxxxxxxxxxxx
tel;work:509-888-0220
tel;cell:509-630-7794
x-mozilla-html:FALSE
version:2.1
end:vcard
