> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Albe Laurenz
> > What is going on here? Is there a password for user ‘postgres’ or
> > isn’t there? What is it? Why don’t I need it sometimes, and I do other
> times?
>
> You have a password set, and it is probably in a password file, which might
> have been created by pgAdmin III.
Half right.
> See http://www.postgresql.org/docs/current/static/libpq-pgpass.html
Mostly right. Thanks -- another part of the docs I've never found before.
Turns out that the superuser account does indeed have a password (how else would I have got past that annoying prompt
duringinstallation?) and the installer created a file in one of the strange Windows user data folders (not exactly the
onelisted in the docs, but close). Both pgadmin and psql know how to find that file, but other tools don't. Hence the
inconsistency.
Editing the pg_hba.conf (the usual recommendation) was never the right thing to do here. Finding that little password
filewas the trick.
Regards
David M Bennett FACS
Andl - A New Database Language - andl.org