restore from a pg_dumpall file

Поиск
Список
Период
Сортировка
От Bob Powell
Тема restore from a pg_dumpall file
Дата
Msg-id s0b31e13.077@grpwise.hotchkiss.org
обсуждение исходный текст
Ответы Re: restore from a pg_dumpall file  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
** High Priority **

Hello everyone,

I have a restore file created by pg_dumpall.  The restore file has two
users associated with ownership of tables.  The postgres user and a user
called nsadmin.

When I attempt to restore this it won't create my call_handlers because
it's not the postgres user.  If I attempt to restore under the nsadmin
user the language handlers fail.

How can I restore this file without changing everything to postgress
user?

Thanks.

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: md5 function available since ...?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: FW: Majordomo results: subscribe pgsql-general