Thread: Attaching/detaching tablespaces (or, in general, parts of a DB)
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.
On 04/06/11 7:05 PM, 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. pg_dump -Fc somedatabase | pg_restore -h newhost newdb voila, no temp space used.
Le 07/04/2011 04:05, Yang Zhang a écrit : > 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? > No, you can't. But you actually don't need to. Users won't be able to access the objects you're moving, so no issues. -- Guillaume http://www.postgresql.fr http://dalibo.com
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.kumar@enterprisedb.com Blog:http://vibhork.blogspot.com