Re: pg_restore and permissions - Mailing list pgsql-admin

From Florian Weimer
Subject Re: pg_restore and permissions
Date
Msg-id 87d6wnu1ue.fsf@CERT.Uni-Stuttgart.DE
Whole thread Raw
In response to Re: pg_restore and permissions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_restore and permissions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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 ;-).

But SET SESSION AUTHORIZATION does not seem to be available in 7.2.1,
yet 7.1.3.

--
Florian Weimer                       Weimer@CERT.Uni-Stuttgart.DE
University of Stuttgart           http://CERT.Uni-Stuttgart.DE/people/fw/
RUS-CERT                          +49-711-685-5973/fax +49-711-685-5898

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore and permissions
Next
From: Michael Glenn
Date:
Subject: Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database