From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Tino Wildenhain <tino@wildenhain.de>
Cc: 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 21:26:15 +0100
Message-ID: <483B1CE7.9030201@enterprisedb.com> (raw)
In-Reply-To: <483B0D27.8070100@wildenhain.de>
References: <B10E6810AC2A2F4EA7550D072CDE8760CDDD7B@SAB-FENWICK.sab.uiuc.edu>
<21505.1211814531@sss.pgh.pa.us>
<B10E6810AC2A2F4EA7550D072CDE8760CDDD81@SAB-FENWICK.sab.uiuc.edu>
<483B00C3.5030005@enterprisedb.com>
<483B0D27.8070100@wildenhain.de>
Tino Wildenhain wrote:
> Heikki Linnakangas wrote:
> ...
>> 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.
>>
> wouldn't alter tablespace be not more easy and less fragile?
Yes. But it requires copying all the data.
--
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, tino@wildenhain.de, lance@illinois.edu, tgl@sss.pgh.pa.us
Subject: Re: Symbolic Links to Tablespaces
In-Reply-To: <483B1CE7.9030201@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