Received: from gabuzo.dyn.cheapnet.net (r138m123.cybercable.tm.fr [195.132.138.123]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f33MlYK43953 for ; Tue, 3 Apr 2001 18:47:35 -0400 (EDT) (envelope-from christophe@labouisse.org) Received: by gabuzo.dyn.cheapnet.net (Postfix, from userid 501) id A6E485CC86; Wed, 4 Apr 2001 00:47:23 +0200 (CEST) To: pgsql-sql@postgresql.org Subject: pg_dumpall and password access From: Christophe Labouisse Date: 04 Apr 2001 00:47:23 +0200 Message-ID: Lines: 26 User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.1 (Cuyahoga Valley) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200104/28 X-Sequence-Number: 2367 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