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