Can't restore from pg_dump. Authentication failed

From: gstasica(at)poczta(dot)onet(dot)pl (Greg)
To: pgsql-admin(at)postgresql(dot)org
Subject: Can't restore from pg_dump. Authentication failed
Date: 2004-05-26 11:08:33
Message-ID: 4b5a2964.0405260308.de9639d@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Frankly I don't know what should I do more. The problem is:
I've made a pg_dump from shell like that:
pg_dump -Upostgres -O -D -Fc --file=baza.sql

Copied the file to new server and from shell executed:
linux:~ # pg_restore -d ppr -U postgres -i baza.sql
The result is
pg_restore: [archiver (db)] connection to database "ppr" failed:
FATAL: IDENT authentication failed for user "postgres"

I don't know what is going on since I can login to ppr database like
that
(in shell)
su - postgres
psql -dppr

Could anybody help me.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2004-05-26 12:56:29 Re: Can't restore from pg_dump. Authentication failed
Previous Message Jim Seymour 2004-05-26 10:48:04 Re: pg_hba.conf