Обсуждение: pglogical - how to use pglogical.conflict_resolution

Поиск
Список
Период
Сортировка

pglogical - how to use pglogical.conflict_resolution

От
xujian
Дата:
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 error
test3=# select pglogical.conflict_resolution('error');
ERROR:  function pglogical.conflict_resolution(unknown) does not exist
LINE 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

Re: pglogical - how to use pglogical.conflict_resolution

От
xujian
Дата:
sorry, please ignore it.
It is a setting, not function, I can set it with
set pglogical.conflict_resolution = 'error'

thanks

James



From: 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 error
test3=# select pglogical.conflict_resolution('error');
ERROR:  function pglogical.conflict_resolution(unknown) does not exist
LINE 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