Re: [GENERAL] move database from the default tablespace to a new one?

Anton Melser a écrit :
> Is this possible? I have a db that has been living in the default
> tablespace, and I am trying to separate out the transaction logs (and
> log archiving) and the data. It seems that tablespaces are the way to
> go... but the database exists and I need to separate them out. Any
> pointers?

Create a tablespace and move each individual relations of this database
in the new tablespace :
* ALTER TABLE ... SET TABLESPACE ...

http://www.postgresql.org/docs/8.3/interactive/sql-altertable.html

* ALTER INDEX ... SET TABLESPACE ...

http://www.postgresql.org/docs/8.3/interactive/sql-alterindex.html

Regards.

--
Guillaume.

http://www.postgresqlfr.org

http://dalibo.com

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