Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Adrian Klaver
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

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Adrian Klaver
On 7/23/19 4:17 PM, Sergey Koposov wrote: For some reason I see when I just have a command  like this it doesnt' have a grant connect on database ~/soft/pgsql_install/bin/pg_dump -U skoposov -h localhost -n xx   --no-tablespaces test1 but when I add  '-Fc' flag to pg_dump, I can see 'grant conn

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Sergey Koposov
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 s

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Tom Lane
[ hey guys, please trim your replies ] Sergey Koposov writes: > On Tue, 2019-07-23 at 16:04 -0700, Adrian Klaver wrote: >> That is only supposed to happen if you use -C(--create) and I am seeing  >> that in your examples. > For some reason I see when I just have  > a command  like this it doesnt

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Sergey Koposov
On Tue, 2019-07-23 at 16:04 -0700, Adrian Klaver wrote: > On 7/23/19 3:58 PM, Sergey Koposov wrote: > > > > On Tue, 2019-07-23 at 15:52 -0700, Adrian Klaver wrote: > > > > > > On 7/23/19 3:42 PM, Sergey Koposov wrote: > > > > > > > > > > > > On Tue, 2019-07-23 at 15:37 -0700, Adrian Klaver wrot

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Adrian Klaver
On 7/23/19 4:04 PM, Adrian Klaver wrote: On 7/23/19 3:58 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:52 -0700, Adrian Klaver wrote: On 7/23/19 3:42 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:37 -0700, Adrian Klaver wrote: On 7/23/19 3:23 PM, Sergey Koposov wrote: On Tue, 2

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Adrian Klaver
On 7/23/19 3:58 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:52 -0700, Adrian Klaver wrote: On 7/23/19 3:42 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:37 -0700, Adrian Klaver wrote: On 7/23/19 3:23 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:21 -0700, Adrian Klaver wr

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Sergey Koposov
On Tue, 2019-07-23 at 15:52 -0700, Adrian Klaver wrote: > On 7/23/19 3:42 PM, Sergey Koposov wrote: > > > > On Tue, 2019-07-23 at 15:37 -0700, Adrian Klaver wrote: > > > > > > On 7/23/19 3:23 PM, Sergey Koposov wrote: > > > > > > > > > > > > On Tue, 2019-07-23 at 15:21 -0700, Adrian Klaver wrot

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Adrian Klaver
On 7/23/19 3:42 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:37 -0700, Adrian Klaver wrote: On 7/23/19 3:23 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:21 -0700, Adrian Klaver wrote: On 7/23/19 3:19 PM, Sergey Koposov wrote: Hi, I'm trying to copy a schema from one PG databa

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Sergey Koposov
On Tue, 2019-07-23 at 15:37 -0700, Adrian Klaver wrote: > On 7/23/19 3:23 PM, Sergey Koposov wrote: > > > > On Tue, 2019-07-23 at 15:21 -0700, Adrian Klaver wrote: > > > > > > On 7/23/19 3:19 PM, Sergey Koposov wrote: > > > > > > > > > > > > Hi, > > > > > > > > I'm trying to copy a schema from

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Adrian Klaver
On 7/23/19 3:23 PM, Sergey Koposov wrote: On Tue, 2019-07-23 at 15:21 -0700, Adrian Klaver wrote: On 7/23/19 3:19 PM, Sergey Koposov wrote: Hi, I'm trying to copy a schema from one PG database (ver 11) to PG 10. Previously the first database version was 9.6 and the way I did the copying was

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Sergey Koposov
On Tue, 2019-07-23 at 15:21 -0700, Adrian Klaver wrote: > On 7/23/19 3:19 PM, Sergey Koposov wrote: > > > > Hi, > > > > I'm trying to copy a schema from one PG database (ver 11) to PG 10. > > Previously the first database version was 9.6 and the way I did the copying > > was > > > > ssh -o Comp

Re: pg_dump schema in pg11 without global permissions

2019-07-23 Thread Adrian Klaver
On 7/23/19 3:19 PM, Sergey Koposov wrote: Hi, I'm trying to copy a schema from one PG database (ver 11) to PG 10. Previously the first database version was 9.6 and the way I did the copying was ssh -o Compression=no user@host '/opt/pgsql/bin/pg_dump --no-tablespaces -n schemaname -Fc  -U dbadm