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 1kNKHG-000230-5t for pgsql-bugs@arkaria.postgresql.org; Tue, 29 Sep 2020 18:23:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kNKHE-0000py-QQ for pgsql-bugs@arkaria.postgresql.org; Tue, 29 Sep 2020 18:23:00 +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 1kNKHE-0000oP-HP for pgsql-bugs@lists.postgresql.org; Tue, 29 Sep 2020 18:23:00 +0000 Received: from sonic315-20.consmr.mail.ne1.yahoo.com ([66.163.190.146]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kNKHC-0004qr-19 for pgsql-bugs@lists.postgresql.org; Tue, 29 Sep 2020 18:23:00 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1601403775; bh=joKLIMVvsv0TBox5P5te5cX/CTVHZcVp8oX7gIne+Z8=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject; b=DGC9Myba05MrZZL05oMfh7Ij0EGB0gRDxRvobcG8hxcsTsYezE+PCnqELfNxD5cC+yhhDEwceKnzHkRpzI84XWnTdB7rPTLmp5W1/g9vLZ2B060t6N00W9XPraXq+Y8UzY/aogQC17/1UwHjwgMNCJk0Ta30ETWTb5XAyyXd/Dm2CEnyhaH5daAu0Lgxe2c+IfkIuIF95iemrzk2Q+3dbjW5QCbr+/JKfu5ZVY8ai2zFJ+B0qbV1eUa4ESQiHl/c9f9auxZNs+GZi3LARr6MamXZQ0O95qt/axGUVa0eaKymQyyTO4H+iKs+v5khgxR8JqgOwUd0l1avypkLRdDOpg== X-YMail-OSG: Nf.XZvIVM1lTj3y1_zNOVzvupTZVJgi5F8i8pznYzxbXXUS8t.IG097h3Huei.J RKCIlqFZYKJ7R322Lg3ATb9nTp6_ba3FBePLGdaX9HVU884VtJFN4zt2FUTWshj0ObJAMlehVG3O 9Wb8rgI2cBKOWVcKyALkEoyxjuxVOHYz_S623iyLhutJrsVL9rNeozz76PEJpHXo0VNuDlVavXsx dHXuANNkhCH_FpG7iPRkd_aZBcqKQiNjVIxGwVt2YDvUgb5pK.uJ_XQjVoEO_VuKXVyTVc00iTkn FDeo5PDmxWsbSxErFSjEV9B955t41bhX7YQlQNmvUNFDjTNrZyPy5ncfnXD.cH48a63uxecDGWNY XVLk7jp8OTlzMg5DLblUdyP2GJfqgK7da3ALU3BW6CWFTCnOckFH8y9ih4phj6rcE0WNHonorrfu Nxv56QHd0f0urGmBarSo4BgWvEN_9cBTGde8nd.wA4pSjFydO6sSarmFRwiJiSA0JYxNXDHBoWT6 Ra6cdem0GiC2D0EY7YYgzLjEXunnO4gL8oVGV1HTsGmDBwxmAXnS84o6B2t4j0py_gyEFQRJ3GFN Vxidx1LgeRVNLZ5E.UViKRYsu1W5ereEJqs4JFE7dIGV0gUc0Z7xLHSA.YrFhUJz5W0eXrcoTC2f Ljv0g.sUdFfKfxjj4didWGK9yQ0ORncdieI1XcL6o9LQwoOoCmyicW2f.XeIsXzJubf.exaAjbGw EU1e7GgfkSn2UULMQKqhTZF_qfrD9_hDjHpbuspUwkH9NHWTs2HWMwOe1.jV8l8yoehRPH0Y6oL. YJ.DG8hRw0O4valaTxL3W5in6o.kAuV29qre0hDImhx.X_tWmaIBPUnDUGOeYnE2VkBIUUaioS0E nS_iMRSEWnP64_R7NryA.6V8gv2j5kwnsfMjBuHgPO6TbQY9.mDBrW_tYi5Bl6WnAdJe_AiwaF1k wMaLOMorZHcq3AWeZeALKWjzClhWT3w_zIWez4WgULkOTCqHhOjkyP5P93zFiwZpFRIbJEBED5LG QvMTni35jjuaGB9y8.dDYfeQ90Y52WkDRlKsIJMTmIy05knHxRtGx7TZOfSjMWv5kfOkU3FmqaSw hquUF7mRWdXomdOJ4a9Wtm_E49ZJ6zbc92uUUKYkzMlHoQkSMaiBqKbrQzd1snwH7.lpsSLBm4_J fY042Np10UHPHU8COLhZV9dlYh5F7t6y9pw3byPw4QXLTWQYO2gSsjSOdTzh19GIzP24A3M5.T0d WTaOjrIkzVV0ufvP5_1hYd9PPNyWpdtJVTNzePXKxOFdMakkuxtCbRBOo1GMR9toTdLJZrWlTkPq 6LofYyfCzLJ1i1UswwRwfLLi6y92Ri29Y3DjoVPwMtukYlYFC_h6fsZTEGPy39ciy0Ye_6Q6PPk7 Z6N4kwtbTmoNcljmMxWI2_WDnrWho4IM43NuPpPSk2mV34Hmz7qcU4wJ1drGp8X.srlO5OAkUKHb 6humHOMC1ZrYdTrmsJu0- Received: from sonic.gate.mail.ne1.yahoo.com by sonic315.consmr.mail.ne1.yahoo.com with HTTP; Tue, 29 Sep 2020 18:22:55 +0000 Date: Tue, 29 Sep 2020 18:22:50 +0000 (UTC) From: Nagaraj Raj To: rams nalabolu , Jaime Casanova Cc: "pgsql-bugs@lists.postgresql.org" Message-ID: <557558791.335627.1601403770783@mail.yahoo.com> In-Reply-To: References: <567745970.1215537.1601178157330.ref@mail.yahoo.com> <567745970.1215537.1601178157330@mail.yahoo.com> Subject: Re: recovery.conf' is not creating in pg_basebackup with version 13 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_335626_600023629.1601403770779" X-Mailer: WebService/1.1.16718 YMailNorrin Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.121 Safari/537.36 Content-Length: 21225 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_335626_600023629.1601403770779 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thank you. On Sunday, September 27, 2020, 01:05:50 PM PDT, rams nalabolu wrote: =20 =20 Hi=C2=A0Nagaraj, You are doing correct only.Pg_basebackup is not creating recovery.conf file= anymore starting from version 12.If you choose it will only create standby= .signal.You could use standby.signal in two cases as below.1) PITR: in this= case you just need empty recovery.signal file and you could rename standby= .signal file as recovery.signal and echo all recovery related parameters in= to Postgresql.conf file 2) HA: To setup streaming replication or to create standby sever. In this c= ase all replication related parameters will be on standby.signal Thanks=C2=A0Veeru On Sat, Sep 26, 2020 at 8:42 PM Nagaraj Raj wrote: Hi, while doing 'pg_basebackup' with the option '--write-recovery-conf' ,=C2=A0 'recovery.conf'=C2=A0 is not creating in basebackup directory and I'm using= the below command.=C2=A0 '/mnt1/pg13/bin/pg_basebackup -h localhost -p 5433 -U postgres -D /mnt1/pg1= 3/bbkp -P --write-recovery-conf' [postgres@ postgres bbkp1]$ ll=C2=A0 /mnt1/pg13/bbkp=C2=A0 total 252 -rw-------. 1 postgres postgres=C2=A0 =C2=A0 224 Sep 26 23:13 backup_labe -rw-------. 1 postgres postgres 135117 Sep 26 23:13 backup_manifest drwx------. 5 postgres postgres =C2=A0 4096 Sep 26 23:13 base drwx------. 2 postgres postgres =C2=A0 4096 Sep 26 23:13 global drwx------. 2 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_commit_ts drwx------. 2 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_dynshmem -rw-------. 1 postgres postgres =C2=A0 4831 Sep 26 23:13 pg_hba.conf -rw-------. 1 postgres postgres =C2=A0 1636 Sep 26 23:13 pg_ident.conf drwx------. 4 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_logical drwx------. 4 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_multixact drwx------. 2 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_notify drwx------. 2 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_replslot drwx------. 2 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_serial drwx------. 2 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_snapshots drwx------. 2 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_stat drwx------. 2 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_stat_tmp drwx------. 2 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_subtrans drwx------. 2 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_tblspc drwx------. 2 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_twophase -rw-------. 1 postgres postgres=C2=A0 =C2=A0 =C2=A0 3 Sep 26 23:13 PG_VERSI= ON drwx------. 3 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_wal drwx------. 2 postgres postgres =C2=A0 4096 Sep 26 23:13 pg_xact -rw-------. 1 postgres postgres=C2=A0 =C2=A0 336 Sep 26 23:13 postgresql.au= to.conf -rw-------. 1 postgres postgres=C2=A0 27977 Sep 26 23:13 postgresql.conf -rw-------. 1 postgres postgres=C2=A0 =C2=A0 =C2=A0 0 Sep 26 23:13 standby.= signal and=C2=A0standby.signal file created but is empty. Am I doing wrong or its a kind of bug or this option removed in v13? PostgreSQL Version: PostgreSQL 13.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 2015062= 3 (Red Hat 4.8.5-39), 64-bit Thanks,Naga =20 ------=_Part_335626_600023629.1601403770779 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thank you.

=20
=20
On Sunday, September 27, 2020, 01:05:50 PM PDT, rams na= labolu <ramsveeru441@gmail.com> wrote:


Hi Nagaraj,

You are doing correct only.
Pg_basebackup is not creating recovery.conf file anymore starting from ve= rsion 12.
If you choose it will only create standby.signal.
=
You could use standby.signal in two cases as below.
1) PITR:= in this case you just need empty recovery.signal file and you could rename= standby.signal file as recovery.signal and echo all recovery related param= eters into Postgresql.conf file

