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 1ktxfh-0003yg-2G for pgsql-admin@arkaria.postgresql.org; Mon, 28 Dec 2020 18:55:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ktxff-0001Wf-IL for pgsql-admin@arkaria.postgresql.org; Mon, 28 Dec 2020 18:55:07 +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 1ktxff-0001WQ-9r for pgsql-admin@lists.postgresql.org; Mon, 28 Dec 2020 18:55:07 +0000 Received: from sonic309-14.consmr.mail.bf2.yahoo.com ([74.6.129.124]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ktxfc-00007p-4e for pgsql-admin@postgresql.org; Mon, 28 Dec 2020 18:55:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1609181701; bh=L9CebUDwyOQsSe8UQPyS9Ciu43SxuOM+pWgoQc1HmuE=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=fr1mx4mxKHVTZ/VlHxLkC0g7QBl3H1Dc9zW/VLbjsICmF9pMq+SizhVvQr1wrmRCfzgmrTkUDa2aNzbT2bUtEE+TUxkFIHyFyL8xd8n3YeWcjGa19VnlE4AmfCDWdInyych1XnxSUR7LqcQQbK9DBI4rjsCuyLqd9wL766W8Nr2h9inCr3o01q573aiJ3IdJ27iMrM+2nHhZxwOi48D5ou5QklSLqO1Lo4owDUVdDKGSX/Okzk5jJ0FpN+8lrwTgGdygJxIv8yDy7fyWSS+ZJkYcxRtLaIRH8eigfwr9KLOw98k1wvrDVXCv7xt8F51KJwIKODgBc7o8e/FG9abjwg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1609181701; bh=uIJ6rXvYgbkjtmX6qsy+KDB7O8WaoQc0X9uZ9eI/cX8=; h=Date:From:To:Subject:From:Subject; b=c3PNz13K+TAx436uKVIJCqCNzCMbktHv7uK/ybAKW0SCrBTHK4T4sQaULXnJZzG02fVOVvHPB05AznasQusiYMNXzbNTQPeZWc8/NMMVvqGMRdvihZCdrAtfW98E1zUMcJmL80A1dmQIG2hqR4yKGFn2vtYNE2UZzeGWe2nOQDSY2IGfFWkfYCs6vVtkyK4HydtsYnKVdVYb4GWDWAM9YwoJtfKp88DbU0mDliARv35coieJOa6VVukSNWKhZL9/1GVswai6C7dw3PMMI9T/Ier1lihFP7VbRwf9ByP0n/i8YyNQQVNioW8OCNVKuAMJQ/00/k11+q/MrCtBjv9+KQ== X-YMail-OSG: dEUKJ7QVM1m4FmMZmCygfA4IDv9pyG6hNiPX9cqfYYGjvIzQylEsEfzIrgPGbzU UgYNkXtL0E8QkdbwfsHxIml8hBCf4fT9D5ydlnN9Rp0zNtUXuo590ajeftXynenxDrU4TDEoxvNq xODYu22I1Sg2eltI8VRYV.FdWy.80dqRQSgfSFD.ERjjYTRu0pBBuGCJy83QQUuRKOPxKU2itET3 GCm0QOutQVPoZmTjwioU3RIyOTlrud9gwZHGXQfdIzx.FzUnR5fX2AyiWRRUUIw0JE6Zd.ezVqaE Sw_bz50lWJagJ3qpY6bbpsus1lF22v2IhW2olVa.lvvCja3UdNmF86dQqGd3oiah7y5sxGBd4Pc1 J92WGCohAGDc_gDY7x4MrrjZv5w9OejrusBk7NWPYo3KmZVIFNXJP5akpGnVngn54LDCWvxRjmuY SDp7Ex1VHcm4zlN_yVT3L.U19rQjrNEnvxtK2vsdMusiqu9VazBVzJuLXicUz3kgBSWaaEFgSeCe 5YbThbX3QZtrkIAy_vrESK29D3e0a8iSvvmM111PCD5_av9LHIwo97Gp11WQJg8d5DHwSxPh7Xbw xwV4dkXSPGLDzIpkdJqcHQVsQZEh_L1Xlut3HRS0Z9J4zZ29sgCt34OgazmSBWxTwFTvvTRY9d0C _PMw4LYYYH29Eetqgaq2H01XHfYWffg0DjaQ2fZYyF6rZHS.hHon0cP6_Y9vOSvZEAHROtBXxOcY _4FzeRSL.dj6nflaCQViDS3wpz.ye.cFxgLz50KUVVpbapr01yNEjhSMKwAANLbLz84f1fbERhFz H0UDxR5mcfqsnKMGxhXYm5S_h0c78BG3DM4iLSZOmszo1NoNv_ekD0RYmmSQSaPUw.YBTauw92EH ibsq2mJSQenYOBeX0hds5PAfk_WuNpZqg65._UY6TtB8arISwfgg8hWVobp7RaVY83oOjaOlMz3. LlSJmn6QxhSn5d1x5elV2pzl2r0ueRK.80rmFXv74fvd3AJyG6FkesSEq5a.AvxAsYsD98Ebd7DJ p76uJJ.VE8rI2hxnWkNiruRTVv9FigxcHxwdl3XMX_ks4qWtF2k1W8wxfa1OmNEj9YQCNW3wYoUZ cXakntBj3g0oBl21auRFUwJBn7xqmaZbzNEV9zdUzvuhB4pElUiabknai95LX8XRql321zrji031 70LW35GjsXhwhSwYMC34TuT35DzjMzqYVFsoVRIGn38e7A1u1XI99ZMf5tTS.wv2MyEjAB8sH7GT tWUlPHWsFjDmDIW76Mf_BvmiEUwk.yW8TPB48jOHfhmoO1DGceu76rKGga2j2MU0A_xU8sLfLBXL V_nyEfMT3GcJuUyLkczyHCEIS_Idu3ivchwrflh4KipJ2zXlAz9pSe_V6lua68IkLb4XdK4nj3Oi PWjtl7ZzXxwSAbTj.dpd7x7xcmgKAUPqHMOOjxRSAmOsjfyg16i55vOQK8LZQfhxif5rcJ4hP030 OizgewyjryJks3NfcsN2V7RYqb259KVoX_QwWRd8V3T.iqGyQRwHsvZsq3MGh7V4R4k6e70n5Xrs NuT.ncc10IlHEWJsHBVmCr3NmRWPyu.T_Lbh65A7LLhdtj86BoU7PH5qdyYxuy7cI5AQFngu3j1w 4_Jyx3J.SB0ErTZrjBI88OkJIBiI6ya9b15gPjG1RYOZMp2O7i38LOiBkUgiVRhhKqp1BTW79GVH cyR2ECti_gguZYJd1L3Wk0PR60GsaLAJDVNCJnpO73JonU_dIQJs8.eyB6_SR2WE7I_YaAlysVcU 7umc175kcl.Qf7l6Ox_T235FnZGv5F2T_xowTZQAPkGsfxmojSGgAhmqy.YAgP9VXUwazEX1KTV3 BD65O6CY1V5doUR5cpQ4Tja_iVwQT1c5AnpDFdVNzuIXBATXH_FdfvTo2DQl01UO6De90gD_tuhk zqzsVnZkWMgDiaYE7iuHywJccv0dLJemQ8JHPcMZtIkgJfJrp427kNowVuopo8GWjdvjAf9fdGkk 8BGR4UJMwNiA7pEZDudiG.UpDztefFdhjkcOYNMtvRgoZTejzm_3thYAFhUpdQDPMGEkp1TeHo0w .cFNGqXteCianywrVBUCoSMFhL1xOf8lhso6V8LX_M9H.6gCseZbQSWt2tdiWB23jzS93obcga.v seBs2Jfqc5kHprIxxwjvJxiDcuw58lVKTXk2M6jUdRZwpHB0o6GQ42VQ2PvvoBmYH2FrXa_HHkTx _DPB_.EnY2nkr.uQly6QwmfVhwz8kXzU4yBI8ZmSVTpejwfNgPpMVIYmjkr_w_28ji5wrl1oW_kF 29yFS9DMgVGpHxguWLbpvNgEUO0Oduw3JLhlX.FeBE4d5vSQabrWAogiCbombXcNnM4LsvgJJJQ0 5zmRG6eFuCiSGCDHotxV82y7poTSwFXMOOz8rYaDqYjcCtlm6xbhzA.pBBG2U6fvgdhVgzULtIUv GzYl_yEjreqIZGYOno5jahbRwNhEuH5f7stAJjNG8G9sVD6TBibQdTCaOjuDd.kOMHgboSrUknGC K4xxrelftO20E2NxgMsgyh0Wt Received: from sonic.gate.mail.ne1.yahoo.com by sonic309.consmr.mail.bf2.yahoo.com with HTTP; Mon, 28 Dec 2020 18:55:01 +0000 Date: Mon, 28 Dec 2020 18:54:59 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Amine Tengilimoglu Cc: Pgsql-admin Message-ID: <611218422.3134435.1609181699910@mail.yahoo.com> In-Reply-To: References: <984856653.599807.1609180184705.ref@mail.yahoo.com> <984856653.599807.1609180184705@mail.yahoo.com> Subject: Re: how to fail over slave to master MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3134434_1871792198.1609181699908" 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: 12682 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_3134434_1871792198.1609181699908 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Version 12 and can you show me step by step what needs=C2=A0to do?=C2=A0 I = found a document in version 10 to promote salve to master with pg_ctl and c= reate recovery.conf.=C2=A0 Recovery.conf is not existed in version 12 but i= n version 1. Do I need to run pg_ctl in slave server?=C2=A0 Create recovery.conf in mast= er, but master is a failure right now.=C2=A0=C2=A0=C2=A0 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 =20 On Monday, December 28, 2020, 01:38:10 PM EST, Amine Tengilimoglu wrote: =20 =20 You need to promote standby server, you can do that pg_ctl promote command= . And also you need to use pg_rewind command for setup the old master as a = standby server. So you can start with investigate pg_ctl promote and pg_rew= ind... 28 Ara 2020 Pzt 21:29 tarihinde Pepe TD Vo =C5=9Funu yaz= d=C4=B1: 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 =20 ------=_Part_3134434_1871792198.1609181699908 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Version 12 and can you show me st= ep by step what needs to do?  I found a document in version= 10 to promote salve to master with pg_ctl and create recovery.conf.  = Recovery.conf is not existed in version 12 but in version 1.

Do I need to run pg_ctl in slave server= ?  Create recovery.conf in master, but master is a failure right now.<= /span>
 = ;  

= Bach-Nga

No one in this worl= d is pure and perfect.  If you avoid people for their mistakes you wil= l be alone. So judge less, love, and forgive more.=3D"Emoji"3D"Emoji"3D"Emoji"
To call him a dog= hardly seems to do him justice though in as much as he had four legs, a ta= il, and barked, I admit he was, to all outward appearances. But to those wh= o knew him well, he was a perfect gentleman (Hermione Gingold)

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



=20 ------=_Part_3134434_1871792198.1609181699908--