On 10/12/2011 03:16 PM, Josh Berkus wrote:
On 10/11/11 9:43 PM, Tom Lane wrote:
I don't find this terribly convincing. I can see the rationales for two
endpoint cases: (1) restore these objects into exactly the same
ownership/permissions environment that existed before, and (2) restore
these objects with the absolute minimum of ownership/permissions
assumptions. The latter case seems to me to be covered already by
--no-owner --no-privileges.
But what I'm asking for is (1). The problem is that the roles don't
ship in the per-database pgdump file.
I think Tom's (1) assumes you already have that environment, not that it
will be created on the fly by pg_restore.
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
