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 1ktxHH-00039S-DU for pgsql-admin@arkaria.postgresql.org; Mon, 28 Dec 2020 18:29:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ktxHG-0003Aw-9c for pgsql-admin@arkaria.postgresql.org; Mon, 28 Dec 2020 18:29:54 +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 1ktxHF-0003Ap-Pf for pgsql-admin@lists.postgresql.org; Mon, 28 Dec 2020 18:29:54 +0000 Received: from sonic311-14.consmr.mail.bf2.yahoo.com ([74.6.131.124]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ktxHB-0008HC-U6 for pgsql-admin@postgresql.org; Mon, 28 Dec 2020 18:29:53 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1609180185; bh=k5wWpdX6/YJCcNZb1ZV0Qnn+XkwdrK+0zLythFIcnUU=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=E34fItu3WEkqEkMQ2Biq0DQpS4dIeCbM2y+Mg96SfQLxnX9/vuWGk/OdLXY5Kmog9tCDdxyq6jsBkPX9IG+iM3ApUReC9sH2PmmEW590O1jr+XZWVk9cgv4+DPKMxUSzVQdyMPvrL1RBJj7vIeKYBVMF8hW3XmCNfabDzaFKpip2KXQfHLewrlCqbqszWooaHNhGkEbmf9xhFNbt94tVvnm8oIScAGWvsDHeSftAGrr+7IMhY+KQ6kJKo/OfNh4UaIObaZA2L7FdGAywGVx/62EFJ9qVSiiF1Fmg+TA7NU+LQyG9TEYSssg+gqG/OB0XjbB9KEm+b/FejfiLRF1JIg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1609180185; bh=g4zMxwqpPMXxXmxsnl5lVeBk69eSeNH1wiF8FJa+u0z=; h=Date:From:To:Subject:From:Subject; b=XSxQVYm3WGHZY7830Ki8R7b3O8gRy0ynRW9wo7Cwg7u9uy/moHFwPK4vW7HY2so3kQ7XqBoeqK+nrFvHhlTw5Q4MpsXZ2spHOTT9MRbdCkrk2pfs52wlCw/9zZbhjB4O3B7f7qkUQgOZCKp6HwPIRNla44Rtdi63D+H5OtfkXquhuCMe846rn+w8SvDLgg/21UVrpBcteJ4GbDjtut17qY7NmRaNnKj7j4amtbuwHqWMbpzoZmc//UsqjBxxG1OlAG5OmfAMF6FK0wCR8taXUym3rhFNOxPEwGwF5t+PPa1l57HXo9DkBfMK3/lgQybhK6VZNce8t5f2aNAs1FIbqg== X-YMail-OSG: Ux6zYKEVM1l9vTY8t6jnvqJ50cCsMregWjKYqrhgFsyaRtSiv3bPHduwTfljjLu BeOMMFu9M.3Nu1D9kzFUWvMn_MNBbDHJpfVjPVSlF9b2WfS7K3E5lyAdhSC1R_e7STLLGygdSpFu liUfOucbBHipCr1TeLXHjEfdHryXL4aBbHmEh_uABk8PloAPNZbkgFNzC377KdsSAakr7u0QwsJD hun_kcWEjCZ2zxILNv9sGclrWJwkrlp.A55b6IydjAL8EEr.fRG6u0CgLHVrFnxTtDvbjnCa1I0V 5I2DnhOG_SAAapoasUUqYNYHTdLYYjLKAOXUD24Zzs3NCVPBti5q6XfG1zJaaWko7.EPJZwPeRGR RwKMX_Az.DX7L1SEbaLJNNrcEfE6jYM.Y_0YIkq85Hul_fUHa3HHVbMu0SmUtlsQPojwGwCVvrKi 8mCol6lMRL18LweLAk3XJQZM9vfiUNWf4DkJsad2X0mIwUkWyqzUU5zlylACGtjICquaJkj6vig6 KG570w_rSKK3M6JNPmN8DNsahb4EthBNRXYD7WeCemolEAS.fZ4morwYmrAOPxPmPu4l_djyWQ3h sXWxYdxizB7rBd5pZyEnBnkLCxwnvGkFi18.xaMKNRddH6h0BuhUtpQMCrinyWV619b2Y4btNW47 i8hhgAJ_Xwg1dvKUHgfKoRFNrerZ10vjBfjGNRAcE2yE65QXitOaMDgVc6Fa0WitGgARk4f8lu1S JnBh1S8OzwRxMm8g9ZSJEUlLzKrqMephku3kvGrdTBAMENelK80GJaUJkKnj_c2nzqv8wEZwxt82 YL1KjxTEdI9dQKtHtWuBcQ5A5wNxxFwCZcUuMiU6diF8v6SuwNhlIPFUjd1Rjw9jsRoZw.sek90w 3pviWMiiDTOPUp4RiLBMVj7fyJgzb_xhYR_V23WV4w9q6_pr3C98HyPxOGTP3hhKW5aqJlmHQv.c ku_T3uk22kaX8FjK6e0RDnV18NZV_Q9KSX4mG3bZn.b7ap0DCofZJD0A_iOoBEyP5o3wo7su1qOO i6yuiN9OGWkchV6wCE4lCUZLMyrr0oeB1cbiluYQhv3ITCxxpPMgpDMD7ZLxBYWGYpy4M2ek_sdg NxW5zF6.x35215pMQ5Ed2hYlVix2K_iDYFNZwemxhR0_KLB9VN9OagIWOUDD3Y2lYtSBskJ7axJ3 vtHY7uBpYMCDKxIxQo7uMeNVGvJgF8VAiNJ7P1RvI7yT9eEEfgKeXaACDELRZEpxeXF_p_6kzD04 X7G6b9rU1QP9RaajeRj78DfSZ3Imqqkw2WmbVlrWiv2._I_Tqt17sr4.uk92ICayUzgfs_jqMPnz raIpwTYwu.3GAifY56VqZFA.LnO_m2VcHPPb3yVx5Nq5X4fCEExH6pjC1ErDCil_5Pl8.0_HWhpF VocaRDf1Xz3.jR8mTj6661hzKK3cC13yr_6X_dKQcgS46RD7eVyPXrBMQyYf8RgNNwZfbHULoJUQ v8Fo5zpXypbwVjZbz82V2MRhFkA43dSoJIUcnYJGqC6EwS3LvCulbiN_2xA7SC9r6IUJ_.b02Xfk tS6b1Ix3pvEiI2skJ5B.AftF69fMIr.WNy1V2WEKWIavC3od7xKDDris9jTcI94dkN449I5JSJli 10E2SOR3NeHhDk6Rhdt8lYC.jyHKT8iHOHpwCC7aLNeLTNBcI5Atgnku5P2p_41A95yPKbcxWsdf y0VYQTD3wycB9twruKP5hbcGZZqRc50Hy19sDG8gL1R3A4sXfnUb588yFQlk48_XjwgGNR1_NA_l huxyfOEceQO5SZYzaPrbM0Uk43KOpoDbhx0QFrXtY_vScw2tiZpI5KKkSZwzF0f2bCLuD_XHxKC6 zvIMaX72y1rWxKzg2TOiBnKy6aM8ZyvrHDcEKp7iWAPd1eoDTJJYDgKP3wExF3coERA3GpvP7Fwl U9mDFFBgpgPy_yxKNKnQRBy9NlgpYGAnHRkgLahu8OdWoweCIXSmJeG98jbuB3.PtbI2Y8.sfwdv 4TzD.dC5gpmDWQ3JHkiSUvmbO5KjyO1z0puNE3hWq21FYbP8U59WGT_auDVnUvQLEJXgWXrrGahU yHGxrl_Tz.KmhYUuxVIjo98VcRseQaD2V1NSaYM1wuIWqISVroX2il7TSFg00nELXdnn09XCVK3t eHMBZVVp9Zyt6CsiWUeG4Mo4nJ7QNMyvGAqq7A.GIxcXltbFGC8Me8XjI04S_ftMSjwG7ovcZEkq 7h3BoWR2aLUbuQUV4omPz9hIntX50IBEYLZnASqSG_5PR9beNXXCG28dPT3LYMHPHS9KHu1nW._c aUrbRSx_vtbOQgpRyqMAqE35ZXpcsU3bQvKA4mppsm9MYXzY4NLz5RRBvLXr8DPWxRN6ZwQljced EKk7g6VfHyN4XhmmbD3EWTNpy41kzHuR4t5SQLMMP1h.fRaq5stXsJ2ImpDhGPtp9KUb8mp06g.A - Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.bf2.yahoo.com with HTTP; Mon, 28 Dec 2020 18:29:45 +0000 Date: Mon, 28 Dec 2020 18:29:44 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Pgsql-admin Message-ID: <984856653.599807.1609180184705@mail.yahoo.com> Subject: how to fail over slave to master MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_599806_685322489.1609180184704" References: <984856653.599807.1609180184705.ref@mail.yahoo.com> X-Mailer: WebService/1.1.17278 YMailNorrin Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36 Content-Length: 6052 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_599806_685322489.1609180184704 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello, I have a problem with my master's Postgresql service.=C2=A0 I can't start u= p Postgresql, something corrupted and the Postgresql service is down.=C2=A0= The slave is still up and running, I wonder how to turn slave to primary a= nd fixing the master server.=C2=A0 Once the master server is fixed, how can= I fail it back? Please advise. Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love, and forgive more.To cal= l him a dog hardly seems to do him justice though in as much as he had four= legs, a tail, and barked, I admit he was, to all outward appearances. But = to those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success ------=_Part_599806_685322489.1609180184704 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello,

I hav= e a problem with my master's Postgresql service.  I can't start up Pos= tgresql, something corrupted and the Postgresql service is down.  The = slave is still up and running, I wonder how to turn slave to primary and fi= xing the master server.  Once the master server is fixed, how can I fa= il it back?

Please advise.


Bach-Nga

No one in this world is pure and perfect.  If you avoid = people for their mistakes you will be alone. So judge less, love, and forgi= ve more.3D"Emoji"3D=3D"Emoji"<= /div>
To call him a dog hardly seems to do him justice though in as= much as he had four legs, a tail, and barked, I admit he was, to all outwa= rd appearances. But to those who knew him well, he was a perfect gentleman = (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** = Sharing success


------=_Part_599806_685322489.1609180184704--