Re: pg_basebackup problem for Streaming replication

[Sachin Srivastava <ssr.teleatlas@xxxxxxxxx>]

Dear All,

Kindly suggest to me why this problem is coming.

Regards,

Sachin

On Thu, Sep 3, 2015 at 12:09 PM, Sachin Srivastava <ssr.teleatlas@xxxxxxxxx> wrote:

Dear Experts,

One problem, I am facing that when I am using pg_basebackup (on Standby Server) it’s copying only some files and directories not all like pg_notify folder etc. That’s why when I am restarting the database on "Standby Server" after "pg_basebackup" then it’s showing an error below. If you have an idea why these files/folders(through pg_basebackup) are not copying completely then tell to me.

 

“2015-09-03 16:58:30 IST FATAL:  could not open directory "pg_notify": No such file or directory”

 

Pg_basebackup command as below:

 

pg_basebackup -D /opt/PostgreSQL/9.1/data/ -v -Fp -l Testbackup -h 172.17.43.84 -U replication >& backup.log

 

Data directory of Standby server after taking the pg_basebackup through above command

 

[root@INN14U-DW1353 data]# pwd

/opt/PostgreSQL/9.1/data

[root@INN14U-DW1353 data]# ls -ltr

total 100

-rwx------. 1 postgres postgres   173 Sep  3 16:55 backup_label

drwx------. 2 postgres postgres  4096 Sep  3 16:55 pg_log

drwx------. 2 postgres postgres  4096 Sep  3 16:55 global

drwx------. 5 postgres postgres  4096 Sep  3 16:55 base

-rwx------. 1 postgres postgres 19158 Sep  3 16:55 postgresql.conf_backup

-rwx------. 1 postgres postgres 19231 Sep  3 16:55 postgresql.conf

drwx------. 2 postgres postgres  4096 Sep  3 16:55 pg_xlog

-rwx------. 1 postgres postgres     4 Sep  3 16:55 PG_VERSION

drwx------. 2 postgres postgres  4096 Sep  3 16:55 pg_twophase

drwx------. 2 postgres postgres  4096 Sep  3 16:55 pg_tblspc

drwx------. 2 postgres postgres  4096 Sep  3 16:55 pg_subtrans

drwx------. 2 postgres postgres  4096 Sep  3 16:55 pg_stat_tmp

drwx------. 2 postgres postgres  4096 Sep  3 16:55 pg_serial

drwx------. 4 postgres postgres  4096 Sep  3 16:55 pg_multixact

-rwx------. 1 postgres postgres  4406 Sep  3 16:55 pg_hba.conf

drwx------. 2 postgres postgres  4096 Sep  3 16:55 main

 

Data directory of “Primary Server”

 

 

-bash-4.1$ pwd

/opt/PostgreSQL/9.1/data

-bash-4.1$ ls -ltr

total 124

-rw------- 1 postgres postgres     4 Aug 24 11:25 PG_VERSION

drwx------ 2 postgres postgres  4096 Aug 24 11:25 pg_twophase

drwx------ 2 postgres postgres  4096 Aug 24 11:25 pg_tblspc

drwx------ 2 postgres postgres  4096 Aug 24 11:25 pg_subtrans

drwx------ 2 postgres postgres  4096 Aug 24 11:25 pg_serial

drwx------ 4 postgres postgres  4096 Aug 24 11:25 pg_multixact

-rw------- 1 postgres postgres  1636 Aug 24 11:25 pg_ident.conf

drwx------ 2 postgres postgres  4096 Aug 24 11:25 pg_clog

drwx------ 5 postgres postgres  4096 Aug 24 11:25 base

-rw-r--r-- 1 root     root     19158 Aug 28 10:26 postgresql.conf_backup

-rw------- 1 root     root      4222 Aug 28 10:37 pg_hba.conf_backup

drwx------ 2 postgres postgres  4096 Aug 31 13:19 main

-rw-rw-r-- 1 postgres postgres 19231 Sep  2 18:42 postgresql.conf

-rw------- 1 postgres postgres  4406 Sep  3 11:13 pg_hba.conf

-rw------- 1 postgres postgres    73 Sep  3 11:13 postmaster.pid

-rw------- 1 postgres postgres    65 Sep  3 11:13 postmaster.opts

drwx------ 2 postgres postgres  4096 Sep  3 11:13 pg_notify

drwxr-xr-x 2 postgres postgres  4096 Sep  3 11:13 pg_log

drwx------ 2 postgres postgres  4096 Sep  3 11:14 global

drwx------ 3 postgres postgres  4096 Sep  3 11:25 pg_xlog

drwx------ 2 postgres postgres  4096 Sep  3 11:42 pg_stat_tmp

-bash-4.1$

And one more thing when I am checking the pg_basebackup log then it's also showing below error, why?

[root@INN14U-DW1353 ~]# cat backup.log

pg_basebackup: could not get WAL end position from server

Regards,

Sachin