On Sun, Oct 17, 2010 at 11:32 PM, Shawn <[email protected]> wrote: > I have a slightly odd situation and would like to hear how others have > handled this. > > I have recently set up a Ubuntu 10.04 server to run an application that is > under development. 10.04 was chosen because it is a long term support > version/distro. The idea being that we would stick with "stable" software. > > One of the other applications in development will be moved to this server > soonish. The developers for the second app have recently discovered the new > features of PostgreSQL 9.x and have expressed a desire to update. > > I've tested the first app against PgSQL 9, and it works fine there. But, > 10.04 does not have PostgreSQL 9 in the repositories, and likely never will. > > Now I know I can just add the backports repository to the server, and > install PgSQL 9, but the question is "should I"? > It depends. For something like this I would be inclined to add the back ports or a PPA for PgSQL.
> On one hand, I do like the idea of getting the latest features (database > replication is supposed to be very easy now..). On the other hand, if I > move to more recent "unstable" apps (not that I consider PgSQL unstable), > then why stick with the long term support server? > The obvious advantage is that the rest of the system provides a stable and supported base upon which to base an application. Especially when the footprint of your changes is so small I would probably go this route. The headache of upgrading every six months (I am not a fan of Ubuntu releases that are not LTS ones, they are at best a kind of beta release) coupled with having to wait two years for PgSQL 9 makes this an easy choice for me. The other alternative is to look at a different platform or Linux distro. Things start to get hairy if you are using custom kernels with userland dependencies. I guess it really boils down to the specifics of a given situation. This kind of question does not lend itself well to an easy default answer IMO. _______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca Mailing List Guidelines (http://clug.ca/ml_guidelines.php) **Please remove these lines when replying

