[postgis-users] Upgrade Postgres & Postgis

[Graeme Gould]

Hi Ralf

Thanks for the response.  Think I should have been clearer - it does not seem to be the geometry column table that is the issue, but the geometry field in the data table that is occasionally missing data.  It is in the original table in version 8.2 but is not picked up in the backup or restore process.

Graeme

-----Original Message-----
From: Ralf Suhr [mailto:Ralf.Suhr at itc-halle.de] 
Sent: 08 December 2010 12:11
To: Graeme Gould
Cc: PostGIS Users Discussion
Subject: Re: [postgis-users] Upgrade Postgres & Postgis

Hi Graeme,

the table definition for geometry_columns has changed. You can add the old 
columns:
ALTER TABLE geometry_columns ADD COLUMN attrelid oid;
ALTER TABLE geometry_columns ADD COLUMN varattnuminteger;
ALTER TABLE geometry_columns ADD COLUMN stats histogram2d;

Gr
Ralf

Am Mittwoch 08 Dezember 2010, 12:50:50 schrieb 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
> ---------------------------------------------------------------------------
> -----------------------------------------


---------------------------------------------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------------------------------------------