[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,
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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
More information about the postgis-users
mailing list