| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Dumping roles improvements? |
| Date: | 2011-10-12 19:33:28 |
| Message-ID: | 4E95EB88.9000505@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2011-10-12 19:48:56 | Re: patch: move dumpUserConfig call in dumpRoles function of pg_dumpall.c |
| Previous Message | Andrew Dunstan | 2011-10-12 19:31:44 | Re: Dumping roles improvements? |