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