pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedreuse tablespace from crashed PSQL instance
4+ messages / 2 participants
[nested] [flat]
* reuse tablespace from crashed PSQL instance
@ 2016-06-21 08:23 Artem Tomyuk <admin@leboutique.com>
0 siblings, 1 reply; 4+ messages in thread
From: Artem Tomyuk @ 2016-06-21 08:23 UTC (permalink / raw)
To: pgsql-admin
Hi.
Is it possible to reconnect tablespace from old setup to the new one with
the same version of PGSQL?
Thanks.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: reuse tablespace from crashed PSQL instance
@ 2016-06-21 08:38 Alex Ignatov <a.ignatov@postgrespro.ru>
parent: Artem Tomyuk <admin@leboutique.com>
0 siblings, 1 reply; 4+ messages in thread
From: Alex Ignatov @ 2016-06-21 08:38 UTC (permalink / raw)
To: Artem Tomyuk <admin@leboutique.com>; pgsql-admin
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> wrote:
Hi.
Is it possible to reconnect tablespace from old setup to the new one with the same version of PGSQL?
Thanks.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: reuse tablespace from crashed PSQL instance
@ 2016-06-21 08:40 Artem Tomyuk <admin@leboutique.com>
parent: Alex Ignatov <a.ignatov@postgrespro.ru>
0 siblings, 1 reply; 4+ messages in thread
From: Artem Tomyuk @ 2016-06-21 08:40 UTC (permalink / raw)
To: Alex Ignatov <a.ignatov@postgrespro.ru>; +Cc: 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.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> wrote:
>
> Hi.
>>
>> Is it possible to reconnect tablespace from old setup to the new one with
>> the same version of PGSQL?
>>
>> Thanks.
>>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: reuse tablespace from crashed PSQL instance
@ 2016-06-21 09:56 Alex Ignatov <a.ignatov@postgrespro.ru>
parent: Artem Tomyuk <admin@leboutique.com>
0 siblings, 0 replies; 4+ messages in thread
From: Alex Ignatov @ 2016-06-21 09:56 UTC (permalink / raw)
To: Artem Tomyuk <admin@leboutique.com>; +Cc: pgsql-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.
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2016-06-21 09:56 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-06-21 08:23 reuse tablespace from crashed PSQL instance Artem Tomyuk <admin@leboutique.com>
2016-06-21 08:38 ` Alex Ignatov <a.ignatov@postgrespro.ru>
2016-06-21 08:40 ` Artem Tomyuk <admin@leboutique.com>
2016-06-21 09:56 ` Alex Ignatov <a.ignatov@postgrespro.ru>
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