Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jngP4-00031c-HY for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jun 2020 10:43:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jngP3-0003o1-Cg for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jun 2020 10:43:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jngP3-0003nu-5K for pgsql-admin@lists.postgresql.org; Tue, 23 Jun 2020 10:43:45 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jngOw-0008RU-8Z for pgsql-admin@postgresql.org; Tue, 23 Jun 2020 10:43:44 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 268875F79F; Tue, 23 Jun 2020 06:43:36 -0400 (EDT) Date: Tue, 23 Jun 2020 06:43:36 -0400 From: Stephen Frost To: vinod kale Cc: pgsql-admin@postgresql.org Subject: Re: automatic switchover / switchback Message-ID: <20200623104335.GM3125@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="YC8Ek3FeOE8ywfXk" 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 --YC8Ek3FeOE8ywfXk Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Greetings, * vinod kale (vinod16895@gmail.com) wrote: > Is there automatic switchover / switchback available in postgres. Means we > wll not going to create recovery.conf and etc... > Is there a way that postgres internally manage that and perform switchover > OR switchback. > If yes then can u jst share me the steps or any link. I'd suggest you check out Patroni. Thanks, Stephen --YC8Ek3FeOE8ywfXk Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJe8dzXAAoJEO1sijiDR2RVJHwP/RFfywdFIDc0b3IhZEkrry2E bAJwid6RFNRj2CFz+FevQ29jANORVaOMhnU9EEYpZJA2AoBnZ3Fw6amyp4f+IZHe rOqUppA7Hx1K2YoFd+bTdToRJdOnMV2rI81WN9bbO0rvKPjrgE9DnQulOI8zQaq7 LRL5JSzSuPIXiP4uL4GxosHi2H2YcbopX/iOBOb0TVoAJbAd7D79eZ4k9O2KZDco 7IX7vMWpKMQNtELY74lrWI1mBQFAPsU/wn11ZDB06461NUXSrtxvURQmctRZ7gPk 7395rcg+xpnH9ubuBBNuLAt/W1Qiy1lwZwr+Ci6uXQ4EvbN3acoLACs0gzMxtslp ly6b13MqLvkxc8IAu1Or/hDqBkZN3NeBw0ut+v9FMXUyF0bhuOpIvz5j6JXZLgyl vVHRHsbs3FkA0ebtKslPdJySFOUp0G/PjXXYe/A9cNbsYB1tYCY1jKkCxjQGtiYJ zQnmgJS4Otor/7sxc0ANGsCH0o8qSv1CYUaUlyG0o/Lc6cgaxDaChnGkFFWrYb6t rkuZ13w+Rymhq9yTZxB1CzNwHZ/LvYHbf5di+UgVRIQ09l8K4VfmSIplGZNBHz58 42AhPfptxoVl0al34h6xZdSgu9arU+qmjL9V+EOw3S32xnurAMbdKf5vaPJ+2iiZ ewH55vJn7SM+li7a7wIH =EibP -----END PGP SIGNATURE----- --YC8Ek3FeOE8ywfXk--