Re: error on online backup using pg_basebackup tool

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Gerdan Rezende dos Santos <gerdan(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>, PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: error on online backup using pg_basebackup tool
Date: 2015-09-03 02:52:18
Message-ID: CAB7nPqQ1fKbK_VGFoNscuuZpR=7cSLxAf2gpBQPZ_swv0tMCfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

On Thu, Sep 3, 2015 at 10:28 AM, Gerdan Rezende dos Santos
<gerdan(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Munro 2015-09-03 03:16:38 Re: BUG #13440: unaccent does not remove all diacritics
Previous Message Alvaro Herrera 2015-09-03 01:40:59 Re: BUG #13440: unaccent does not remove all diacritics

Browse pgsql-general by date

  From Date Subject
Next Message Gerdan Rezende dos Santos 2015-09-03 03:20:18 Re: error on online backup using pg_basebackup tool
Previous Message Tom Smith 2015-09-03 02:20:59 Re: get first and last row in one sql as two columns