Ticket #1391 (new defect)

Opened 5 months ago

Last modified 6 weeks ago

postgis errors during upgrade of old db

Reported by: robe Owned by: strk
Priority: medium Milestone: PostGIS 2.0.1
Component: build/upgrade/install Version: trunk
Keywords: Cc:

Description

strk,

Here are the errors I see in the db I moved over from my PostgreSQL 8.4 windows 2003 PostGIS 1.5 (32-bit) -> windows 2008 64-bit PostGIS 2.0 (running 32-bit PostGIS/PostreSQL 9.1).

they might all be expected but the intructions say I should not be getting errors. Note: I intentionally did not install the legacy.sql fully expecting that the script would not try to restore old deprecated functions so some of these might be the result of sql/plpgsql user functions not being able to find old ones. I suspect though that many of these are postgis packaged ones since most of these I don't recall ever using in my code on this db.

This is a database that has been upgraded many times since pre-1.0 and was currently 1.5.3.

See attached file.

Attachments

errors_clean.txt Download (63.6 KB) - added by robe 5 months ago.

Change History

Changed 5 months ago by robe

Changed 5 months ago by strk

Could you re-run after an svn up, pass -v to postgis_restore.pl and save stderr to a file ? You can redirect stdout to /dev/null as I won't care about that for now.

I hope the above makes sense for you

Changed 5 months ago by strk

@robe: planning to do this before alpha ?

Changed 5 months ago by robe

no

Changed 3 months ago by strk

@robe: planning to do this before beta3 ?

Changed 2 months ago by robe

  • milestone changed from PostGIS 2.0.0 to PostGIS 2.0.1

Changed 6 weeks ago by strk

@robe : you mentioned you didn't have any problem lately ? or am I wrong ?

Note: See TracTickets for help on using tickets.