Thanks for the reply. > developer@xxxxxxxxxxxx writes: >> 1)Do I run these old versions on my linux servers and the new version >> 8.1x >> for development? If I do this will I have to constantly battle >> compatibility issues when going from development to the production >> servers? Will it be a big headache? Will I be missing out on major >> performance or features? > > No, yes, yes, and yes. You do not want to be running PG 7.anything > anymore if you can help it. If your intention is to go into production > very soon, standardize on 8.1.x ... if your production release date is a > few months out, you'd be doing yourself a favor to adopt 8.2 now. > (8.2RC1 should be available by Monday.) Is 8.2 that much different from 8.1? The change log seems to indicate an easy upgrade using pg dump. I really need stability, is 8.2 really there yet? > >> 2)Is there a reliable way to install 8.1x on debian and centos using apt >> and yum? > > Look into Debian unstable, or if you are partial to Red Hat-derived > stuff look into Fedora. I have and if it is there I can't find it. > >> 3)Should I just compile from source on the linux boxes? Should I expect >> any problems with this even on the old 2.4 kernel? > > I'd advise you to be using a 2.6 kernel at this point, too. I don't > know what the Centos guys have in mind as a schedule for releasing > a 2.6-based distro, but again Fedora is at least as good a bet if you > want a Red Hat based distro without official Red Hat support. > I agree with your sentiments on 2.6. The Centos 4 is a 2.6 kernel, however the debian server I am using is 2.4 just because it has been around for a while and I probably can't change that for another year. I assume 8 will still work on 2.4 though. > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >
