Re: pg_basebackup problem for Streaming replication

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(dot)teleatlas(at)gmail(dot)com>
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(at)INN14U-DW1353 data]# pwd
>
> /opt/PostgreSQL/9.1/data
>
> [root(at)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(at)INN14U-DW1353 ~]# cat backup.log
>
>
> pg_basebackup: could not get WAL end position from server
>
>
> Regards,
>
> Sachin
>
>