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/