Re: postgres authentication question - Mailing list pgsql-novice

From Tom Lane
Subject Re: postgres authentication question
Date
Msg-id 308.1163874187@sss.pgh.pa.us
Whole thread Raw
In response to postgres authentication question  (Tom Allison <tallison@tacocat.net>)
List pgsql-novice
Tom Allison <tallison@tacocat.net> writes:
> I would like to change the postgres user to authenticate by md5 only,
> no ident sameuser option.  I might still keep the authentication as
> local only.  But when I do this, at start up I get a number of minor
> errors in my logs about the user postgres can't authenticate.

That's from pg_ctl trying to check whether the postmaster is up yet.
You could remove the -w option from "pg_ctl start", or you could
create a ~/.pgpass file for pg_ctl to use.  The latter might be a
win anyway for ease of interactive use.  See
http://www.postgresql.org/docs/8.1/static/libpq-pgpass.html

            regards, tom lane

pgsql-novice by date:

Previous
From: "Mikael Carneholm"
Date:
Subject: CHECK constraint and trigger
Next
From: Tom Allison
Date:
Subject: moving a single database