Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eesiG-0004Vn-DQ for pgsql-admin@arkaria.postgresql.org; Fri, 26 Jan 2018 01:21:52 +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 1eesiF-0005dJ-Qh for pgsql-admin@arkaria.postgresql.org; Fri, 26 Jan 2018 01:21:51 +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 1eesiF-0005cy-Ii; Fri, 26 Jan 2018 01:21:51 +0000 Received: from tamriel.snowman.net ([96.255.250.162]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eesi9-0007Ne-Er; Fri, 26 Jan 2018 01:21:48 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id B91A85F79C; Thu, 25 Jan 2018 20:21:43 -0500 (EST) Date: Thu, 25 Jan 2018 20:21:43 -0500 From: Stephen Frost To: Azimuddin Mohammed Cc: Rakesh Kumar , pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: Sync replication Message-ID: <20180126012143.GB2416@tamriel.snowman.net> References: <1612e8fd701-1722-18849@webjas-vae073.srv.aolmail.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="6WadCLBIER+TiQcx" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --6WadCLBIER+TiQcx Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Greetings, On our mailing lists, we prefer that replies be in-line and ask that users not top-post. Please see my response, in-line, below. * Azimuddin Mohammed (azimeiu@gmail.com) wrote: > So untill my slave comes up master does not commit any transaction which > means technically my db is non operative? That's correct, which is why it's encouraged to have multiple replicas configured when using synchronous replication. In v10, it's possible to specify how many synchronous replicas are required to have acknowledged a given transaction before a COMMIT is returned to the applicaiton. Please review the documentation here: https://www.postgresql.org/docs/current/static/warm-standby.html#SYNCHRONOUS-REPLICATION Thanks! Stephen --6WadCLBIER+TiQcx Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJaaoKnAAoJEO1sijiDR2RVM5kP/20K+9ZxNYEqQYuJl3RMkfHc qC4pkAxbdbSQ5pdOea3azjKHsJpwrsvuTVkaEGUcMnw1mEWEeeoGf9kKTgTwq7Cz Ok5FaPKNS3+cGVoR+TzQ/rJc1p/HnQHfeex+c4N0sulCbm4ruX/+DwkXYDHXhJ7p NPt8fC0BTIvCmxBuPyLM9drE3BHnVTlVBbUEdntzp5kkG7dT1iMz9NdQOEb9bgGA PXqx9MS4t1In4uLhQDIqmtz5xpxmUVYPluj6OnwmnWsIvVQYOxwvjv76ONIwtMHd 4Qdo0HuflTYv0FRLOWbpUbstzBi0APNTxTInJYsqHFcjlE1NDt6Ssc8S6imUmPqW VL/WGWdJhv7VMXfN7q03raaNGfB+tpz5dLJYX+YQVnRgzI0Zp0oPLKq4smOCAxGm ofESzNF/mnheYbijjuHQiKTmn4U/h+FlTjDXpsAOAep/zBtIOKZ//fTSEW5myHFa xHIa2GYobSZCnOyqts3lWgA8iEMjHZKMHWWD6ZMoS26esl8hqu6PqJ6RGT59bcfL /k+EJexqqR+1Fm+w5X+kifYIQKg2tg/d739StFe8rQKxVqMQ0vsSn++6ScFDn6QQ ziqFTMtoarg59QhHtwLQ03jnfv75Fa8QbFUPua8FcnJy63/cH1HZsnqIyCbgwRXn /un+sTTPBKil1tWYxw+X =pZWu -----END PGP SIGNATURE----- --6WadCLBIER+TiQcx--