Postgres Pro
Downloads
Home   >   mailing lists

How to move a tablespace? - Mailing list pgsql-admin

From Chris Hoover
Subject How to move a tablespace?
Date
Msg-id 1d219a6f0706221114t25ddf96djf62297a8f1428cc2@mail.gmail.com
Whole thread Raw
Responses Re: How to move a tablespace?  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-admin
Tree view
How do you correctly move a tablespace? 

I am thinking this would be the process:
1.  Cleanly shutdown Postgres
2.  Move tablespace directory and all contents to new location
3.  Create a symlink from the new location back to the old location
4.  Restart Postgres

Would that be correct?  Or is there a better way.

Thanks,

Chris

pgsql-admin by date:

Previous
From: Erik Jones
Date:
Subject: Re: [GENERAL] Can I backup/restore a database in a sql script?
Next
From: Robert Treat
Date:
Subject: Re: How to move a tablespace?