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.teleat...@gmail.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@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 > >
