updating to 8.3.x

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: Ben <bench(at)silentmedia(dot)com>, "Postgres General List" <pgsql-general(at)postgresql(dot)org>
Subject: updating to 8.3.x
Date: 2008-09-17 20:58:10
Message-ID: dcc563d10809171358q19dd6781l98e97e5ae699b8ae@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In another thread, Ben mentioned the issues he's running into with
upgrading to 8.3 and lack of some of the old implicit (but wrong) type
conversion.

> Remember 8.3 also gives you the "opportunity" to fix all the sloppy code in
> your application that depends upon implicit casting. If that's as expensive
> for you to fix as it is for us, then you won't be moving to 8.3 any time
> soon.

What we did to fix our code was to upgrade to 8.3.3 in development
first, and fix all the bugs (about 40 or 50) we could see that popped
up in the sql logs regarding type mismatches. then, in production, we
replaced our 8.1 slony slave with an 8.3 slony slave and set it to
handle half the read load. We found another dozen or so bad sql
statements doing that, and fixed and released new code that night.

Then after that we swapped the 8.3 for the 8.1 server and then added
the other new server, also running 8.3 to replace the 8.1 server.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2008-09-17 21:13:00 Re: Textmatchning
Previous Message Scott Marlowe 2008-09-17 20:43:56 Re: 8.3.3 stability ?