[postgis-users] Upgrade Postgres & Postgis

[Graeme Gould]

Hi

I am in the process of upgrading PostgreSQL 8.2 to 9.0 and Postgis 1.2.1 to 1.5.2-3.  The installations went well once I had logged onto the server as a local administrator, however this where I hit a problem.

I am transferring the data by running pg_dump on the 8.2 server and using pg_restore on the 9.0 server.  Most of the data is restored, however there are instances in the new tables where the geometry columns are blank where they were once populated.  This is causing an issue when I try and load the data layer in to my GIS application.

Does anyone have any thoughts/solution to this?

Cheers

Graeme


---------------------------------------------------------------------------------------------------------------------
This email and any files transmitted with it are confidential and intended solely for the use 
of the individual or entity to whom they are addressed. If you have received this email in 
error please let us know by email reply and delete it from your system. 

Please note that any views or opinions presented in this email are solely those of the 
author and do not necessarily represent those of Grand Union Housing Group. 

Finally, the recipient should check this email and any attachments for the presence of viruses. 
Grand Union Housing Group accepts no liability for any damage caused by any virus 
transmitted by this email. 

Grand Union Housing Group
Registered Office: 
Katherines House
Dunstable Street
Ampthill
Bedfordshire
MK45 2JP 
Registered under the Industrial and Provident Societies Act 1965 Registered No. 30388R 
Housing Corporation Registered No. L4518 

http://www.grandunionhousing.co.uk
--------------------------------------------------------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101208/a297e380/attachment.html>