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+FBWCXatLexA5cqG+BEkPyeyNO4eHj8VaEcDOsU2Ub7eu+g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Dump & restore in directory format and permissions are largely lost?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Dump & restore in directory format and permissions are largely lost?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Дерево обсуждения
Ah, I'm sorry, is there a way to see grants contained in a dump?

On Tue, Jun 15, 2021 at 6:30 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Wells Oliver <wells.oliver@gmail.com> writes:
> pg_restore -Fd -l db.full.dump/ | grep ACL | grep webaccess
> Shows nothing, though I use this role on many schemas and relations.

What do you think you're filtering for there?  The -l output for ACL entries
will show the names of the objects and their owners, but not the grantees.

> Is there anything about this dump statement that would prevent some ACL
> lines from being generated?

Not that I see.

                        regards, tom lane


--

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

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