Re: Read recover rows

On 12/14/2012 07:30 AM, Tom Lane wrote:
> 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.

Well I always figured doing something like this would be equivalent to
rebuilding a car engine while it was running:) I am intrigued by the
possibility though. Just wondering if it has actually been done
successfully.


>
>             regards, tom lane
>
>


--
Adrian Klaver
adrian.klaver@gmail.com