Package: postgresql-common Version: 41 Severity: Wishlist Greetings,
When using pg_upgradecluster to migrate from 8.0 to 8.1 I ran into some
problems. Mainly this was that I had PostGIS installed in the 8.0
database and had some tables with geometry columns which depended upon
PostGIS. When pg_upgradecluster created the 8.1 cluster PostGIS wasn't
installed (and there doesn't seem to be any way to have PostGIS
installed between when the cluster is created and the restore is
started).
Therefore, I propose that pg_upgradecluster should either have a hook
where things can be run between the cluster being created and the
restore starting, or it should be able to be run against an existing
cluster (so the user could install the necessary components). An
associated fun an interesting question is how one might exclude things
from the restore.
I don't think this is a PostGIS-specific issue but really applies to
any module where an object in the database depends on the module being
installed.
Thanks!
Stephen
signature.asc
Description: Digital signature
