Обсуждение: recovery.conf' is not creating in pg_basebackup with version 13
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
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
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/bbkptotal 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.signaland 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-bitThanks,Naga