move database from the default tablespace to a new one?
Hi all,
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?
Cheers
Anton
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