pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
recovery.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>
  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>
  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:42 recovery.conf'  is not creating in pg_basebackup with version 13 Nagaraj Raj <nagaraj.sf@yahoo.com>
@ 2020-09-27 03:46 ` Jaime Casanova <jaime.casanova@2ndquadrant.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-27 03:42 recovery.conf'  is not creating in pg_basebackup with version 13 Nagaraj Raj <nagaraj.sf@yahoo.com>
@ 2020-09-29 18:22 ` 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