Re: postgres authentication question

Tom Allison <tallison(at)tacocat(dot)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