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.
>>
>
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 |