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+FBVd=VbHJ_sCR+OVDN8M_aXy6rgE=ue91WjN5U6-=rY4uA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Dump & restore in directory format and permissions are largely lost?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Дерево обсуждения
That worked, I piped all the GRANTs into a file and ran it against the DB and permissions have been restored, but it remains puzzling to me why they were absent after the restore.

On Tue, Jun 15, 2021 at 6:45 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Wells Oliver <wells.oliver@gmail.com> writes:
> Ah, I'm sorry, is there a way to see grants contained in a dump?

I'd try "pg_restore -s -f - archive.file | grep GRANT" or so.

                        regards, tom lane


--

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

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