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@xxxxxxxxxxxxx> wrote:
Wells Oliver <wells.oliver@xxxxxxxxx> 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
Wells Oliver
wells.oliver@xxxxxxxxx
wells.oliver@xxxxxxxxx
