[postgis-users] Upgrade Postgres & Postgis

[Ralf Suhr]

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