Forum OpenACS Q&A: migration from pg 7.1.3 to 7.2

Collapse
1: migration from pg 7.1.3 to 7.2
Posted by David Kuczek on 08/17/02 06:24 PM
Jonathan mentioned some days ago that the new vacuum already is a good
reason to migrate to pg 7.2...

Did anyone encounter problems with such a migration on oacs 3.2.5?

Collapse
2: Response to migration from pg 7.1.3 to 7.2 (response to 1)
Posted by Roberto Mello on 08/17/02 07:12 PM
I run OpenACS 3.2.5 with 7.2. IIRC I had to change one query in the sessions stuff, but I don't remember what it is anymore. I'll find out and post back. I remember it was easy to fix by looking at the query in the logs.
Collapse
3: Response to migration from pg 7.1.3 to 7.2 (response to 1)
Posted by Jonathan Ellis on 08/17/02 08:20 PM
I summarized what I found on the bboard in this thread

most of them I'd already fixed in my own customization; like Rob, the sec_sessions char->varchar fix was the only one I needed to apply when I upgraded.

however as Don noted either in that thread or elsewhere, if you're doing stuff with timestamp fields pre-7.2, change them to timestamp(0) in the dump when you upgrade. this will save you much type coercion down the road.