[postgis-users] moving data from postgis 1.x to 0.x
schabi at logix-tt.com
Thu Mar 9 01:59:42 PST 2006
Eric Lam wrote:
> What is the quickest/most efficient way of getting postgres/postgis
> geometry data from a 1.1.1 postgis to a 0.8.2 postgis version?
> At the moment I am "pgsql2shp" and then "shp2pgsql -w" then using the
> resultant file to input into old postigs. This takes a very long time
> since the 1.X version is installed on a 700Mhz linux box.
Due to the different canonical representation used, I think this is the
But beware of the "numeric type growing" that appears when converting
between shp and sql, maybe it's best to use "shp2pgsql -a -w" and copy
the table definition via "pg_dump --schema-only".
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
More information about the postgis-users