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

Eric Lam elam at lisasoft.com
Wed Mar 8 22:07:39 PST 2006

Hi list,

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.

Eric Lam

More information about the postgis-users mailing list