Moving a database to a new TABLESPACE in Postgres 8.3

Started by Robert Jamesover 13 years ago2 messagesgeneral
Jump to latest
#1Robert James
srobertjames@gmail.com

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Kevin Grittner
Kevin.Grittner@wicourts.gov
In reply to: Robert James (#1)
Re: Moving a database to a new TABLESPACE in Postgres 8.3

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general