Migrating a Database to a new tablespace

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Migrating a Database to a new tablespace
Date: 2006-04-18 12:05:27
Message-ID: 4444D607.1000309@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

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.

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mark True 2006-04-18 18:19:20 Looking for some help with cascading updates...
Previous Message Achilleus Mantzios 2006-04-18 11:32:40 Re: [SQL] Thoughts on a Isolation/Security problem.