pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Travers <chris@metatrontech.com>
To: lmyho <lm_yho@yahoo.com>
Cc: Chris Travers <chris@travelamericas.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl newbie!
Date: Wed, 29 Mar 2006 21:53:22 -0800
Message-ID: <442B7252.7050705@metatrontech.com> (raw)
In-Reply-To: <20060330052337.57976.qmail@web30809.mail.mud.yahoo.com>
References: <20060330052337.57976.qmail@web30809.mail.mud.yahoo.com>

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

>
>  
>

Attachments:

chris.vcf (text/x-vcard, 169B) download begin:vcard fn:Chris Travers n:Travers;Chris email;internet:chris@metatrontech.com tel;work:509-888-0220 tel;cell:509-630-7794 x-mozilla-html:FALSE version:2.1 end:vcard

view thread (20+ messages)  latest in thread

Message-ID: <442B7252.7050705@metatrontech.com>
Permalink:  ../442B7252.7050705@metatrontech.com/
Also on:    postgresql.org/message-id/442B7252.7050705@metatrontech.com

 · 

reply

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@metatrontech.com, lm_yho@yahoo.com, chris@travelamericas.com
  Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl newbie!
  In-Reply-To: <442B7252.7050705@metatrontech.com>
  References: <20060330052337.57976.qmail@web30809.mail.mud.yahoo.com> <442B7252.7050705@metatrontech.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