Обсуждение: 7.1.3 : pg_dumpall does not work for me

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@goldfisch.at

Hi Peter,

Try pg_dumpall -U postgres.
Or temporary switch your postgresql-database to AUTH_TYPE trust in
pg_hba.conf.
Or specify the user with 'export PGUSER=postgres'


Tommi



Am Dienstag, 22. Oktober 2002 14:11 schrieb pilsl@goldfisch.at:
> 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

--
Dr. Eckhardt + Partner GmbH
http://www.epgmbh.de

On Tue, Oct 22, 2002 at 02:45:01PM +0200, Tommi Maekitalo wrote:
> Hi Peter,
>
> Try pg_dumpall -U postgres.

does not work (I tried this before)

> Or temporary switch your postgresql-database to AUTH_TYPE trust in
> pg_hba.conf.
> Or specify the user with 'export PGUSER=postgres'
>

This two together did the trick :) thanks a lot.

thnx,
peter


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