Re: error on online backup using pg_basebackup tool

From: Gerdan Rezende dos Santos <gerdan(at)gmail(dot)com>
To: Martín Marqués <martin(at)2ndquadrant(dot)com>
Cc: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: error on online backup using pg_basebackup tool
Date: 2015-09-03 20:41:46
Message-ID: CAKOcMA6-QoajZNG23yLgLX3Tov8CNUcx7rkwu_0E17JodcCJ_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

On Thu, Sep 3, 2015 at 5:01 PM, Martín Marqués <martin(at)2ndquadrant(dot)com>
wrote:

> 2015-09-03 16:48 GMT-03:00 Gerdan Rezende dos Santos <gerdan(at)gmail(dot)com>:
> > On Thu, Sep 3, 2015 at 7:20 AM, Martín Marqués <martin(at)2ndquadrant(dot)com>
> > wrote:
> >>
> >> El 03/09/15 a las 00:54, Gerdan Rezende dos Santos escribió:
> >> >
> >> >
> >> > In other server with same configuration the proccess not complete too!
> >>
> >> Add --verbose to the pg_basebackup execution and send over the output
> >> error message.
> >>
> >> I find your procedure confusing, and I'd recommend you *not* to put
> >> tablespaces in $PGDTA/pg_tblspc/. That directory is for postgres to put
> >> the links to where the actual tablespace is (normally on another
> >> partition)
> >
> > This message on verbose mode: pg_basebackup: directory "/data/pg_tblspc/"
> > exists but is not empty
>
> The error message is quite clear, it has to use /data/pg_tblspc/ to
> put a tablespace, but that directory is not empty.
>
> Why are you putting tablespaces inside PGDATA? It really makes no
> sense. Just leave the objects you have there in the default
> tablespace.
>
> Regards,
>
> --
> Martín Marqués http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>

This problem, I found in my client ...
Why are you putting in PGDATA table ? He can not say to me
The solution then is to continue using the start_backup , rsync and
stop_backup. ;(

Thanks!

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Martín Marqués 2015-09-03 20:53:19 Re: error on online backup using pg_basebackup tool
Previous Message Martín Marqués 2015-09-03 20:01:59 Re: error on online backup using pg_basebackup tool

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2015-09-03 20:53:19 Re: error on online backup using pg_basebackup tool
Previous Message Martín Marqués 2015-09-03 20:01:59 Re: error on online backup using pg_basebackup tool