Postgres Pro
Downloads
Home   >   mailing lists

Re: Reorganizing a database objects - Mailing list pgsql-novice

From Alan Hodgson
Subject Re: Reorganizing a database objects
Date
Msg-id 201108081029.12528.ahodgson@simkin.ca
Whole thread Raw
In response to Reorganizing a database objects  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-novice
Tree view 
On August 8, 2011 10:06:43 AM JORGE MALDONADO wrote:
> Should I
> create a new DB that reference such new locations (Tablespaces), backup
> the original one and restore it to the new one?

You can ALTER a table or index to change its tablespace.

pgsql-novice by date:

Previous
From: JORGE MALDONADO
Date:
Subject: Reorganizing a database objects
Next
From: JORGE MALDONADO
Date:
Subject: Moving a PostgreSQL database to a new tablespace