From: | "Ruth Melendo" <rmelendo(at)teltronic(dot)es> |
---|---|
To: | "Technical Doubts" <online(dot)technicaldoubts(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Doubt about config file for synchronous bi-directional replication between 2 nodes |
Date: | 2015-03-02 13:49:19 |
Message-ID: | 003701d054ef$aeae7490$0c0b5db0$@teltronic.es |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
<http://www.teltronic.es/> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Sergey Shchukin | 2015-03-03 13:54:49 | Re: [GENERAL] Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary |
Previous Message | Ruth Melendo | 2015-03-02 13:27:23 | Re: PostgreSQL with BDR. Problems when adding a sequence in a table column |