migrating a tablespace between postgres instances in shared disk environment - Mailing list pgsql-general

From Paula Ta-Shma
Subject migrating a tablespace between postgres instances in shared disk environment
Date
Msg-id OFC102CAF3.603AF87F-ONC22572DB.004934FB-C22572DB.004AB38B@il.ibm.com
Whole thread Raw
Responses Re: migrating a tablespace between postgres instances in shared disk environment
List pgsql-general
Is there a way to allow migration of a single table/database/tablespace
from one postgres instance to another (in a system with multiple
tables/databases/tablespaces)  ?
The postgres instances would all share their storage using a clustered file
system.
Ideally, one postgres instance would "close" a table/database/tablespace
and another postgres instance would then "open" it, to support the
migration.
But I didn't find a way to "close" anything without destroying it.
Is there a way to do this using Postgres ?

thanks
Paula


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: EXCEPTION clause not identified
Next
From: Marco Colombo
Date:
Subject: a few questions on backup