| 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:33:21 |
| Message-ID: | 444CA971.3000505@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?
Via some scripting, I now migrated all tables and indices, however I
found no way to migrate sequences.
The problem is that I cannot just move the tablespace itsself via
mv/symlink/fiddling_of_systables, because the tablespace contains some
other databases that are meant to remain there.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schaber | 2006-04-24 11:34:33 | Re: Migrating a Database to a new tablespace |
| Previous Message | Markus Schaber | 2006-04-24 10:05:41 | Re: Migrating a Database to a new tablespace |