pglogical - how to use pglogical.conflict_resolution

Started by xujianalmost 10 years ago2 messages
#1xujian
jamesxu@outlook.com

Hello, I setup the logical replication with pglogical on pg95, it works fine, however, I want to set the conflict resolution according to the document below=====================The configuration of the conflicts resolver is done via the`pglogical.conflict_resolution` setting. The supported values for the`pglogical.conflict_resolution` are:
- `error` - the replication will stop on error if conflict is detected and manual action is needed for resolving======================
I got errortest3=# select pglogical.conflict_resolution('error');ERROR: function pglogical.conflict_resolution(unknown) does not existLINE 1: select pglogical.conflict_resolution('error');
Does anyone know how to use the function pglogical.conflict_resolution? I googled , but didn't find anything value.
Thanks.
James

#2xujian
jamesxu@outlook.com
In reply to: xujian (#1)
Re: pglogical - how to use pglogical.conflict_resolution

sorry, please ignore it.It is a setting, not function, I can set it withset pglogical.conflict_resolution = 'error'
thanks
JamesFrom: jamesxu@outlook.com
To: pgsql-hackers@postgresql.org
Subject: pglogical - how to use pglogical.conflict_resolution
Date: Wed, 17 Feb 2016 18:30:35 -0500

Hello, I setup the logical replication with pglogical on pg95, it works fine, however, I want to set the conflict resolution according to the document below=====================The configuration of the conflicts resolver is done via the`pglogical.conflict_resolution` setting. The supported values for the`pglogical.conflict_resolution` are:
- `error` - the replication will stop on error if conflict is detected and manual action is needed for resolving======================
I got errortest3=# select pglogical.conflict_resolution('error');ERROR: function pglogical.conflict_resolution(unknown) does not existLINE 1: select pglogical.conflict_resolution('error');
Does anyone know how to use the function pglogical.conflict_resolution? I googled , but didn't find anything value.
Thanks.
James