Re: Starting postgres with a password - Mailing list pgsql-novice

From Doug Silver
Subject Re: Starting postgres with a password
Date
Msg-id 200304241724.50871.dsilver@urchin.com
Whole thread Raw
In response to Re: Starting postgres with a password  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Starting postgres with a password  ("M. Bastin" <marcbastin@mindspring.com>)
List pgsql-novice
On Thursday 24 April 2003 04:59 pm, Tom Lane wrote:
> Doug Silver <dsilver@urchin.com> writes:
> > I've searched around but didn't see this answered (at least in the first
> > 100 answers!).  If the postgres user has a password (in Postgres, not the
> > system) *and* the hba_conf file does not trust the 127.0.0.1 host but
> > requires a password, how can you start up Postgresql?
>
> The postmaster doesn't need a password to start.  If it can access the
> data directory it figures you're authorized to start it.
>
>             regards, tom lane

Ah, found the culprit in the supplied startup script  -- it was using "-w" on
startup which caused it to prompt for the password.

Thanks!

-doug


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Starting postgres with a password
Next
From: Matthias Weinhold
Date:
Subject: Frontend to put data in a database