pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedrecovery.conf' is not creating in pg_basebackup with version 13
3+ messages / 2 participants
[nested] [flat]
* recovery.conf' is not creating in pg_basebackup with version 13
@ 2020-09-27 03:42 Nagaraj Raj <nagaraj.sf@yahoo.com>
0 siblings, 2 replies; 3+ messages in thread
From: Nagaraj Raj @ 2020-09-27 03:42 UTC (permalink / raw)
To: PostgreSQL Mailing Lists <pgsql-bugs@lists.postgresql.org>
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_label
-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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: recovery.conf' is not creating in pg_basebackup with version 13
@ 2020-09-27 03:46 Jaime Casanova <jaime.casanova@2ndquadrant.com>
parent: Nagaraj Raj <nagaraj.sf@yahoo.com>
1 sibling, 0 replies; 3+ messages in thread
From: Jaime Casanova @ 2020-09-27 03:46 UTC (permalink / raw)
To: Nagaraj Raj <nagaraj.sf@yahoo.com>; +Cc: PostgreSQL Mailing Lists <pgsql-bugs@lists.postgresql.org>
Hi,
recovery.conf disappeared since 12
https://www.postgresql.org/docs/12/release-12.html
On Sat, 26 Sep 2020 at 22:42, 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_label
>
> -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
>
>
>
>
--
Jaime Casanova www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: recovery.conf' is not creating in pg_basebackup with version 13
@ 2020-09-29 18:22 Nagaraj Raj <nagaraj.sf@yahoo.com>
parent: Nagaraj Raj <nagaraj.sf@yahoo.com>
1 sibling, 0 replies; 3+ messages in thread
From: Nagaraj Raj @ 2020-09-29 18:22 UTC (permalink / raw)
To: rams nalabolu <ramsveeru441@gmail.com>; Jaime Casanova <jaime.casanova@2ndquadrant.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2020-09-29 18:22 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-09-27 03:42 recovery.conf' is not creating in pg_basebackup with version 13 Nagaraj Raj <nagaraj.sf@yahoo.com>
2020-09-27 03:46 ` Re: recovery.conf' is not creating in pg_basebackup with version 13 Jaime Casanova <jaime.casanova@2ndquadrant.com>
2020-09-29 18:22 ` Re: recovery.conf' is not creating in pg_basebackup with version 13 Nagaraj Raj <nagaraj.sf@yahoo.com>
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