Re: pglogical in postgres 9.6

2018-02-13 Thread Jeremy Finzel
On Tue, Feb 13, 2018 at 1:46 PM greigwise wrote: > No need! I figured it out. > > Had to put this "synchronize_data := false" on the create_subscription > call. > Weird that there seem to be redundant parameters for this; one on the > replication set add and one on the create subscription. Mayb

Re: pglogical in postgres 9.6

2018-02-13 Thread greigwise
No need! I figured it out. Had to put this "synchronize_data := false" on the create_subscription call. Weird that there seem to be redundant parameters for this; one on the replication set add and one on the create subscription. Maybe I'm not quite understanding the usage on those or something

Re: pglogical in postgres 9.6

2018-02-13 Thread Adrian Klaver
On 02/12/2018 06:09 PM, greigwise wrote: hireology_tmp=# \dx List of installed extensions Name | Version | Schema | Description --+-+--+

Re: pglogical in postgres 9.6

2018-02-12 Thread greigwise
hireology_tmp=# \dx List of installed extensions Name | Version | Schema | Description --+-+--+

Re: pglogical in postgres 9.6

2018-02-12 Thread Adrian Klaver
On 02/12/2018 04:46 PM, greigwise wrote: I downloaded from git and compiled from source. Based on the pglogical.control file, it appears to be 2.0.0. Is there a better way to determine the version? Should have added that you need run the \dx in the database you installed pglogical into.

Re: pglogical in postgres 9.6

2018-02-12 Thread Adrian Klaver
On 02/12/2018 04:46 PM, greigwise wrote: I downloaded from git and compiled from source. Based on the pglogical.control file, it appears to be 2.0.0. Is there a better way to determine the version? In psql do: \dx Thanks, Greig -- Sent from: http://www.postgresql-archive.org/PostgreSQL

Re: pglogical in postgres 9.6

2018-02-12 Thread greigwise
I downloaded from git and compiled from source. Based on the pglogical.control file, it appears to be 2.0.0. Is there a better way to determine the version? Thanks, Greig -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: pglogical in postgres 9.6

2018-02-12 Thread greigwise
I downloaded it from git and compiled from source just today. Looks like it's 2.0.0 based on the pglogical.control file that was in the source. I'm not sure how else I'd know. Greig -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: pglogical in postgres 9.6

2018-02-12 Thread Adrian Klaver
On 02/12/2018 02:11 PM, greigwise wrote: Hello. I'm trying to get pglogical setup between 2 postgres 9.6 instances. I can get everything replicating over fine, my problem is that I can't seem to get it to work in the mode where it does not try to copy all the data over initially. On the source

pglogical in postgres 9.6

2018-02-12 Thread greigwise
Hello. I'm trying to get pglogical setup between 2 postgres 9.6 instances. I can get everything replicating over fine, my problem is that I can't seem to get it to work in the mode where it does not try to copy all the data over initially. On the source side, I'm doing this: psql -U hireology