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

Reply via email to