From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Campbell, Lance <lance@illinois.edu>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Symbolic Links to Tablespaces
Date: Mon, 26 May 2008 19:26:11 +0100
Message-ID: <483B00C3.5030005@enterprisedb.com> (raw)
In-Reply-To: <B10E6810AC2A2F4EA7550D072CDE8760CDDD81@SAB-FENWICK.sab.uiuc.edu>
References: <B10E6810AC2A2F4EA7550D072CDE8760CDDD7B@SAB-FENWICK.sab.uiuc.edu>
<21505.1211814531@sss.pgh.pa.us>
<B10E6810AC2A2F4EA7550D072CDE8760CDDD81@SAB-FENWICK.sab.uiuc.edu>
Campbell, Lance wrote:
> Once I have assigned tables and indexes to a particular tablespace that
> points to a particular location on disk is there a simple way to move
> the files to a new location?
>
> Example:
> Table xyz is using tablespace xyz_tbl which is located at
> /somedir/xyz_tbl on the disk. If I want to move it to a new disk
> located at /someotherdir/xyz_tbl/ how can I do that easily?
Shut down the database server, replace the symbolic link in
data/pg_tblspc to the new location, and start the server again. The
location is also stored in pg_tablespace catalog; you'll need to fix it
with "UPDATE pg_tablespace SET spclocation ='/someotherdir/xyz_tbl'
WHERE spcname='xyz_tbl'", or pg_dumpall will still show the old location.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: heikki@enterprisedb.com, lance@illinois.edu, tgl@sss.pgh.pa.us
Subject: Re: Symbolic Links to Tablespaces
In-Reply-To: <483B00C3.5030005@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox