Re: Postgresql server does not start!:( -Re: PostgreSQl newbie!

lmyho wrote:

>Chris Travers <chris@verkiel.metatrontech.com> 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
thingsso that root is allowed to connect ...", what should I do with this?  Would you please give me more hints?
Thanksalot!!! 
>
>leo
>
>
>
>