Home / ubuntu / Questions / 1304106
Accepted
Kokizzu
Asked: 2021-01-01 06:31:27 +0800 CST

Upgrading 18.04.5 to 20.04 LTS also upgrades postgresql?

  • 772

I'm doing do-release-upgrade now, and it seems it downloaded postgresql-12 package '__') was it automatically done? because I saw there's a tutorial to upgrade manually postgresql-10 to postgresql-12 here

UPDATE

so I've done the do-release-upgrade and both version runs (postgresql 12 on different port), then I did the data migration steps on this link still running (not yet completed) about 3.25 hours for 51GB of data.

18.04

2 Answers

  1. Best Answer

    when you do an upgrade of the ubuntu OS version, many other packages are also updated

    you can see the version of the postgresql package in each ubuntu release here : https://packages.ubuntu.com/search?keywords=postgresql

    at this moment : 18.04 -> postgres 10 & 20.04 : postgres 12

    enter image description here

    • 5

  2. Let's teach you how to use the rmadison script, included in the devscripts package.

    It queries the Ubuntu repositories for the current versions of a package in each release of Ubuntu. This is the same information that's shown on the http://packages.ubuntu.com website...but may be faster for folks who need to check frequently.

    Let's try it on postgresql

    $ rmadison postgresql
 postgresql | 9.1+129          | precise         | all
 postgresql | 9.1+129ubuntu1   | precise-updates | all
 postgresql | 9.3+154          | trusty          | all
 postgresql | 9.3+154ubuntu1.1 | trusty-security | all
 postgresql | 9.3+154ubuntu1.1 | trusty-updates  | all
 postgresql | 9.5+173          | xenial          | all
 postgresql | 9.5+173ubuntu0.3 | xenial-security | all
 postgresql | 9.5+173ubuntu0.3 | xenial-updates  | all
 postgresql | 10+190           | bionic          | all
 postgresql | 10+190ubuntu0.1  | bionic-security | all
 postgresql | 10+190ubuntu0.1  | bionic-updates  | all
 postgresql | 12+214           | focal           | all
 postgresql | 12+214ubuntu0.1  | focal-security  | all
 postgresql | 12+214ubuntu0.1  | focal-updates   | all
 postgresql | 12+216           | groovy          | all
 postgresql | 13+223           | hirsute         | all

    The output tells us that:

    • Ubuntu 18.04 uses postgresql 10 (10+190ubuntu0.1)
    • Ubuntu 20.04 uses postgresql 12 (12+214ubuntu0.1)

    This means that a do-release-upgrade from 18.04 to 20.04 of the postgresql package will indeed migrate you from version 10 to version 12 automatically.

    Look at the last two lines of output: A do-release-upgrade from Groovy (20.10) to Hirsute (21.04) will migrate you from version 12 to version 13.

    • 2