Can't restore from pg_dump. Authentication failed

Поиск
Список
Период
Сортировка
От gstasica@poczta.onet.pl (Greg)
Тема Can't restore from pg_dump. Authentication failed
Дата
Msg-id 4b5a2964.0405260308.de9639d@posting.google.com
обсуждение исходный текст
Ответы Re: Can't restore from pg_dump. Authentication failed
Список 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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: jcalfee@shortest-path.net
Дата:
Сообщение: If PostgreSQL was not the best damn database....
Следующее
От: "Krishna R Palati"
Дата:
Сообщение: Hot backup