Postgres Pro
Downloads
Home   >   mailing lists

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

Moving a database to a new TABLESPACE in Postgres 8.3

From
Robert James
Date:
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

From
"Kevin Grittner"
Date:
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