Обсуждение: Moving a database to a new TABLESPACE in Postgres 8.3

Поиск
Список
Период
Сортировка

Moving a database to a new TABLESPACE in Postgres 8.3

От
Robert James
Дата:
In Postgres 8.3, how can I move a database to a different TABLESPACE?
My goal is to move rarely used databases off of the SSD and onto the
HDD.

Re: Moving a database to a new TABLESPACE in Postgres 8.3

От
"Kevin Grittner"
Дата:
Robert James wrote:

> In Postgres 8.3, how can I move a database to a different TABLESPACE?
> My goal is to move rarely used databases off of the SSD and onto the
> HDD.

http://www.postgresql.org/docs/8.3/interactive/sql-createtablespace.html

http://www.postgresql.org/docs/8.3/interactive/sql-altertable.html

-Kevin