Re: Changing FS when full - Mailing list pgsql-general

From Fernando Schapachnik
Subject Re: Changing FS when full
Date
Msg-id 20100122125052.GA1571@bal740r0.mecon.ar
Whole thread Raw
In response to Re: Changing FS when full  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
En un mensaje anterior, Greg Smith escribió:
> >So, any way of instructing PG (8.1 if that matters) to place those
> >files elsewhere without an initdb?
> >
>
> You can create another table just like the original on a tablespace
> using the new storage, drop the original, and then rename the new one to
> the original name.  This is described as "another way to cluster data"
> in the Notes section of
> http://www.postgresql.org/docs/8.4/static/sql-cluster.html , and it has
> a few warnings related to information that can be lost in this
> situation.  Make sure you've moved all temporary files onto the new
> filesystem first, observing the warning about that there too.

One question: is this different from ALTER TABLE ... SET TABLESPACE?

Thanks.

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: When is the release date for Postgres 8.5?
Next
From: John Mitchell
Date:
Subject: Re: What locking mechanism is used for database backup and restore and Master-Slave Replication?