Re: pg_restore and permissions

Tom Lane wrote:
> Florian Weimer <Weimer@CERT.Uni-Stuttgart.DE> writes:
> > Tom Lane <tgl@sss.pgh.pa.us> writes:
> >> SET SESSION AUTHORIZATION should have been used instead, but I doubt
> >> Florian has any convenient way to re-do the dump file with that option.
>
> > Fortunately, I can re-do the dump (I'm eager to become a professional
> > with a production and a testing machine ;-).
>
> Oh, in that case you can use
>     pg_dump -X use-set-session-authorization
>
> > But SET SESSION AUTHORIZATION does not seem to be available in 7.2.1,
> > yet 7.1.3.
>
> I do not think 7.1's pg_dump had this option, but you can run 7.2's
> pg_dump against the 7.1 server (in fact that is probably preferable
> anyhow).
>
> I would like to see use-set-session-authorization become the default
> before 7.3 release, but haven't got around to doing anything about it.

Certainly seems like a good idea.  TODO item?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026