Doubt about config file for synchronous bi-directional replication between 2 nodes - Mailing list pgsql-admin

From Ruth Melendo
Subject Doubt about config file for synchronous bi-directional replication between 2 nodes
Date
Msg-id 003701d054ef$aeae7490$0c0b5db0$@teltronic.es
Whole thread Raw
List pgsql-admin

Hi again,

 

¿Is this configuration correct for a synchronous bi-directional replication between 2 nodes? Asynchronous is the same but without the property “synchronous_standby_names “?

 

SC-GIS-WF-01

port = 5432

wal_level ='logical'

max_replication_slots =  3

max_wal_senders  = 4

synchronous_standby_names =’SCGISWF02'

shared_preload_libraries = 'bdr'

bdr.connections='SCGISWF02'

bdr.SCGISWF02_dsn = 'dbname=test3 host=172.26.110.87 user=postgres password=postgres port=5432'

track_commit_timestamp = on

 

SC-GIS-WF-02

port = 5432

wal_level ='logical'

max_replication_slots = 3

max_wal_senders  = 4

synchronous_standby_names =’SCGISWF01'

shared_preload_libraries = 'bdr'

track_commit_timestamp = on

bdr.connections='SCGISWF01'

bdr.SCGISWF01_dsn = 'dbname=test3 host=172.26.110.86 user=postgres password=postgres port=5432'

bdr.SCGISWF01_init_replica = on

bdr.SCGISWF01_replica_local_dsn = 'dbname=test3 host=172.26.110.87 user=postgres password=postgres port=5432'

 

Is there any property left I´m missing? I get locked the database very often and I think it´s maybe because of any property I missed at configuration time…

 

Thank in advance!

 

Ruth Patricia Melendo Ventura

Software Engineer

TELTRONIC, S.A.U.

T: +34 976 465656   Ext. 179

F: +34 976 465722

www.teltronic.es

 

Logo40

 

Before printing this e-mail please consider your environmental responsibility.

*****  DISCLAIMER  *****

This message is intended exclusively for the named person. It may contain confidential, propietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. Your must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorised to state them to be the views of TELTRONIC. If the addressee of this message does not consent to the use of internet e-mail, please communicate it to us immediately.

 

Attachment

pgsql-admin by date:

Previous
From: "Ruth Melendo"
Date:
Subject: Re: PostgreSQL with BDR. Problems when adding a sequence in a table column
Next
From: Sergey Shchukin
Date:
Subject: Re: Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary