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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sameer Thakur <samthakur74(at)gmail(dot)com>
Cc: 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 14:15:54
Message-ID: 16294.1365776154@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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. You apparently don't
understand what you read in the other discussion --- the steps you are
objecting to are not optional, whether copying a whole tablespace or
only one table.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2013-04-12 14:42:33 Re: [sepgsql 2/3] Add db_schema:search permission checks
Previous Message Mike Broers 2013-04-12 14:10:53 Re: [ADMIN] after 9.2.4 patch vacuumdb -avz not analyzing all tables