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 <[email protected] > 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 > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
