Re: pg_rewind copy so much data

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Hung Phan <hungphan227(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_rewind copy so much data
Date: 2017-09-29 05:06:44
Message-ID: CAB7nPqScc1oaxZniSh6LvtCUO9DN84jMS_+W_O+3N6te=x4wzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Sep 29, 2017 at 1:06 PM, Hung Phan <hungphan227(at)gmail(dot)com> wrote:
> I used tablespace to store data and it seems to be that pg_rewind copied
> everthing in the tablespace. Today I found an article posted by you (Michael
> Paquier) and you said that there was no tablespace support. If so, is there
> anyway to work around ?

I guess you mean that article:
http://paquier.xyz/postgresql-2/postgres-module-highlight-pg_rewind-to-recycle-a-postgres-master-into-a-slave/
This is from 2013 and this refers to the first iterations of the tool.
Tablespaces are now fully supported in the upstream version, as well
as in the version on github for 9.3 and 9.4. See this commit which
added support for tablespaces:
https://github.com/vmware/pg_rewind/commit/19fb09cdcac397048f7d723c037fe6a10299a278

FWIW, I use it daily, and pg_rewind is able to detect correctly page
deltas even on non-default tablespaces. Really.
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hung Phan 2017-09-29 09:22:20 Re: pg_rewind copy so much data
Previous Message Andy Colson 2017-09-29 04:20:45 PG 10 and perl