Re: Read recover rows - Mailing list pgsql-general

From Tom Lane
Subject Re: Read recover rows
Date
Msg-id 214.1355499014@sss.pgh.pa.us
Whole thread Raw
In response to Re: Read recover rows  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Read recover rows  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Adrian Klaver <adrian.klaver@gmail.com> writes:
> On 12/13/2012 06:51 PM, Alvaro Herrera wrote:
>> Make sure the server is down and replace a table's file with the file
>> you have.  You can just create a dummy empty table with exactly the same
>> row type as the one that had the table the file was for; you need to
>> recreate dropped columns as well.

> So it is possible to slide a file under a table?
> How exactly do you do that and keep the OID and filenode references in sync?

The XIDs embedded in the tuples would be the big problem.

            regards, tom lane


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Implicit casts to array types
Next
From: joshua
Date:
Subject: Re: Implicit casts to array types