Re: pg_restore (fromuser -> touser)

Поиск
Список
Период
Сортировка
От Mayan
Тема Re: pg_restore (fromuser -> touser)
Дата
Msg-id CAOeXn7pj9vk8it5JQihRDy3NjWXEFDJ5wQFB=4ABPE9DKj9pwg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_restore (fromuser -> touser)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Thanks for the responses everyone and the reality check of how new features get in.  I will look into the suggestion by Vijaykumar in more detail and try it out.

Thanks again,
Mayan 

On Sun, Jul 25, 2021 at 10:11 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Sun, Jul 25, 2021 at 8:02 PM Ganesh Korde <ganeshakorde@gmail.com> wrote:
You just need to export dump without any privileges. And while restoring dump use the new role.

You should read the body of the original email and not just the subject line.  The actual question pertains to schemas - which IIUC are tightly linked to roles in other DBs (hence the observed behavior elsewhere) but aside from some default search_path stuff are unrelated in PostgreSQL.

David J.

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

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: PostgreSQL reference coffee mug
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: PostgreSQL reference coffee mug