Re: Replication mode
| От | Rui DeSousa |
|---|---|
| Тема | Re: Replication mode |
| Дата | |
| Msg-id | 5A2DCD51-B5A2-4993-9884-6839FF7D610E@icloud.com обсуждение исходный текст |
| Ответ на | Re: Replication mode (Azimuddin Mohammed <azimeiu@gmail.com>) |
| Список | 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 |
| |
-----------
В списке pgsql-admin по дате отправления: