Re: Dump & restore in directory format and permissions are largely lost?

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Re: Dump & restore in directory format and permissions are largely lost?
Дата
Msg-id CAOC+FBVYfA9y=QL2rvW751t3FffryTTyCJF40-phG5wEomOc9g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Dump & restore in directory format and permissions are largely lost?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Dump & restore in directory format and permissions are largely lost?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Дерево обсуждения
Yes. The target and source servers have the same users and roles, which is why their permissions being absent from the same objects on the target where they exist in the source is very confusing to me.

I also do a pg_restore -l -Fd on the dump file, and I don't see any GRANT or REVOKE statements: should I expect that?

On Tue, Jun 15, 2021 at 5:58 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tue, Jun 15, 2021 at 6:55 PM Wells Oliver <wells.oliver@gmail.com> wrote:

Am I missing something obvious here?


You specified a host in the restore command - since pg_dump doesn't dump global objects like roles are you sure the restore cluster has the necessary roles present?

David J.


--

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Dump & restore in directory format and permissions are largely lost?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Dump & restore in directory format and permissions are largely lost?