Re: pglogical in postgres 9.6

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

Re: pglogical in postgres 9.6

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

Re: pglogical in postgres 9.6

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

hireology_tmp=# \dx List of installed extensions Name | Version | Schema | Description --+-+--+

Re: pglogical in postgres 9.6

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

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:

Re: pglogical in postgres 9.6

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

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

pglogical in postgres 9.6

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