Re: Pg_dumpall problem

I thought ALL databases used passwords!

2/6/2003 6:52:25 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

>James Hall <James(dot)Hall(at)RadioShack(dot)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(at)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
>