Re: Restore dump into different databases/owners

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Restore dump into different databases/owners
Дата
Msg-id 9118.1200158125@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Restore dump into different databases/owners  (Andreas Haumer <andreas@xss.co.at>)
Ответы Re: Restore dump into different databases/owners  (Andreas Haumer <andreas@xss.co.at>)
Список pgsql-admin
Andreas Haumer <andreas@xss.co.at> writes:
> I now solved it by temporarily adding the "superuser" privilege
> to the roles in question.

That should not be necessary, unless the dump contained objects that
require superuser permission to create (such as C-language functions)
--- in which case giving ownership of them to a non-superuser account
seems a bit unwise anyway.

Exactly what problems did you have using "-O -U user" ?

            regards, tom lane

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

Предыдущее
От: Andreas Haumer
Дата:
Сообщение: Re: Restore dump into different databases/owners
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.3 RC1 - Logging and filenames