[postgis-users] copying PostGIS database from 9.0.4 Postgres (PostGIS 1.5.2) to 9.1.4 Postgres (PostGIS 2.0.0)?

[adrian.kitchingman at dse.vic.gov.au]

Hi All

I'm attempting to copy a PostGIS database from a 9.0.4 Postgres (PostGIS 
1.5.2) Server  to a 9.1.4 Postgres (PostGIS 2.0.0) Server on a different 
machine. Is this even possible? I've been trying this via a backup restore 
or running a backup plain sql file on the new server database but keep 
running into errors. I've tried doing this after running the legacy.sql 
file as per instructions here (
http://postgis.refractions.net/documentation/manual-svn/postgis_installation.html#hard_upgrade
) to no avail. I've also moved my data to a different schema as per Paul 
Ramsey's suggestion <
http://blog.cleverelephant.ca/2010/09/postgis-back-up-restore.html>.
Any suggestions on how best to do this if it is possible? Or is this a 
case of 1.5.2 not being compatible with 2.0.0?

Cheers

Adrian



Notice:
This email and any attachments may contain information that is personal, confidential,
legally privileged and/or copyright. No part of it should be reproduced, adapted or communicated without the prior written consent of the copyright owner. 

It is the responsibility of the recipient to check for and remove viruses.

If you have received this email in error, please notify the sender by return email, delete it from your system and destroy any copies. You are not authorised to use, communicate or rely on the information contained in this email.

Please consider the environment before printing this email.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120619/7785e941/attachment.html>