pg_restore : ident authentication problem
От | Paul Tuohy |
---|---|
Тема | pg_restore : ident authentication problem |
Дата | |
Msg-id | F67TvhL1MfvqFJb9n5V000011f9@hotmail.com обсуждение исходный текст |
Ответы |
Re: pg_restore : ident authentication problem
|
Список | pgsql-admin |
i am running postgres 7.2.1 on two machines running debian. i create a dump file from one using basic options like: pg_dump -C -F c -f <<filename>> <<database>> copy this file to my other machine and run: pg_restore -C -F c -d template1 <<filename>> during restoration i get an error message that reads pg_restore: [archiver (db)] could not reconnect to database FATAL 1: IDENT authentication failed for user <<username>> i have at least tried most of the pg_restore options, as well relaxing all permissions in pg_hba.conf and pg_ident.conf. tried running pg_restore as different users (i.e. postgres or the future restored database owner). tried the -W option to manually authenticate. tried -O to override permissions altogether. tried various combinations using -S <<superuser>>, -r and -X. the second system is practically a mirror image of the first as lists all the same users. nevertheless, keep receiving this authentication error message. can work around it but would rather understand the problem. does anyone have the answer? pablo _________________________________________________________________ Join the world�s largest e-mail service with MSN Hotmail. http://www.hotmail.com
В списке pgsql-admin по дате отправления: