Postgres Pro
Downloads
Home   >   mailing lists

Re: Dump & restore in directory format and permissions are largely lost? - Mailing list pgsql-admin

From Wells Oliver
Subject Re: Dump & restore in directory format and permissions are largely lost?
Date
Msg-id CAOC+FBVd=VbHJ_sCR+OVDN8M_aXy6rgE=ue91WjN5U6-=rY4uA@mail.gmail.com
Whole thread Raw
In response to Re: Dump & restore in directory format and permissions are largely lost?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dump & restore in directory format and permissions are largely lost?
Next
From: Nikhil Shetty
Date:
Subject: Re: vacuumdb idle processes