Re: Migrating a Database to a new tablespace

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Markus Schaber <schabi(at)logix-tt(dot)com>
Cc: PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Migrating a Database to a new tablespace
Date: 2006-04-24 10:05:41
Message-ID: 444CA2F5.4030705@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

Markus Schaber wrote:

> What is the easiest way to migrate a complete database from one
> tablespace to another?
>
> ALTER DATABASE only allows to set the default tablespace, but not
> migrating the existing database.

Is there really no way to do this?

Thanks,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Schaber 2006-04-24 10:33:21 Re: Migrating a Database to a new tablespace
Previous Message Bruno Wolff III 2006-04-24 03:37:49 Re: date array