Postgres Pro
Downloads
Home   >   mailing lists

Re: Moving a database to a new TABLESPACE in Postgres 8.3 - Mailing list pgsql-general

From Kevin Grittner
Subject Re: Moving a database to a new TABLESPACE in Postgres 8.3
Date
Msg-id 20121219220644.14710@gmx.com
Whole thread Raw
In response to Moving a database to a new TABLESPACE in Postgres 8.3  (Robert James <srobertjames@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Robert James
Date:
Subject: Moving a database to a new TABLESPACE in Postgres 8.3
Next
From: Adrian Klaver
Date:
Subject: Re: pg_xlog is getting bigger