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
copy link · copy postgr.es
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