From: | Tommi Maekitalo <t(dot)maekitalo(at)epgmbh(dot)de> |
---|---|
To: | pilsl(at)goldfisch(dot)at, pgsql-general(at)postgresql(dot)org |
Subject: | Re: 7.1.3 : pg_dumpall does not work for me |
Date: | 2002-10-22 12:45:01 |
Message-ID: | 200210221445.01268.t.maekitalo@epgmbh.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)goldfisch(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | pilsl | 2002-10-22 13:01:11 | Re: 7.1.3 : pg_dumpall does not work for me |
Previous Message | Murali Mohan Kasetty | 2002-10-22 12:40:31 | IpcMemoryCreate: shmget(key=5432001, size=1441792, 03600) failed: Not enough memory |