Re: Starting postgres with a password

From: Doug Silver <dsilver(at)urchin(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Starting postgres with a password
Date: 2003-04-25 00:25:12
Message-ID: 200304241724.50871.dsilver@urchin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thursday 24 April 2003 04:59 pm, Tom Lane wrote:
> Doug Silver <dsilver(at)urchin(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Matthias Weinhold 2003-04-25 08:03:05 Frontend to put data in a database
Previous Message Tom Lane 2003-04-24 23:59:35 Re: Starting postgres with a password