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