pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <smarlowe@g2switchworks.com>
To: lmyho <lm_yho@yahoo.com>
Cc: Chris Travers <chris@metatrontech.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl
Date: Thu, 30 Mar 2006 13:16:51 -0600
Message-ID: <1143746210.26940.29.camel@state.g2switchworks.com> (raw)
In-Reply-To: <20060330173859.5287.qmail@web30812.mail.mud.yahoo.com>
References: <20060330173859.5287.qmail@web30812.mail.mud.yahoo.com>

On Thu, 2006-03-30 at 11:38, lmyho wrote:
> > > > 
> > 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!!

Can't find the thread right now (my search-fu is not strong today) but I
think this thread has covered all the basic points.  Does anyone know if
it is possible for the startup script to read the ~/.pgpass file of the
postgres user on startup and use that if you absolutely have to have the
main postgres user have a password on it in debian?

My guess is that you could also just comment out the lines in the init
script that are hanging, as the actual db startup should not require a
password.



view thread (20+ messages)  latest in thread

Message-ID: <1143746210.26940.29.camel@state.g2switchworks.com>
Permalink:  ../1143746210.26940.29.camel@state.g2switchworks.com/
Also on:    postgresql.org/message-id/1143746210.26940.29.camel@state.g2switchworks.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: smarlowe@g2switchworks.com, lm_yho@yahoo.com, chris@metatrontech.com, tgl@sss.pgh.pa.us
  Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl
  In-Reply-To: <1143746210.26940.29.camel@state.g2switchworks.com>
  References: <20060330173859.5287.qmail@web30812.mail.mud.yahoo.com> <1143746210.26940.29.camel@state.g2switchworks.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