Re: [GENERAL] pg_basebackup on standby node failed

2014-02-03 Thread Michael Paquier
On Tue, Feb 4, 2014 at 5:51 AM, Ying He wrote: > When I do: > pg_basebackup -D /backupDir > > I am getting: > pg_basebackup: directory "/usr/local/pgsql/data/pg_tblspc/tablespace1" > exists but is not empty > > tablespace1 is a tablespace created by CREATE TABLESPACE and > ""/usr/local/pgsql/data/

Re: [GENERAL] pg_basebackup on standby node failed

2014-02-03 Thread Ying He
Thanks Michael. It seems having an issue using pg_basebackup. When I do: pg_basebackup -D /backupDir I am getting: pg_basebackup: directory "/usr/local/pgsql/data/pg_tblspc/tablespace1" exists but is not empty tablespace1 is a tablespace created by CREATE TABLESPACE and ""/usr/local/pgsql/da

Re: [GENERAL] pg_basebackup on standby node failed

2014-01-31 Thread Michael Paquier
On Sat, Feb 1, 2014 at 7:07 AM, Ying He wrote: > hi, All, > > I intend to do a basebackup on a hot standby node. I followed the > instructions on > http://www.postgresql.org/docs/9.2/static/app-pgbasebackup.html to turn > full_page_writes on at master and other settings on standby. > > When I try

[GENERAL] pg_basebackup on standby node failed

2014-01-31 Thread Ying He
hi, All, I intend to do a basebackup on a hot standby node. I followed  the instructions on http://www.postgresql.org/docs/9.2/static/app-pgbasebackup.html to turn full_page_writes on at master and other settings on standby. When I try to select pg_start_backup('backuplabel'); on the standby in