pg_dumpall and password access

From: Christophe Labouisse <labouiss(at)cybercable(dot)fr>
To: pgsql-sql(at)postgresql(dot)org
Subject: pg_dumpall and password access
Date: 2001-04-03 22:47:23
Message-ID: m266gliosk.fsf@gabuzo.meunet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 authentication failed for user 'postgres'
Password: psql: Password authentication failed for user 'postgres'
# I type my password on the next line
Password: Password: psql: Password authentication failed for user 'postgres'
Connection to database 'sympa' failed.
fe_sendauth: no password supplied

pg_dump failed on sympa, exiting

I need to have a password identification since I don't want the
"common" users to be able to connect to any database. Beside I cannot
leave the "local" to the "trust" auth scheme because every users are
able to run programs on the machine hosting the database.

Is there any configuration tips or workaround known for my problem ?

--
Le cinéma en Lumière : http://www.lumiere.org/
Fingerprint : 4721 651D D309 B302 93E4 5D73 CC52 DF3A E7C7 86CF

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-04-03 23:29:38 Re: pg_dumpall and password access
Previous Message Najm Hashmi 2001-04-03 14:20:52 Error:TypeCreate: type links already defined