Re: Changing FS when full

Поиск
Список
Период
Сортировка
От Fernando Schapachnik
Тема Re: Changing FS when full
Дата
Msg-id 20100122125052.GA1571@bal740r0.mecon.ar
обсуждение исходный текст
Ответ на Re: Changing FS when full  (Greg Smith <greg@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: When is the release date for Postgres 8.5?
Следующее
От: John Mitchell
Дата:
Сообщение: Re: What locking mechanism is used for database backup and restore and Master-Slave Replication?