From: Tino Wildenhain <tino@wildenhain.de>
To: Heikki Linnakangas <heikki@enterprisedb.com>
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:19:03 +0200
Message-ID: <483B0D27.8070100@wildenhain.de> (raw)
In-Reply-To: <483B00C3.5030005@enterprisedb.com>
References: <B10E6810AC2A2F4EA7550D072CDE8760CDDD7B@SAB-FENWICK.sab.uiuc.edu>
<21505.1211814531@sss.pgh.pa.us>
<B10E6810AC2A2F4EA7550D072CDE8760CDDD81@SAB-FENWICK.sab.uiuc.edu>
<483B00C3.5030005@enterprisedb.com>
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?
T.
Attachments:
smime.p7s (application/x-pkcs7-signature, 3.2K) download
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: tino@wildenhain.de, heikki@enterprisedb.com, lance@illinois.edu, tgl@sss.pgh.pa.us
Subject: Re: Symbolic Links to Tablespaces
In-Reply-To: <483B0D27.8070100@wildenhain.de>
* 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