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: (view raw, whole thread or download thread mbox)
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.




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-2017 The PostgreSQL Global Development Group