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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
