From: Chris Travers <chris@travelamericas.com>
To: lmyho <lm_yho@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl newbie!
Date: Wed, 29 Mar 2006 21:15:33 -0800
Message-ID: <442B6975.2000409@travelamericas.com> (raw)
In-Reply-To: <20060330041732.34695.qmail@web30809.mail.mud.yahoo.com>
References: <20060330041732.34695.qmail@web30809.mail.mud.yahoo.com>
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 things so that root is allowed to connect ...", what should I do with this? Would you please give me more hints? Thanksa lot!!!
>
>leo
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: chris@travelamericas.com, lm_yho@yahoo.com
Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl newbie!
In-Reply-To: <442B6975.2000409@travelamericas.com>
References: <20060330041732.34695.qmail@web30809.mail.mud.yahoo.com> <442B6975.2000409@travelamericas.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox