Обсуждение: recovery.conf' is not creating in pg_basebackup with version 13

Поиск
Список
Период
Сортировка

recovery.conf' is not creating in pg_basebackup with version 13

От
Nagaraj Raj
Дата:
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




Re: recovery.conf' is not creating in pg_basebackup with version 13

От
Jaime Casanova
Дата:
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



Re: recovery.conf' is not creating in pg_basebackup with version 13

От
Nagaraj Raj
Дата:
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