Re: 7.1.3 : pg_dumpall does not work for me

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