Re: ACLs versus ALTER OWNER - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: ACLs versus ALTER OWNER
Date
Msg-id 40BDF0CD.60100@familyhealth.com.au
Whole thread Raw
In response to Re: ACLs versus ALTER OWNER  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Someone else suggested having pg_dump dump all objects without ownership
> (so, on restore, they'd all initially be owned by the user running the
> script, hopefully a superuser) and then doing ALTER OWNERs and GRANTs at
> the bottom.

Actually, this would probably only be reasonable if you fixed the ACLs 
after an ALTER OWNER, like you proposed earlier.

Chris



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Converting postgresql.conf parameters to kilobytes
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: ACLs versus ALTER OWNER