Postgres Pro
Downloads
Home   >   mailing lists

Re: Possible to Attach/Detach Tablespaces? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Possible to Attach/Detach Tablespaces?
Date
Msg-id 46B04610.1070003@archonet.com
Whole thread Raw
In response to Possible to Attach/Detach Tablespaces?  (Ow Mun Heng <Ow.Mun.Heng@wdc.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Problem With gunzip backup
Next
From: Peter Eisentraut
Date:
Subject: Re: Possible to Attach/Detach Tablespaces?