From: | Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_basebackup problem for Streaming replication |
Date: | 2015-09-03 06:39:53 |
Message-ID: | CAFzqEhKL=-n2U3CBxZOA+sF+tXOrLPM2idBKWAz28e7F-Bir8Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Etienne Champetier | 2015-09-03 08:30:50 | Postgresql C extension and SIGSEGV |
Previous Message | Gerdan Rezende dos Santos | 2015-09-03 03:54:23 | Re: error on online backup using pg_basebackup tool |