7.1.3 : pg_dumpall does not work for me

From: pilsl(at)goldfisch(dot)at
To: pgsql-general(at)postgresql(dot)org
Subject: 7.1.3 : pg_dumpall does not work for me
Date: 2002-10-22 12:11:03
Message-ID: 20021022141103.P6144@goldfisch.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

upgrading from 7.1.3 to 7.2.3

I want to save the old database with pg_dumpall, but I've two problems:

I cant specify a user. pg_dumpall always uses the name of the calling
user. So I created a systemuser which has the name of the postgres-user, but
now always I get the following:

--------
peter$ /usr/local/pgsql/bin/pg_dumpall -h localhost >/tmp/pgdump_all
Password:
psql: Password authentication failed for user 'peter'
Password: XXXXXX
Password: XXXXXX
Connection to database 'test' failed.
fe_sendauth: no password supplied

pg_dump failed on test, exiting
---------

note that I get the Password-Prompt three times, but the first times
it just runs by and I only can enter the password the second and third
time (I wrote XXXX where I entered the password)

The following works, so I dont think there is an auth-problem in my hba.conf:

---------
peter$ /usr/local/pgsql/bin/psql -h localhost test
Password: XXXXX
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

test=#
----------

anyone can help me ?

thnx,
peter

--
mag. peter pilsl
IT-Consulting
tel: +43-699-1-3574035
fax: +43-699-4-3574035
pilsl(at)goldfisch(dot)at

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrei Ivanov 2002-10-22 12:30:46 problem with escaping "
Previous Message Patrick Fiche 2002-10-22 09:58:00 Re: big pg_attribute_relid_attnam_index files