pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Wells Oliver <wells.oliver@gmail.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Dump & restore in directory format and permissions are largely lost?
Date: Tue, 15 Jun 2021 21:45:52 -0400
Message-ID: <593079.1623807952@sss.pgh.pa.us> (raw)
In-Reply-To: <CAOC+FBWCXatLexA5cqG+BEkPyeyNO4eHj8VaEcDOsU2Ub7eu+g@mail.gmail.com>
References: <CAOC+FBUk6FGOa0NGaFKX_jJTmOgN-xLTWFKm5MsdnDRqoQ9p-g@mail.gmail.com>
	<CAKFQuwYHezea03kxRTcHg3Jo8+c-xQo8TXdDipHj6woaKacGCw@mail.gmail.com>
	<CAOC+FBVYfA9y=QL2rvW751t3FffryTTyCJF40-phG5wEomOc9g@mail.gmail.com>
	<591499.1623806357@sss.pgh.pa.us>
	<CAOC+FBUuZ6gvhtxZknn_NbH0eMh3CTS8bf1Toq+XxPp7E4c5yg@mail.gmail.com>
	<592237.1623807036@sss.pgh.pa.us>
	<CAOC+FBWCXatLexA5cqG+BEkPyeyNO4eHj8VaEcDOsU2Ub7eu+g@mail.gmail.com>

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





view thread (9+ messages)  latest in thread

Message-ID: <593079.1623807952@sss.pgh.pa.us>
Permalink:  ../593079.1623807952@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/593079.1623807952@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, wells.oliver@gmail.com, david.g.johnston@gmail.com
  Subject: Re: Dump & restore in directory format and permissions are largely lost?
  In-Reply-To: <593079.1623807952@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox