[postgis-users] Migration from 1.3.1 to 2.0

[Bborie Park]

The only thing that should be different is that the geometry datatype will
not be constrained (geometry vs geometry(POINT, 4326)). It'll probably be
constrained using the traditional column constraints.

Otherwise, I don't see any problems. Just make sure to have a full backup
of the DB.

-bborie


On Fri, Jan 24, 2014 at 8:53 PM, Stephen Woodbridge <woodbri at swoodbridge.com
> wrote:

> Hi,
>
> I need to migrate a database
>
> from:
>
> PostgreSQL 8.2.14
> POSTGIS="1.3.1" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.5.0, 22 Oct 2006"
> USE_STATS
>
> to:
>
> Postgresql 9.2.x
> POSTGIS 2.0.x
>
> Will using pg_dump to dump just the tables I need in plain text format,
> then load them into a new database with the postgis extension work? or will
> I run into problems doing this?
>
> Thanks,
>   -Steve W
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140125/16b75bd5/attachment.html>