Re: Pg_dumpall problem

I thought ALL databases used passwords!

2/6/2003 6:52:25 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>