Re: Sync replication - Mailing list pgsql-admin

From Azimuddin Mohammed
Subject Re: Sync replication
Date
Msg-id CAKUuFd5GCiJip8q8QOMQL0bZUBDbGnXTNJVxoLzhKe0+nwZo_w@mail.gmail.com
Whole thread Raw
In response to Re: Sync replication  (Rakesh Kumar <rakeshkumar464@aol.com>)
Responses Re: Sync replication  (Rakesh Kumar <rakeshkumar464@aol.com>)
Re: Sync replication  (Rakesh Kumar <rakeshkumar464@aol.com>)
Re: Sync replication  (Stephen Frost <sfrost@snowman.net>)
Re: Sync replication  (Stephen Frost <sfrost@snowman.net>)
List pgsql-admin
So untill my slave comes up master does not commit any transaction which means technically my db is non operative?

On Jan 25, 2018 12:23 PM, "Rakesh Kumar" <rakeshkumar464@aol.com> wrote:

>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.

pgsql-admin by date:

Previous
From: Jorge Daniel
Date:
Subject: Re: OOM Killing on Docker while ANALYZE running
Next
From: Rakesh Kumar
Date:
Subject: Re: Sync replication