pg_restore and permissions
От | Florian Weimer |
---|---|
Тема | pg_restore and permissions |
Дата | |
Msg-id | 87vgafu5g8.fsf@CERT.Uni-Stuttgart.DE обсуждение исходный текст |
Ответы |
Re: pg_restore and permissions
|
Список | pgsql-admin |
Is there a simple way to restore a databases from a pg_dump file? I've got a "pg_dump -F c" from version 7.1.3 and would like to restore it on a 7.2.1 database server. However, if I invoke, say, "pg_restore -C -d web web.db", I get the following error message: pg_restore: [archiver (db)] could not reconnect to database: FATAL 1: IDENT authentication failed for user "www-data" My pg_hba.conf looks like this: local all ident sameuser host all 127.0.0.1 255.0.0.0 ident sameuser host all 0.0.0.0 0.0.0.0 reject I know how to work around this problem (and did it in the past), but I'd really like to be able to restore a database using a single command. Does such a command exist? -- Florian Weimer Weimer@CERT.Uni-Stuttgart.DE University of Stuttgart http://CERT.Uni-Stuttgart.DE/people/fw/ RUS-CERT +49-711-685-5973/fax +49-711-685-5898
В списке pgsql-admin по дате отправления: