Re: pglogical in postgres 9.6

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 side, I'm doing this:
>
> psql -U hireology -d $SRCDB -c "SELECT pglogical.create_node( node_name :=
> '${SRCNODE}', dsn := 'host=localhost port=${SRCPORT} dbname=${SRCDB}
> user=logical_replication')"
>
> psql -U hireology -d $SRCDB -c "select
> pglogical.create_replication_set('dw_repl', true, true, true, true)"
>
> psql -U hireology -d $SRCDB -c "select pglogical.replication_set_add_table
> ('dw_repl', 'accounts', false)"
> psql -U hireology -d $SRCDB -c "select pglogical.replication_set_add_table
> ('dw_repl', 'organizations', false)"
> psql -U hireology -d $SRCDB -c "select
> pglogical.replication_set_add_sequence ('dw_repl', 'accounts_id_seq',
> false)"
> psql -U hireology -d $SRCDB -c "select
> pglogical.replication_set_add_sequence ('dw_repl', 'organizations_id_seq',
> false)"
>
> Note on the replication_set_add_table command, I'm sending false as the
> third parameter which should tell it to not copy over the initial data. But
> when I create the subscription on the target side, I can see in the logs
> where it is issuing the copy command. And since I have the data already
> there, I get duplicate key errors and it bombs out. Any suggestions?

I don't know what is going on, but for those that might the pglogical
version you are using might be helpful.

>
> Thanks,
> Greig Wise
>
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com