Re: Sync replication

From: Rakesh Kumar <rakeshkumar464(at)aol(dot)com>
To: azimeiu(at)gmail(dot)com, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Sync replication
Date: 2018-01-25 18:23:54
Message-ID: 1612e8fd701-1722-18849@webjas-vae073.srv.aolmail.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

>I have a question regarding synchronus replication.
>If i have a master and standby server will sync replication setup..when my slave dies and master is still active. Will the transaction completes, or >master will wait for slave to commit the transaction and then commits its. ?

Master will wait for slave to come back up. PG"s replication is not the same as SQLServer/DB2/Oracle
where they allow master to continue operating while the slave is down. useful during scheduled maintenance.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jorge Daniel 2018-01-25 19:16:09 OOM Killing on Docker while ANALYZE running
Previous Message Azimuddin Mohammed 2018-01-25 18:06:49 Sync replication

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-01-25 18:51:08 Re: AFTER UPDATE trigger updating other records
Previous Message Azimuddin Mohammed 2018-01-25 18:06:49 Sync replication