Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! - Mailing list pgsql-admin

From lmyho
Subject Re: Postgresql server does not start!:( -Re: PostgreSQl newbie!
Date
Msg-id 20060330173859.5287.qmail@web30812.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Postgresql server does not start!:( -Re: PostgreSQl  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: Postgresql server does not start!:( -Re: PostgreSQl
List pgsql-admin
> > >
> > >
> > Interesting.... Database starts up at 10:32:37 and processes all
> > databases through autovacuum.
> > Then exactly a minute later, it processes the postgres database.
> > 5 seconds later, you get a SIGINT.
> >
> > Is there something wrong with autovacuum?  Normally I would doubt it but
> > the other possibility is something is waiting for just over a minute and
> > then shutting down the database.
> >
> > If you su postgres, can you run pg_ctl and get the database up by itself?
>
> If I remember correctly, this is a problem with the debian startup
> script requiring trust for the postgres superuser, and was discussed
> sometime last year.  I'll wander through the archives in a free moment
> and see if I can find it.

Great Scott!! Thank you!!  This system was just installed on Debian (2 days), and
the original pg_hba.conf file authen method was "ident sameuser" and appears not
allow it to be changed!

Look forward to your information!! Thanks a lot!!

regards,
leo
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-admin by date:

Previous
From: lmyho
Date:
Subject: more- Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
Next
From: Scott Marlowe
Date:
Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl