Re: [SQL] pg_dumpall and password access

2001-04-04 Thread David Lizano
At 19.29 3/4/01 -0400, you wrote: >Christophe Labouisse <[EMAIL PROTECTED]> writes: > > I'm trying to run pg_dumpall to backup all my users' bases but since I > > have configure pg_hba.conf to "passwd" pg_dumpall always fails: > >pg_dumpall doesn't work very well with password authentication (and

Re: [SQL] pg_dumpall and password access

2001-04-03 Thread Tom Lane
Christophe Labouisse <[EMAIL PROTECTED]> writes: > I'm trying to run pg_dumpall to backup all my users' bases but since I > have configure pg_hba.conf to "passwd" pg_dumpall always fails: pg_dumpall doesn't work very well with password authentication (and even if it did, storing the password in a

[SQL] pg_dumpall and password access

2001-04-03 Thread Christophe Labouisse
I'm trying to run pg_dumpall to backup all my users' bases but since I have configure pg_hba.conf to "passwd" pg_dumpall always fails: su-2.03$ pg_dumpall >backup.dat # I'm the postgres unix user. Password: psql: Password authentication failed for user 'postgres' Password: psql: Password authenti