From: Alex Ignatov <a.ignatov@postgrespro.ru>
To: Artem Tomyuk <admin@leboutique.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: reuse tablespace from crashed PSQL instance
Date: Tue, 21 Jun 2016 12:56:41 +0300
Message-ID: <e276ff44-ae40-d17b-5489-0596237d6258@postgrespro.ru> (raw)
In-Reply-To: <CANYYVqKY92iuwSKZWYw=622C9_Ds2x2CBhL5u=FdVmg6GGJD2w@mail.gmail.com>
References: <CANYYVqJ+0FKgD6bdwm_7NySLyivfk33DzqETJkn3rBwcZCsY0g@mail.gmail.com>
<19518802B8BEC076.F3B8DC25-B5D7-4BA3-9B38-05D6137F201D@mail.outlook.com>
<CANYYVqKY92iuwSKZWYw=622C9_Ds2x2CBhL5u=FdVmg6GGJD2w@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Please describe more your problem. Say A happend and I need B
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
On 21.06.2016 11:40, Artem Tomyuk wrote:
> 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.ignatov@postgrespro.ru
> <mailto:a.ignatov@postgrespro.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@leboutique.com <mailto:admin@leboutique.com>> wrote:
>
> Hi.
>
> Is it possible to reconnect tablespace from old setup to the
> new one with the same version of PGSQL?
>
> Thanks.
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: a.ignatov@postgrespro.ru, admin@leboutique.com
Subject: Re: reuse tablespace from crashed PSQL instance
In-Reply-To: <e276ff44-ae40-d17b-5489-0596237d6258@postgrespro.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox