I was just sitting here wondering:

I'm quite used to working with Sql Server (Microsoft's Version) and not entirely a newbie with MySQL. But i sit here with my Ubuntu 16.04 LTS desktop Developer machine at home, and read about the marvels of installing snaps.

Then i read about PostgreSql as a snap, and it hits me that I believe i read something about it being hard to do a system upgrade with PostgreSql installed in your system. So i was wondering if having a PostgreSql Snap package installed instead would change that, since the PostgreSql Server is then technically isolated?

I did some googleling but could not seem to find a clear answer. Anyhow, this is a question of mere curiosity, but thank you for your time.


If your reference to a difficult system upgrade with postgres installed, this is not true.

What's difficult for some is when one builds an infrastructure around a specific version of postgres, and then later a system upgrade to a newer version of Ubuntu includes a newer postgres, which may have broken compatibility with all the custom infrastructure built on the old version.

Being packaged in snap form doesn't make this any easier or harder to deal with, in and of itself. What matters here is how the packaging is done. If there are different versioned packages for each version of postgres, then it can be easier to stay on a particular version, and to choose when to upgrade to the newer versions. However, this can also leave you with a happily running and insecure version of postgres, if you don't keep up to date with the latest versions and keep your custom software built around the older versions, especially when they stop receiving any security updates.

  • 1
    So i guess my real question would be more like: "Does a system upgrade also upgrade/disable your snaps?" – rasmus91 Oct 28 '16 at 21:22
  • 1
    No, it doesn't. – dobey Oct 28 '16 at 21:24
  • 1
    So it would stay "running happily and insecure" :) – rasmus91 Oct 28 '16 at 21:32
  • 1
    No, snaps are updated via the snap store. Whether it's insecure or not is dependent on what the developer uploads to the store, as described in my answer. – dobey Oct 28 '16 at 21:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.