Re: [GENERAL] pg_rewind copy so much data - Mailing list pgsql-general

From Michael Paquier
Subject Re: [GENERAL] pg_rewind copy so much data
Date
Msg-id CAB7nPqScc1oaxZniSh6LvtCUO9DN84jMS_+W_O+3N6te=x4wzg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] pg_rewind copy so much data  (Hung Phan <hungphan227@gmail.com>)
Responses Re: [GENERAL] pg_rewind copy so much data  (Hung Phan <hungphan227@gmail.com>)
List pgsql-general
On Fri, Sep 29, 2017 at 1:06 PM, Hung Phan <hungphan227@gmail.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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: [GENERAL] PG 10 and perl
Next
From: Hung Phan
Date:
Subject: Re: [GENERAL] pg_rewind copy so much data