Обсуждение: 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