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
