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

From: "Kevin Grittner" <kgrittn(at)mail(dot)com>
To: "Robert James" <srobertjames(at)gmail(dot)com>,"Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Moving a database to a new TABLESPACE in Postgres 8.3
Date: 2012-12-19 22:06:44
Message-ID: 20121219220644.14710@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-12-19 23:52:19 Re: pg_xlog is getting bigger
Previous Message Robert James 2012-12-19 21:58:26 Moving a database to a new TABLESPACE in Postgres 8.3