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
