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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
