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 1jr16K-0006AQ-94 for pgsql-admin@arkaria.postgresql.org; Thu, 02 Jul 2020 15:26:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jr16J-0000dD-6n for pgsql-admin@arkaria.postgresql.org; Thu, 02 Jul 2020 15:26:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jr16I-0000cU-QU for pgsql-admin@lists.postgresql.org; Thu, 02 Jul 2020 15:26:10 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jr16G-0007tv-Qh for pgsql-admin@postgresql.org; Thu, 02 Jul 2020 15:26:09 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 863755F79F; Thu, 2 Jul 2020 11:26:08 -0400 (EDT) Date: Thu, 2 Jul 2020 11:26:08 -0400 From: Stephen Frost To: Praveen Kumar K S Cc: pgsql-admin@postgresql.org Subject: Re: [HELP] Issue with standby server using WAL archive Message-ID: <20200702152608.GQ3125@tamriel.snowman.net> References: <20200702141444.GJ3125@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="CC7kGhlJjTyMjSRG" 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 --CC7kGhlJjTyMjSRG Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Praveen Kumar K S (praveenssit@gmail.com) wrote: > I'm using 9.6 That's quite old- I'd strongly recommend that you look at using a newer version. > I have 3 servers. Let us call it pg1,pg2,pg3 >=20 > pg1 is master > pg2 is hot stand by > pg3 is a DR server which doesn't serve any requests. hot_standby is not > enabled in postgresql.conf on DR server. If hot_standby isn't enable then you won't be able to connect- which is entirely fine, but if that's what you want then I'm not sure what the error is that you're concerned about..? > pg1 and pg2 are in the same network and are in sync. Ok. Note that having only one replica when you're using syncronous replication will lead to a situation where, if either node fails, the database system won't accept writes. > I followed official documentation and used the cp command. Are there any > other best approaches ? The documentation provides an example of how to use the command, using 'cp' isn't actually recommended. I'd strongly suggest you look at proper backup/archiving solutions for PostgreSQL like pgbackrest to use instead. Thanks, Stephen --CC7kGhlJjTyMjSRG Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJe/fyQAAoJEO1sijiDR2RVwnMQALRh/bTYjmPl+Avkz3foeeMI PSLFLlQ5A/dstlWK8yu37sWvlgw7D+k5zD1pVGvrCVUK8ECNi6qV8WlUOLAmTmY/ 3gxMHTDLFxIqFapg5p7ViM9HXN0kDz0XAN5tQ5lBN14erA6Bl8hzLCbDBj6Q3EhO h2rnqBkbsTJQVDSkgzcV2tkAw+kouhOkwGN9bmOIcOjWf+H59CLtpvuSJOFuURdL e+/UfcBa2KwA6XqRgzpEy57q1y1r2IT0ugJxG+kBj+CI1YTlfl+T6je1L7pn0wcX vwObcDfY1E8DCLfLW9BQUj1KfSPEcC19SA3AkBXnRIKKurRZQ/jUjwNDVJwSM2e2 PoZixLa4UKryqdg326OM9/HtvvzbYfXvuRsw/ovBvKcWwVhJZ8k88stl0D5hyjgi oNtV2SiV+UlM0kfr/BFTu969CECNVTc7sBGGTAOc6G6/W9JohcwPUnuLEvuy33rq fAwZtaYY4PiMG5gcgnOga4t5X9MS/ucfMvMtXmSZFUfD/5kO0Mj6vo2OOYP0fXhD MeGjNIfT7nnf711ZlU3vsIUIB3Hjtv9C9P2UCS+N2RsBoSvZuAJ+tfwk7RVowiN3 OrfTtwduOf+6dJ5KzWG4wvFwStmOzCK4X5g9Nnp4KLYWXhYX1iIdK1RYyyITr03n f63mjbdbVkeFhdqn2I9W =1rjP -----END PGP SIGNATURE----- --CC7kGhlJjTyMjSRG--