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

From: lmyho <lm_yho(at)yahoo(dot)com>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Chris Travers <chris(at)metatrontech(dot)com>
Cc: lmyho <lm_yho(at)yahoo(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl newbie!
Date: 2006-03-30 17:38:59
Message-ID: 20060330173859.5287.qmail@web30812.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2006-03-30 19:16:51 Re: Postgresql server does not start!:( -Re: PostgreSQl
Previous Message lmyho 2006-03-30 17:33:18 more- Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!