Postgres Pro
Downloads
Home   >   mailing lists

Thread: move database from the default tablespace to a new one?

move database from the default tablespace to a new one?

From
"Anton Melser"
Date:
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

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

From
Guillaume Lelarge
Date:
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