[postgis-users] moving data from postgis 1.x to 0.x

Markus Schaber schabi at logix-tt.com
Thu Mar 9 01:59:42 PST 2006

Hi, Eric,

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
easiest way.

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 mailing list