How to move a tablespace?

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org>
Subject: How to move a tablespace?
Date: 2007-06-22 18:14:43
Message-ID: 1d219a6f0706221114t25ddf96djf62297a8f1428cc2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Treat 2007-06-23 04:29:42 Re: How to move a tablespace?
Previous Message Erik Jones 2007-06-22 17:24:50 Re: [GENERAL] Can I backup/restore a database in a sql script?