[postgis-users] Migration from 1.3.1 to 2.0

[Stephen Woodbridge]

Excellent! this was my assumption, but I really appreciate the 
confirmation. Yes on the backup, we are moving to a new server/OS on new 
box and holding the old as our master until everything can be verified 
on the new box.

Thanks,
   -Steve

On 1/25/2014 10:55 AM, Bborie Park wrote:
> 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 <mailto: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 <mailto:postgis-users at lists.osgeo.org>
>     http://lists.osgeo.org/cgi-__bin/mailman/listinfo/postgis-__users
>     <http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users>
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>