[postgis-users] migrating from linux to windows

Kevin Neufeld kneufeld at refractions.net
Thu Nov 6 08:17:19 PST 2008

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,

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
> -- 
> "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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list