Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group