migrating a tablespace between postgres instances in shared disk environment

Started by Paula Ta-Shmaalmost 19 years ago2 messagesgeneral
Jump to latest
#1Paula Ta-Shma
PAULA@il.ibm.com

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

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Paula Ta-Shma (#1)
Re: migrating a tablespace between postgres instances in shared disk environment

Am Montag, 14. Mai 2007 15:35 schrieb Paula Ta-Shma:

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) �?

No.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/