| From: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
|---|---|
| To: | Yang Zhang <yanghatespam(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Attaching/detaching tablespaces (or, in general, parts of a DB) |
| Date: | 2011-04-07 14:09:05 |
| Message-ID: | 2BC9E887-8791-459B-87F6-18C48C1DD31F@enterprisedb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Apr 7, 2011, at 7:35 AM, Yang Zhang wrote:
> Is it possible to attach or detach parts of a DB (e.g. tablespaces),
> such that I can flexibly move the disks containing the DB tables
> around to different hosts?
>
> The last discussion I could find on this topic is from 2007, and the
> answer was "No":
>
> http://postgresql.1045698.n5.nabble.com/Possible-to-Attach-Detach-Tablespaces-td1885602.html
>
> Wondering if there's been any change to the answer since then. I can
> alternatively dump/load, which is slower and requires 2x the disk
> space. Thanks in advance.
No. You can't do that.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Gould | 2011-04-07 14:31:20 | Re: Protecting stored procedures |
| Previous Message | Guillaume Lelarge | 2011-04-07 13:59:30 | Re: Attaching/detaching tablespaces (or, in general, parts of a DB) |