Re: Replication mode - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: Replication mode
Date
Msg-id 5A2DCD51-B5A2-4993-9884-6839FF7D610E@icloud.com
Whole thread Raw
In response to Re: Replication mode  (Azimuddin Mohammed <azimeiu@gmail.com>)
List 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 by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Replication mode
Next
From: Scott Marlowe
Date:
Subject: Re: Replication mode