[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: pg_dump schema in pg11 without global permissions
From:       Adrian Klaver <adrian.klaver () aklaver ! com>
Date:       2019-07-24 0:10:58
Message-ID: 5d51c135-f3c4-47a2-83c8-c01eba7663e4 () aklaver ! com
[Download RAW message or body]

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.klaver@aklaver.com


[prev in list] [next in list] [prev in thread] [next in thread]