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.
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users