Re: Detach/attach table and index data files from one cluster to another

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Sameer Thakur <samthakur74(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Detach/attach table and index data files from one cluster to another
Date: 2013-04-12 15:51:19
Message-ID: 51682D77.2090903@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 04/12/2013 10:15 AM, Tom Lane wrote:
> Sameer Thakur <samthakur74(at)gmail(dot)com> writes:
>> The proposed tool tries to make migration faster for tables and indices
>> only by copying their binary data files.
> There's 0 chance of making that work, because the two databases wouldn't
> have the same notions of committed XIDs.

Yeah. Trying to think way outside the box, could we invent some sort of
fixup mechanism that could be applied to adopted files? Of course, that
could slow things down so much that it wouldn't be worth it, but it
might be a nice research project.

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2013-04-12 16:08:01 Re: Analyzing bug 8049
Previous Message Bruce Momjian 2013-04-12 15:44:58 Re: Patch to make pgindent work cleanly