Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Dump & restore in directory format and permissions are largely lost?
Date
Msg-id 593079.1623807952@sss.pgh.pa.us
Whole thread Raw
In response to Re: Dump & restore in directory format and permissions are largely lost?  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: Dump & restore in directory format and permissions are largely lost?
List pgsql-admin
Tree view 
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: Wells Oliver
Date:
Subject: Re: Dump & restore in directory format and permissions are largely lost?
Next
From: Wells Oliver
Date:
Subject: Re: Dump & restore in directory format and permissions are largely lost?