From: Rakesh Kumar <rakeshkumar464@aol.com>
To: azimeiu@gmail.com
Cc: pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: Sync replication
Date: Thu, 25 Jan 2018 20:09:57 -0500
Message-ID: <161300398bc-171e-47b6d@webjas-vab073.srv.aolmail.net> (raw)
In-Reply-To: <CAKUuFd5GCiJip8q8QOMQL0bZUBDbGnXTNJVxoLzhKe0+nwZo_w@mail.gmail.com>
correct.
-----Original Message-----
From: Azimuddin Mohammed <azimeiu@gmail.com>
To: Rakesh Kumar <rakeshkumar464@aol.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>; pgsql-general <pgsql-general@postgresql.org>
Sent: Thu, Jan 25, 2018 8:06 pm
Subject: Re: Sync replication
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rakeshkumar464@aol.com, azimeiu@gmail.com, pgsql-general@postgresql.org
Subject: Re: Sync replication
In-Reply-To: <161300398bc-171e-47b6d@webjas-vab073.srv.aolmail.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox