Thread: Possible to Attach/Detach Tablespaces?

New to PG, just wondering if there's anyway to say.. I want t Full
backup of DB-Sample and I can just tar up the directory containing that
tablespace, copy it to another PG server and then re-attach it?

Thanks

Ow Mun Heng wrote:
> New to PG, just wondering if there's anyway to say.. I want t Full
> backup of DB-Sample and I can just tar up the directory containing that
> tablespace, copy it to another PG server and then re-attach it?

No. Apart from anything else OID and transaction numbers would be all wrong.

--
   Richard Huxton
   Archonet Ltd

Am Mittwoch, 1. August 2007 10:07 schrieb Ow Mun Heng:
> New to PG, just wondering if there's anyway to say.. I want t Full
> backup of DB-Sample and I can just tar up the directory containing that
> tablespace, copy it to another PG server and then re-attach it?

No.

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