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 1kty85-0004eT-BU for pgsql-admin@arkaria.postgresql.org; Mon, 28 Dec 2020 19:24:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kty83-0002HN-Sf for pgsql-admin@arkaria.postgresql.org; Mon, 28 Dec 2020 19:24:27 +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 1kty83-0002HE-9l for pgsql-admin@lists.postgresql.org; Mon, 28 Dec 2020 19:24:27 +0000 Received: from sonic307-2.consmr.mail.bf2.yahoo.com ([74.6.134.41]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kty80-0002dl-DG for pgsql-admin@postgresql.org; Mon, 28 Dec 2020 19:24:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1609183462; bh=72nXOC6ZzrD5P3QPb1P9+nnZ8vJSMQRQC0r5aGG9NF0=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=qhkZfxyei8+VKnkwffpQkOpPbgaQIX2F3zQQnvEUJ/yJw199LVH24Q1HP7Z1ViwCVtci84CFBjqjR8pqmO20QtUYdxrZ1MPASAcSchEJtp3rZOSUkHCNUWQTM0D8eg+clGYCU06z1uEcV/evDt/9qDu+wz4okSOW5Pgv1F+pe0ywxhg6n5jplxBIUe2Cqc016KW/59TKIb5Fve/2ThJ0y5geoOSiGNjybEsHu/8gdoETZim/4zwIhTVt58jOiLB2sdlp9bFSp5ijL/ZYK3sxJO6NK/4cDcMiAxizC+1/089ju5j/fl74dxFvSEwJRccNliGfflJB9dffP3pfiz9jTA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1609183462; bh=vqDnYrJAF02/shMJicyo7bsncO83r/JpAeYC0dYCxla=; h=Date:From:To:Subject:From:Subject; b=fiK+ihzrV8BPDpSD94AVf1ESYdqcuEDnTNjS3LPBx9x9+vNp2I9YivjI9XYwhlBgK+5/N2Iuk8nuAehBnz5BTDG6jB3m3lYvCUiFwV1Ybg5BhWk2hZMMM3SS6KYxsWcI+Y8qVSqbmw0+6yqhQAOn6nFm9/tZmpeswhX/0XOxhIhs/A9U5bGtWbNDyB+dHpAnPiSSa9e053TRdPclD1rssrK9qqK7KhJD7BQDgi30KhNhthuEEdvbnlaNuwCxqzKgH53xtbcaJ8i0MxKrnJOfrQvAGjTJ7rI6sGf/oRUHCFPLchk7xRMokoI+hX9DfpwFG/Gaeq8tQGd3rWB+xiGqMw== X-YMail-OSG: DzS0obsVM1nRqP6fHiavsjgHT2pWkdpbmW9W_DTHDiOt.kq7NKA0KTEgSazOP8g 00TXMDR25xUdC.y6R6EigAGUmxFwPb.SX_fZmyVDvnsGTS2EsJQ207ATqSQ5lHrPSRef1OTw6VVr sdoZ4Eh.wQtin61y2gAhwT5R.oRXZzdy5gRPi1HIfAdodMr4iyD1OTgdiXvuJQMAREmkkmbqrgAH X2pqXKXpTqc5lSmHdPHz_pc5Er9xIAoH6bLkiuz5.eNBuFiYM0eA8wGa3uLIFPD1B6pjgE0994ve E0YgYnE3m5psfkXwelSERnI5osCSQT3OXqg8dkRYqqZ.32P32Jwh8AW2lT01iwpuMmbxZk14Ed2g QlACvbLepNl_KYz5SFn61BZ6mBYtvVIk0EdB1E5FpQzVBVwBlGzqmGfhFnEyFBGni6.oQVQ3SlJt ciWJHwfQTYHbnZtYuR.cQtYksYyfEwzCDgj4Yrp8POX_c9CgoFpmcHWFZ_ZW9U3k6xoBlg5Gfgkd GqzayNBku7HDJK6moZXCLptP7pjHjWbqMq5klxvyet7Cqq47rzMUi7iMCQNuhqhv_O_IQQDFLjlK HhQ2Vqs45EJNKj9ywJ_Gmj.i0pw.a1otmce4Ob0kkk9uwvsFKRmxgGhwcXQiUgfJeT6DVB4RUrv0 K6_2ii4pvNvCDOqaOEjKUFPmwRTnaITN1cqJ9yiRWDc6R6JeK2ACnirX1YVkiVXwxe36BGmANb1i TIgxrxxS9h4IQCVic8yxgLVDzahlNrMJonN5mFB.ocBR89GhojpqzNnbHz32DKLkKw0sxNCHSaAq Fv.RuzqYOCFMZ9AnD3qFBsQFUzwVF.DzuXZKzeg8nt.5TVC7RHf_eGAKiN54K7J1mdhisUoY4YoU iy3vIlXcvWSWJyAcbvxBgZfzA1bwGQ8_bn98uMJ.4AOWk6gHImcIs_yxtonZeoOm0YkqakXm1trt RoB_bK_LsABg4BuqeSoDGusltx6cnuy1hQJg4zN0hltBAuL6opw3rOi7IIgyzCbuAKhcEg2PSCL6 Ixrb0zXIP0FEKr.nSR_5o3IO7VxiuNs3VJfbFtEF530uNciZ.E57nU.BgCzMgqf80aPCwufm.BSO xBFGnwLCtfT43ncYPhcNc.Tj3k40LAgQBphbRkGPg4I_83PljeCC1luArw4nkYHD_eYqJpQDe4dS K8M1z3qsW.npMNhfz_5A3IuruxGy9xuSKkHDGJNrFYn0dj2bZCcWi_bcrVpRO4ilp.At.qPTGQav P5jElXADaVPYfxjaLFm7Fb_OIFWpfgJXNngcBt_y0rsLBONi9utyNZs6xyOOxZ4My5y_Js4z_vGK jz2uQkrDFaZMsF_y9R0gtzrHMY3XMQXmZOe2B_XWoUP0THy_9EFi3AAYWEsevdZqk..DEtHFFfiG 8oqeDjzeFGD7zSDUivdd9gNv3pJlwjSIaLR6c0nqe4EozBaaaIACX8xIQYHS_rEVfTNVMs5Z1A1M 11pWEYLX7NXd1gXH.xCtntbfJNACG0JcRSbHaQfQzhrm_exIiEvxO.x45lGh2rFfB2T5AuGxVmHY pvW6LgtXLuGj0ep9wH51wkBIn9U8woEuNxwq3.rgQFHW7PEUgyol.r2RrB4AP4HFKnE_W505tHIa jb7tyAPZCwbppyuqRV1aU7Vxa_jFwdhvyIJ8cAAxrR71QmABQ7Z8lh1oYTlNwuoABWeF6i967lpU MPWVDyqwxu8KzmCn2hkNv_X3840LYVru9FrBe6AyXKx1fLqIUpiA8JoNHBVML25VPYhvvMUeZpN5 GQVfjSOp0bPRcoUGXkrI2ge9F3CR5OLsQ.r4clW6v4pIt1r3bvd2ZTrgmeycdgUkYqPnYue2E8fu DFBwsJhhlYyo_y070E9qTLEqESwnO85aKVqEaXp.jSmqt3uNB6BhWgewvIco0wDid0nS3dydkcrI LVvDzNT37eFubJ9wtRew4ZjXtAHYm7avCsYNhFvlrVpmiH4g4m5s1friXz544CqfoTRfQtk8PIeu gwdfzFzq_iOWIkXqy6RGsIahWNNtgcXnqPRpqDLSi9rqYZLEdM7o6al9NwgNFn3KJfsn4rXmWbOm 507vAXwyadrALeNgNZS6Y03hSqN3Bo27U1uXnx0hlQi7wmKpi5ikCeawBZ7J66w8Xr_22YRr1p6L FUwaRXXVygGE95VGNAJrIkyrhWUABltNL3KVIdFDdrB0sR.ZM1lWZQyAQ4vNdc0B2FHAo3lonxVC JuwERK44NPQBhAcuBo1Ieohrbfjk.NJIihMzFZbTwUBCeoJu.u8Ajaq4Z1ifLygTShMb267Z0Xtf nmyc9RwiKJWau4fVv3UVc84XKxv3zrD4qaHORUpisGTD6iyvZm9jUX.EHkQtlDE4c3T9BUQwVwM8 7PCp6NsTtPM9ZWijpzGi9AqXDOOSiB1eAae6i82B9g8EV_ImUaZVGjwXmr5y6Auj9ku2yE9xo1ja HCYkl9wmAEskUcYZa0tgXcGrmzHWbe5fRpm5n.fxduVdHfyymOr8fac9bAJA8sQyX_QTd3bBFOLA Mt2gv3gYBL0xO2M7TX3mBX7Y1dLrmflWZU.JDRhSnMiY5uhbiNduqI4t2o1yke7OK3tPkS.2OScK a9EI- Received: from sonic.gate.mail.ne1.yahoo.com by sonic307.consmr.mail.bf2.yahoo.com with HTTP; Mon, 28 Dec 2020 19:24:22 +0000 Date: Mon, 28 Dec 2020 19:24:03 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Scott Ribe Cc: Amine Tengilimoglu , Pgsql-admin Message-ID: <1299392843.3134647.1609183443761@mail.yahoo.com> In-Reply-To: References: <984856653.599807.1609180184705.ref@mail.yahoo.com> <984856653.599807.1609180184705@mail.yahoo.com> <611218422.3134435.1609181699910@mail.yahoo.com> Subject: Re: how to fail over slave to master MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3134646_2080260489.1609183443759" 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: 8908 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_3134646_2080260489.1609183443759 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable In verison 12, postgresql.auto.conf to replace recovery.conf do I=C2=A0 need to run=C2=A0 1. pg_ctl promote -D Pg_data (in slave?)2. pg_rewind --target -pg_data=3Dma= ster_server (aliase hostname of master) --source-server=3D"port=3D5433 user= =3Dreplica dbname=3Dpostgres" --progress3. change postgresql.cond parameter= , primary_slot_name =3D'main' do I need to run pg_rewind for each dbname?=C2=A0I don't understand why pg_= rewind set the port=3D5433 not 5432? 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, 02:10:14 PM EST, Scott Ribe wrote: =20 =20 > On Dec 28, 2020, at 11:54 AM, Pepe TD Vo wrote: >=20 > Version 12 and can you show me step by step what needs to do?=C2=A0 I fou= nd a document in version 10 to promote salve to master with pg_ctl and crea= te recovery.conf.=C2=A0 Recovery.conf is not existed in version 12 but in v= ersion 1. 1) The parameters that used to be set in recovery.conf are instead set in p= ostgresql.conf in 12 & above. 2) They are set on your replica; otherwise it would not come up as a replic= a. They are not needed in a master. =20 ------=_Part_3134646_2080260489.1609183443759 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
In verison 12, postgresql.auto= .conf to replace recovery.conf

<= div dir=3D"ltr" data-setdir=3D"false" style=3D"font-family: times new roman= , new york, times, serif;">do I  need to run 
1. pg_ctl = promote -D Pg_data (in slave?)
2. pg_rewind --target -pg_data=3Dmaster_server (aliase hostname of master)= --source-server=3D"port=3D5433 user=3Dreplica dbname=3Dpostgres" --= progress
3. change postgresql.cond paramet= er, primary_slot_name =3D'main'

=
do I need to run pg_rewind for each= dbname? 
I= don't understand why pg_rewind set the port=3D5433 not 5432?=
=
=
Bach-Nga

No one= in this world is pure and perfect.  If you avoid people for their mis= takes you will be alone. So judge less, love, and forgive more.3D"Emoji"3D"Emoji"3D"Emoji"
To c= all him a dog hardly seems to do him justice though in as much as he had fo= ur legs, a tail, and barked, I admit he was, to all outward appearances. Bu= t to those who knew him well, he was a perfect gentleman (Hermione Gingold)=

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


=20
=20
On Monday, December 28, 2020, 02:10:14 PM EST, Scott Ri= be <scott_ribe@elevated-dev.com> wrote:


> On Dec 28, 2020, at 11:54 AM, Pe= pe TD Vo <pepevo@yahoo.com> wrote:

>
>= Version 12 and can you show me step by step what needs to do?  I foun= d a document in version 10 to promote salve to master with pg_ctl and creat= e recovery.conf.  Recovery.conf is not existed in version 12 but in ve= rsion 1.


1) The parameters that = used to be set in recovery.conf are instead set in postgresql.conf in 12 &a= mp; above.

2) They are set on your rep= lica; otherwise it would not come up as a replica. They are not needed in a= master.

<= br clear=3D"none">
------=_Part_3134646_2080260489.1609183443759--