| From: | Rui DeSousa <rui(dot)desousa(at)icloud(dot)com> |
|---|---|
| To: | Azimuddin Mohammed <azimeiu(at)gmail(dot)com> |
| Cc: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Replication mode |
| Date: | 2018-01-11 01:39:00 |
| Message-ID: | 5A2DCD51-B5A2-4993-9884-6839FF7D610E@icloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Azimuddin,
Then you should look at the tools you have at hand. i.e. Using nothing but the OS (FreeBSD/CARP/ZFS), Postgres and some custom scripts.
In the postgres.conf file setup synchronous replication and the application_name in the recovery.conf file:
synchronous_standby_names = '1 (standby, witness)'
----------- -----------
| | | |
| primary |---sync--->| standby |
| | | |
----------- -----------
| |
| |
---------carp-----------
|
|
async/sync
|
|
-----------
| |
| witness |
| |
-----------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2018-01-11 01:59:27 | Re: Replication mode |
| Previous Message | Mark Kirkwood | 2018-01-11 01:37:07 | Re: Replication mode |