I use to use postgres quite a bit but have been working on a project for a
couple years that does not use it. I have finally convinced them to make
the switch after our current database hsqldb couldn't keep up with the
task.
So, for this project I will need postgres working on a debian server
(2.4.x), a centos 4 (2.6x) server and windows boxes for development.
Since I last used postgres it appears that it has become windows friendly.
Hurray at least for the developers. I have looked and it appears that
both the apt(debian) and yum (centos) repositories are living in the past
with version 7.5x. Clearly the windows users will want to use 8+. So
what do i do?
What do you recommend?
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?
2)Is there a reliable way to install 8.1x on debian and centos using apt
and yum?
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 would rather avoid
this cause I really like letting apt and yum maintain my compatibility
issues?
thanks everyone