pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Nagaraj Raj <nagaraj.sf@yahoo.com>
To: rams nalabolu <ramsveeru441@gmail.com>
To: Jaime Casanova <jaime.casanova@2ndquadrant.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: recovery.conf' is not creating in pg_basebackup with version 13
Date: Tue, 29 Sep 2020 18:22:50 +0000 (UTC)
Message-ID: <557558791.335627.1601403770783@mail.yahoo.com> (raw)
In-Reply-To: <CAHq7gtCzcwtRrGMKeYB7ftzvS=Uyhu1Tptx73z1Ri9=P1nyySA@mail.gmail.com>
References: <567745970.1215537.1601178157330.ref@mail.yahoo.com>
	<567745970.1215537.1601178157330@mail.yahoo.com>
	<CAHq7gtCzcwtRrGMKeYB7ftzvS=Uyhu1Tptx73z1Ri9=P1nyySA@mail.gmail.com>

 Thank you.
    On Sunday, September 27, 2020, 01:05:50 PM PDT, rams nalabolu <ramsveeru441@gmail.com> wrote:  
 
 Hi Nagaraj,
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 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:

Hi,
while doing 'pg_basebackup' with the option '--write-recovery-conf' , 
'recovery.conf'  is not creating in basebackup directory and I'm using the below command. 
'/mnt1/pg13/bin/pg_basebackup -h localhost -p 5433 -U postgres -D /mnt1/pg13/bbkp -P --write-recovery-conf'
[postgres@ postgres bbkp1]$ ll  /mnt1/pg13/bbkp 
total 252

-rw-------. 1 postgres postgres    224 Sep 26 23:13 backup_labe

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

drwx------. 5 postgres postgres   4096 Sep 26 23:13 base

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   4096 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

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 postgres postgres   4096 Sep 26 23:13 pg_snapshots

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

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

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

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

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

-rw-------. 1 postgres postgres      3 Sep 26 23:13 PG_VERSION

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

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

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

-rw-------. 1 postgres postgres  27977 Sep 26 23: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 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 20150623 (Red Hat 4.8.5-39), 64-bit


Thanks,Naga




  

view thread (3+ messages)

Message-ID: <557558791.335627.1601403770783@mail.yahoo.com>
Permalink:  ../557558791.335627.1601403770783@mail.yahoo.com/
Also on:    postgresql.org/message-id/557558791.335627.1601403770783@mail.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: nagaraj.sf@yahoo.com, ramsveeru441@gmail.com, jaime.casanova@2ndquadrant.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: recovery.conf' is not creating in pg_basebackup with version 13
  In-Reply-To: <557558791.335627.1601403770783@mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox