From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Sergey Koposov <skoposov(at)cmu(dot)edu>, "tgl(at)sss(dot)pgh(dot)pa(dot)us" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: pg_dump schema in pg11 without global permissions |
Date: | 2019-07-24 00:10:58 |
Message-ID: | 5d51c135-f3c4-47a2-83c8-c01eba7663e4@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 7/23/19 4:32 PM, Sergey Koposov wrote:
> On Tue, 2019-07-23 at 19:24 -0400, Tom Lane wrote:
>> [ hey guys, please trim your replies ]
> sorry
>>
>> Experimenting, however, I see that that only works as intended if
>> I use v11 pg_restore. I can replicate your result if I use v10
>> pg_restore. So ... don't do that.
>
> Thanks very much!
>
> I've started the pg_dump|pg_restore using the v11 pg_restore. I'll see it works in a few hours.
For future use. To test this sort of thing use the -s switch to limit
the restore to objects only(no data). This will speed the process and
confirm the permissions on the objects.
>
> S
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Barwick | 2019-07-24 01:54:44 | Re: Default ordering option |
Previous Message | Adrian Klaver | 2019-07-23 23:36:27 | Re: pg_dump schema in pg11 without global permissions |