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

From Tom Lane
Subject Re: Starting postgres with a password
Date
Msg-id 3683.1051228775@sss.pgh.pa.us
Whole thread Raw
In response to Starting postgres with a password  (Doug Silver <dsilver@urchin.com>)
Responses Re: Starting postgres with a password  (Doug Silver <dsilver@urchin.com>)
List pgsql-novice
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


pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: ODBC & Access [Try 2]
Next
From: Doug Silver
Date:
Subject: Re: Starting postgres with a password