Re: Possible to Attach/Detach Tablespaces?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Possible to Attach/Detach Tablespaces?
Date: 2007-08-01 08:36:32
Message-ID: 46B04610.1070003@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2007-08-01 08:40:50 Re: Possible to Attach/Detach Tablespaces?
Previous Message Richard Huxton 2007-08-01 08:35:20 Re: Problem With gunzip backup