Re: reuse tablespace from crashed PSQL instance

From: Artem Tomyuk <admin(at)leboutique(dot)com>
To: Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: reuse tablespace from crashed PSQL instance
Date: 2016-06-21 08:40:09
Message-ID: CANYYVqKY92iuwSKZWYw=622C9_Ds2x2CBhL5u=FdVmg6GGJD2w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

So what are my steps to reconnect it?

I should run create tablespace command again or just add path and name to
the postgresql.conf?

2016-06-21 11:38 GMT+03:00 Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru>:

> There is nothing in relation data files that prevent you to do it (no
> headers etc in files) except xmin and xmax info from tuple %).
> So the short answer is yes you can do it but may be you will not see any
> data from it if for example current txid is less than xmin's from data
> files.
> PS There is no transportable tablespaces as they are in Oracle. So you can
> only try it at home ;)
>
> Alex Ignatov
> Postgres Professional: http://www.postgrespro.com
> Russian Postgres Company
>
>
>
>
> On Tue, Jun 21, 2016 at 11:26 AM +0300, "Artem Tomyuk" <
> admin(at)leboutique(dot)com> wrote:
>
> Hi.
>>
>> Is it possible to reconnect tablespace from old setup to the new one with
>> the same version of PGSQL?
>>
>> Thanks.
>>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alex Ignatov 2016-06-21 09:56:41 Re: reuse tablespace from crashed PSQL instance
Previous Message Alex Ignatov 2016-06-21 08:38:25 Re: reuse tablespace from crashed PSQL instance