2) = HA: To setup streaming replication or to create standby sever. In this case= all replication related parameters will be on standby.signal
Thanks 
Veeru

On Sat, Sep 26, 2020 at 8:42 PM Nagaraj Raj <nagaraj.sf@yahoo.com> wrote:


total 252

<= p style=3D"margin:0px;font-stretch:normal;font-size:11px;line-height:normal= ;font-family:Menlo;color:rgb(0,0,0);">-r= w-------. 1 postgres postgres  &nbs= p; 224 Sep 26 23:13 backup_labe

-rw-------. 1 postgres post= gres 135117 Sep 26 23:13 backup_manifest

drwx------. 5 postgres po= stgres   4096 Sep 26 23:13 <= /span>base<= /p>

drwx------. 2 postgres postgres  = 4096 Sep 26 23:13 global

drwx------. 2 postgres postgres   4096 Sep 26 23:13 pg_commit_ts

drwx---= ---. 2 postgres postgres   4= 096 Sep 26 23:13 pg_dynshmem

-rw-------. 1 postgres postgres   4831 Sep 26 23:13 pg_hba.conf

-rw= -------. 1 postgres postgres   1636 Sep 26 23:13 pg_ident.conf

drwx------. 4 postgres postgres=   4096 Sep 26 23:13 = pg_logical<= /p>

