[postgis-users] Migration from 1.3.1 to 2.0

Stephen Woodbridge woodbri at swoodbridge.com
Fri Jan 24 20:53:41 PST 2014


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


More information about the postgis-users mailing list