Re: Pg_dumpall problem

James Hall <James.Hall@RadioShack.com> writes:
> I am trying to use pg_dumpall to backup my databases, and it is failing.
> The results of a attempted dumpall are below:

> [postgres@rspde postgres]$ pg_dumpall > 020503.out
> Password: psql: Password authentication failed for user 'postgres'
> Password: Password: psql: Password authentication failed for user 'postgres'
> Password: psql: fe_sendauth: no password supplied
> Password: psql: fe_sendauth: no password supplied

pg_dumpall is more or less useless for databases that use password
protection.  I counsel setting up a different authorization method for
local connections.

            regards, tom lane