On 29/04/2014 13:09, Mark Felder wrote:
It has been fantastic; I can't recommend it enough.
My experience upgrading from 3.1.8 today was not so good.
I am running FreeBSD 9.2, Postgres 9.2 from ports.
Trouble started when I stopped aox, did a pkg upgrade that brought a new
9.2, and restarted - no fun.
No matter I thought - I'll upgrade to 3.2.
First thing I found was that the Jamfile assumes a new gcc; I only had
one that barfed with -Wno-unused-result. I installed 4.9 and forced
the build to use it.
Then schema update failed at: d->t->enqueue( "drop index ald" );
I didn't have any such index. I have no idea why. check schema was
quite happy. I commented that out and db upgrade to schema 97 worked OK
(well, once I had installed the 9.2-contrib package and installed
citext, anyway).
I also had to change this:
if (Postgres::version() < 90300)
s.append( "a.procpid" );
else
s.append( "a.pid" );
My Postgres 9.2.8 pg_stat_activity definitely uses 'pid', not 'procpid'.
James
