Re: [BUGS] error on online backup using pg_basebackup tool - Mailing list pgsql-general

From Michael Paquier
Subject Re: [BUGS] error on online backup using pg_basebackup tool
Date
Msg-id CAB7nPqQ1fKbK_VGFoNscuuZpR=7cSLxAf2gpBQPZ_swv0tMCfA@mail.gmail.com
Whole thread Raw
In response to error on online backup using pg_basebackup tool  (Gerdan Rezende dos Santos <gerdan@gmail.com>)
Responses Re: error on online backup using pg_basebackup tool  (Gerdan Rezende dos Santos <gerdan@gmail.com>)
List pgsql-general
On Thu, Sep 3, 2015 at 10:28 AM, Gerdan Rezende dos Santos
<gerdan@gmail.com> wrote:
> 6 - create table spaces:
> CREATE TABLESPACE newtblspc LOCATION '/data/newtblspc';
> CREATE TABLESPACE newtblspc2 LOCATION '/data/pg_tblspc/newtblspc2'
> 7 - mkdir /data2
> 8 - Now perform a backup using pg_basebackup -D /data2 and get the error
> message.

You are performing a base backup on a node that has tablespaces on the
same hosts, so tablespaces are going to overlap. Isn't that your
problem? Note that 9.4 you can use tablespace-mapping to address the
problem, for older versions you are going to need some manual
operations before being able to run the standby and the master on the
same server.
--
Michael


pgsql-general by date:

Previous
From: Tom Smith
Date:
Subject: Re: get first and last row in one sql as two columns
Next
From: Gerdan Rezende dos Santos
Date:
Subject: Re: error on online backup using pg_basebackup tool