Thread: Upgrade Ubuntu - PostgresSQL is ok?

-----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