drwx------. 4 postgres postgres  = 4096 Sep 26 23:13 pg_multixact

drwx------. 2 postgres postgres   4096 Sep 26 23:13 pg_notify

drwx--= ----. 2 postgres postgres   = 4096 Sep 26 23:13 pg_replslot

drwx------. 2 postgres postgres   4096 Sep 26 23:13 pg_serial

drwx------. 2 p= ostgres postgres   4096 Sep = 26 23:13 pg= _snapshots

drwx------. 2 postgres postgres   4096 Sep 26 23:13 pg_stat

drwx------. 2 postgres po= stgres   4096 Sep 26 23:13 <= /span>pg_stat_tmp<= /span>

drwx------. 2 postgres postgres   4096 Sep 26 23:13 pg_subtrans

drwx------. 2 postgres postgres =   4096 Sep 26 23:13 <= span style=3D"font-family:Menlo;color:rgb(77,109,255);">pg_tblspc

= drwx------. 2 postgres postgres   <= /span>4096 Sep 26 23:13 pg_twophase

<= span style=3D"font-family:Menlo;">-rw-------. 1 postgres postgres      3 Sep 26 23:13 PG_VERS= ION

drwx------. 3 postgres postgres   4096 Sep 26 23:13 pg_wal

drwx------. 2 postgres postgres <= span style=3D"font-family:Menlo;">  4096 Sep 26 23:13 pg_xact

-rw= -------. 1 postgres postgres   = ; 336 Sep 26 23:13 postgresql.auto.conf

-rw-------. 1 postg= res postgres  27977 Sep 26 2= 3:13 postgresql.conf

-rw-------. 1 postgres postgres      0 Sep 26 23:13 standby.= signal


and standby.signal = file created but is empty.


=
Am I doing wrong or its a kind of b= ug or this option removed in v13?

PostgreSQL Version:




------=_Part_335626_600023629.1601403770779--