[postgis-users] postgis on postgresql 8.2 vs 8.3
lr at pcorp.us
Wed Mar 25 08:28:44 PDT 2009
Well according to this its already 1 month behind, but I think you can
expect it within the next 2-3 months since it is almost in beta release now.
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Stephen
Sent: Wednesday, March 25, 2009 11:35 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] postgis on postgresql 8.2 vs 8.3
Thank you for your feedback.
I was struggling to get the postgresql-8.2 Debian source package to build,
finally got it in the wee hours of the morning. So that gives me the option
of staying on 8.2 that I was afraid I might not have.
Since this is a new system and only has a trivial database that is easy to
dump and restore, I guess I will do the 8.3 upgrade so I have a box running
8.3 and can see how that goes. If it turns out to be problematic then I will
consider downgrading the system back to 8.2.
The big application I want running immediately is pgRouting and related
Is there a time frame for the 8.4 release that you are aware of?
Obe, Regina wrote:
> Just to add my 2 cents. I've been running 8.3 on 2 production
> systems for about 6-8 months now. Aside from the index issue Mark
> already mentioned, and also a bbox issue (with cached bboxes not
> always being recalculated -- hmm I think this is fixed in 8.3.6 --
> though I'll need to verify) , I haven't run into any issues as far as
> PostGIS is concerned.
> However -- I think the biggest problem that people run into when
> upgrading from 8.2 to 8.3 is that they took out a lot of autocasting
> behavior so if you did things like assuming boolean can be treated as
> 1 and were less than careful with dates and numbers I forget the
> others you may run into issues. So you may want to test some of your
> apps in a test mode first before blindly upgrading. (Sorry to scare
> you like that). I haven't run into such issues myself since the apps
> I have in
> 8.3 started out in 8.3. I have yet to go back and upgrade my other
> apps running on an 8.2 install.
> As far as what you get with upgrading and things to watch out for, I
> think its pretty well summarized here if you haven't already taken a
> Although I'm almost tempted to say if you haven't upgraded yet you
> might just want to wait for 8.4. 8.4 has all the major earth
> shattering enhancements in it without any additional fuss (as there
> was with 8.3 -- e.g removal of casting change that breaks apps) so you
> only need to test your apps once. Can't wait for that to officially come
> Hope that helps,
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> Stephen Woodbridge
> Sent: Tuesday, March 24, 2009 11:21 PM
> To: PostGIS Users Discussion
> Subject: [postgis-users] postgis on postgresql 8.2 vs 8.3
> Hi all,
> I have been holding back on upgrading my postgis installations from
> postgresql 8.2 to 8.3 because:
> 1) it seemed like there was a lot of new postgresql stuff to figure
> out in 8.3. What are the big changes I need to be aware of?
> 2) it seemed like there were initially some bugs and issues in
> postgresql 8.3 that I'm guessing have mostly been resolved
> 3) seemed like there have been or still are some postgis issues when
> running on postgresql 8.3
> Is postgis and 8.3 safe and stable? are there specific bugs I need to
> aware of? Do we have a list somewhere and work-arounds?
> On my Debian box, I installed postgresql 8.2 long ago and have just
> onto it, but the packages are no longer available in the archives and
> sometime later I added liblq5-dev package which appears to have come
> from 8.3 which is causing me headaches.
> I can upgrade to 8.3, does this require a dump and restore, or is
> there a hot upgrade for postgis databases?
> I can try and find a debian postgresql-8.2 source package and see if I
> can build the .deb files from that, but it seems like I will like need
> to upgrade to 8.3 regardless at some point.
> So I looking for advice, feedback, whatever.
postgis-users mailing list
postgis-users at postgis.refractions.net
More information about the postgis-users