Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eesYE-0003sV-Ca for pgsql-admin@arkaria.postgresql.org; Fri, 26 Jan 2018 01:11:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eesYD-0007BB-UA for pgsql-admin@arkaria.postgresql.org; Fri, 26 Jan 2018 01:11:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eesWr-0004wj-3p for pgsql-admin@lists.postgresql.org; Fri, 26 Jan 2018 01:10:05 +0000 Received: from omr-a010e.mx.aol.com ([204.29.186.54]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1eesWn-00073L-Eg for pgsql-admin@postgresql.org; Fri, 26 Jan 2018 01:10:04 +0000 Received: from mtaomg-aac02.mx.aol.com (mtaomg-aac02.mx.aol.com [172.27.2.36]) by omr-a010e.mx.aol.com (Outbound Mail Relay) with ESMTP id 06E6338000A3; Thu, 25 Jan 2018 20:09:58 -0500 (EST) Received: from core-aab02g.mail.aol.com (core-aab02.mail.aol.com [172.27.9.2]) by mtaomg-aac02.mx.aol.com (OMAG/Core Interface) with ESMTP id BDD3D380000A5; Thu, 25 Jan 2018 20:09:57 -0500 (EST) Received: from 69.248.80.3 by webjas-vab073.srv.aolmail.net (10.96.18.76) with HTTP (WebMailUI); Thu, 25 Jan 2018 20:09:57 -0500 Date: Thu, 25 Jan 2018 20:09:57 -0500 From: Rakesh Kumar To: azimeiu@gmail.com Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org Message-Id: <161300398bc-171e-47b6d@webjas-vab073.srv.aolmail.net> In-Reply-To: Subject: Re: Sync replication MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_382804_819624943.1516928997564" X-MB-Message-Source: WebUI X-MB-Message-Type: User X-Mailer: JAS STD X-Originating-IP: [69.248.80.3] x-aol-global-disposition: G DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mx.aol.com; s=20150623; t=1516928997; bh=RinKzve+rpLxBKtQuZvz1oS41o90kllO4gfD839e5vw=; h=From:To:Subject:Message-Id:Date:MIME-Version:Content-Type; b=GpMJWvpNtCFASmKM1m21oRSe7ndT/nj5U7YEZq+b7aEeaCVmjq5KS0SVc/hmj+kmU 6upG7CKR7Lle2y/Ac6xzl29XgJvpz+/A5hvhvtPkEQiTFq9NYGqT6ZRbfPVos0QRPX HDxg0KDYtrBNTsPj3QFioUTE80rluirkpiwl1O/4= x-aol-sid: 3039ac1b02245a6a7fe55a17 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_382804_819624943.1516928997564 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit correct. -----Original Message----- From: Azimuddin Mohammed To: Rakesh Kumar Cc: pgsql-admin ; pgsql-general 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" 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. ------=_Part_382804_819624943.1516928997564 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit 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.

------=_Part_382804_819624943.1516928997564--