pg_basebackup problem for Streaming replication

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

Responses

Browse pgsql-general by date

  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