move database from the default tablespace to a new one?

From: "Anton Melser" <melser(dot)anton(at)gmail(dot)com>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: move database from the default tablespace to a new one?
Date: 2008-05-16 15:07:40
Message-ID: 92d3a4950805160807v6068733k38961a555ead0024@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2008-05-16 15:15:13 Re: move database from the default tablespace to a new one?
Previous Message ${spencer} 2008-05-16 14:56:00 writing a function without installing a language