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

[Eric Lam]

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.

thanks
Eric Lam