Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group