On Saturday, May 3, 2014 11:00:17 PM CEST, [email protected]
wrote:
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.
Sorry to hear that.
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.
I've committed a change so the the release will not use -Werror.
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'm going to ignore this.
I'm somewhat unhappy about check schema. It's not quite strict enough.
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'.
I've changed that to 90200 now. Unless Abhijit disagrees?
Arnt
