pg_basebackup

[Daulat Ram <Daulat.Ram@xxxxxxxxxxxxxxx>]

Hello,

 

I am taking pg_basebackup of primary db (docker container env.) using the below command :

 

pg_basebackup -x -h vmzti -U replication -D /etc/postgresql/9.5/main/pg_basebkp/basekp1224 -Ft -z -P

Password:

WARNING:  skipping special file "./postgresql.conf"

WARNING:  skipping special file "./postgresql.conf"

4048512/4048512 kB (100%), 1/1 tablespace

 

 

• Getting the above warning message.
• Also the backup has been completed with only the single file  “tar -xvf base.tar.gz” as an output but there is no  tar -xvf pg_wal.tar.gz file exist.
• If we decompress the file  “tar -xvf base.tar.gz”  , I do not see the postmaster.opts file.

 

 

Note: We have the different path for the conf files :

 

 

data_directory = '/var/lib/postgresql/9.5/main'         # use data in another directory # (change requires restart)

hba_file = '/etc/postgresql/9.5/main/pg_hba.conf'       # host-based authentication file # (change requires restart)

ident_file = '/etc/postgresql/9.5/main/pg_ident.conf'   # ident configuration file # (change requires restart)

 

postgres=# SHOW config_file;

                 config_file

----------------------------------------------

/var/lib/postgresql/9.5/main/postgresql.conf

(1 row)

 

postgres=# show hba_file;

               hba_file

--------------------------------------

/etc/postgresql/9.5/main/pg_hba.conf

(1 row)

 

postgres=#

 

More details:

 

postgres@4ed92bac84af:/var/lib/postgresql/9.5/main$ ls -ltr

total 128

-rw------- 1 postgres postgres   208 Sep 13  2017 backup_label.old

drwx------ 8 postgres postgres  4096 Sep 13  2017 base

drwx------ 2 postgres postgres  4096 Sep 13  2017 pg_commit_ts

drwx------ 2 postgres postgres  4096 Sep 13  2017 pg_dynshmem

drwx------ 4 postgres postgres  4096 Sep 13  2017 pg_multixact

drwx------ 2 postgres postgres  4096 Sep 13  2017 pg_replslot

drwx------ 2 postgres postgres  4096 Sep 13  2017 pg_serial

drwx------ 2 postgres postgres  4096 Sep 13  2017 pg_snapshots

drwx------ 2 postgres postgres  4096 Sep 13  2017 pg_stat

drwx------ 2 postgres postgres  4096 Sep 13  2017 pg_stat_tmp

drwx------ 2 postgres postgres  4096 Sep 13  2017 pg_tblspc

drwx------ 2 postgres postgres  4096 Sep 13  2017 pg_twophase

-rw------- 1 postgres postgres     4 Sep 13  2017 PG_VERSION

-rw------- 1 postgres postgres    88 Sep 13  2017 postgresql.auto.conf

-rwxr-xr-x 1 postgres postgres 22116 Sep 13  2017 postgresql.conf.orig

drwx------ 2 postgres postgres 12288 Sep 13  2017 pg_log

lrwxrwxrwx 1 postgres postgres    38 Sep 13  2017 recovery.conf -> /etc/postgresql/9.5/main/recovery.conf

lrwxrwxrwx 1 postgres postgres    40 Sep 13  2017 postgresql.conf -> /etc/postgresql/9.5/main/postgresql.conf

-rw------- 1 postgres postgres    90 May 21  2019 postmaster.pid

drwx------ 2 postgres postgres  4096 May 21  2019 pg_notify

-rw------- 1 postgres postgres    46 May 21  2019 postmaster.opts

drwx------ 2 postgres postgres  8192 Dec 11 08:10 global

drwx------ 2 postgres postgres  4096 Dec 17 20:12 pg_clog

drwx------ 2 postgres postgres  4096 Dec 17 20:16 pg_subtrans

drwxrwxrwx 2 postgres postgres  4096 Dec 18 08:31 backup

drwx------ 3 postgres postgres  4096 Dec 18 15:56 pg_xlog

drwx------ 4 postgres postgres  4096 Dec 18 16:31 pg_logical

postgres@4ed92bac84af:/var/lib/postgresql/9.5/main$

ident.conf

 

Please advise.

 

Thanks,