pg_dump and pg_restore
Assuming you've reserved the public schema for contrib modules like cube and postgis, upgrading it is as easy as
pg_dumping everything except the public schema.
pg_dump -N public dbname
Then pg_restore into a new upgraded postgis enabled database.
(You may want to follow this up with probe_geometry_columns() to repopulate public.geometry_columns if that's important
to you)
If my assumption is incorrect, well, then you've got some work ahead of you. postgis_restore.pl is the upgrade script,
but personally, I don't trust that it works either. If I were you, I'd move all your tables (using ALTER TABLE ...)
into a different schema and proceed as above. You can generate an ALTER TABLE sql script with a single SQL query.
Hope that helps,
Kevin
Willy-Bas Loos wrote:
Hi,
I want to migrate a postgis database from postgis 1.1.6 on debian to
1.3.3 on windows. (i know, i like linux better too)
what's the correct way to go about that?
Will the perl script postgis_restore.pl work?
I'm trying it out, but i am encountering some problems that might not be
related.
So would it work in theory or is there a better way?
thx
WBL
--
"Patriotism is the conviction that your country is superior to all
others because you were born in it." -- George Bernard Shaw
------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
