Re: Detach/attach table and index data files from one cluster to another - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Detach/attach table and index data files from one cluster to another
Date
Msg-id 16294.1365776154@sss.pgh.pa.us
Whole thread Raw
In response to Detach/attach table and index data files from one cluster to another  (Sameer Thakur <samthakur74@gmail.com>)
Responses Re: Detach/attach table and index data files from one cluster to another
List pgsql-hackers
Sameer Thakur <samthakur74@gmail.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



pgsql-hackers by date:

Previous
From: Mike Broers
Date:
Subject: Re: [ADMIN] after 9.2.4 patch vacuumdb -avz not analyzing all tables
Next
From: Alvaro Herrera
Date:
Subject: Re: [sepgsql 2/3] Add db_schema:search permission checks