Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group