Обсуждение: Upgrade Ubuntu - PostgresSQL is ok?
Hi there,
So my question is, am I worrying over nothing? Should I just go ahead and upgrade Ubuntu distribution?
I have a server running Ubuntu 12.04 LTS. On this machine, I have the following PostgreSQL version installed:
PostgreSQL 9.3.5 on X86 64-unkown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit
Ubuntu has been prompting me to upgrade my distribution to '14.04.1 LTS' for a few months now. But I've resisted as I'm nervous about it causing problems with my PostgreSQL database. It's essential to the work that I am doing at the moment.
So my question is, am I worrying over nothing? Should I just go ahead and upgrade Ubuntu distribution?
Thanks
James
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 El 09/01/15 a les 12:05, James David Smith ha escrit: > Hi there, > > I have a server running Ubuntu 12.04 LTS. On this machine, I have > the following PostgreSQL version installed: > > PostgreSQL 9.3.5 on X86 64-unkown-linux-gnu, compiled by gcc > (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit > > Ubuntu has been prompting me to upgrade my distribution to '14.04.1 > LTS' for a few months now. But I've resisted as I'm nervous about > it causing problems with my PostgreSQL database. It's essential to > the work that I am doing at the moment. > > So my question is, am I worrying over nothing? Should I just go > ahead and upgrade Ubuntu distribution? Hi, If it's so important to you and you don't need any new feature that you may receive with the upgrade, I wouldn't do it yet. You have maintenance guaranteed until 2017 (https://wiki.ubuntu.com/Releases) as 12.04 is an LTS. On the other hand, you shouldn't have any problem with the upgrade process, but there's no zero risk in this things. Josep -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iQIcBAEBAgAGBQJUr7d2AAoJEJBOJru8PbFKFgcP/j8zQb6uhSIB8fgYlstTlqZ5 mhIl1/b2qaTaqg61Ge1zGG8bDIfZ9jKepLXZlk0BTwc56w6u/cWvzqe7aVWcIOqI onzTlP9zU+Dqu08KtXepLS6OFoouz41lrGWwenTAj+FGKyaMDD+ethbVWWQ06yFx NsweBj/RmNfSKXyimm2B+OM16Cr7MIBHcfZB/oaTMuAZtEo/Mc7532YYytODpWBV USLWyB9srhIRRioIa2PSA5qbxtY3072HjfSK32v6CDeMvFaGPHPcNLukGPkDhF9K CwcgUTMzcFN23DfjcmB8nrEj6U1a0OM/UiYcrQasO3KG4l7KNtmmHa1FwcNzXN/C utEwEM6kkIDhF7b1j5o7AM+aa+kb7axW1Km4UneGvHaTva4gkrqoZssbteyfvIpW ci3/SeMuBDsHsXetqBXbYuL7tVtAMH98BzGxZz2+PynG2BQudzCeuwAmByW62+54 dJITXBYMNWeigPG9Hzvn9Nu1pmpr5xPAW6BMxjfxI8nvz9qzSysYYBWQUkN1vM1v SWdeWD/rz9m6edsgJ1LccY1J6alYRA4z2Q/CjR6N1m355HIGku9DUQPYMvrI1FDs fv0qqOVatcjV8bSeQ2211WTwSLNxZ/i6wAX+J4XZYdXo6HdKoUrRdqdN+NNJTSmu 1rFnZZ5gtdSuGV9Yp4R/ =LftZ -----END PGP SIGNATURE-----
On 01/09/2015 03:05 AM, James David Smith wrote: > Hi there, > > I have a server running Ubuntu 12.04 LTS. On this machine, I have the > following PostgreSQL version installed: > > PostgreSQL 9.3.5 on X86 64-unkown-linux-gnu, compiled by gcc > (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit > > Ubuntu has been prompting me to upgrade my distribution to '14.04.1 > LTS' for a few months now. But I've resisted as I'm nervous about it > causing problems with my PostgreSQL database. It's essential to the > work that I am doing at the moment. > > So my question is, am I worrying over nothing? Should I just go ahead > and upgrade Ubuntu distribution? > > Do make sure you have a good PostgreSQL dump prior to any upgrades, of course, but to upgrade or not depends on how much time you have to test, do the upgrade, and fix any resulting issues compared to any benefits you feel you will get. BUT! Do be aware that the default kernel in 12.04 has some "lethally bad" performance problems (http://www.databasesoup.com/2014/11/good-kernel-bad-kernel.html). I recently upgraded some systems from 12.04 to 14.04 with no changes to PostgreSQL and am now happily free of the query timeout errors that had started to plague me. Whether or not that is important to you depends on how you are using PostgreSQL. Cheers, Steve