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.
In response to
pgsql-performance by date
|Next:||From: Marinos Yannikos||Date: 2008-05-26 22:44:05|
|Subject: Re: RAID controllers for Postgresql on large setups|
|Previous:||From: Tino Wildenhain||Date: 2008-05-26 19:19:03|
|Subject: Re: Symbolic Links to Tablespaces|