1

I have a server using Ubuntu Server 18.04 that I have to upgrade to 20.04.

The problem is when I tried to update, Postgresql no longer have a release file for Bionic.

What is the best way to go forward? I can think only this 3 choices, if possible:

  1. Do 'do-release-upgrade' without updating.
  2. Uncomment 'postgersql' package, and 'do-release-upgrade', and later updating postgresql.
  3. Uninstall 'postgresql' and do 'do-release-upgrade'
karel
  • 122,292
  • 133
  • 301
  • 332
anipard
  • 13

2 Answers2

1

https://www.postgresql.org/message-id/ZN4OigxPJA236qlg%40msg.df7cb.de

You need to change repository in apt to:

deb https://apt-archive.postgresql.org/pub/repos/apt bionic-pgdg main

RiZZaK
  • 11
0

Ubuntu uses versioned postgresql like so:

ii  postgresql                                     14+238                                       all          object-relational SQL database (supported version)
ii  postgresql-10                                  10.23-0ubuntu0.18.04.1                       amd64        object-relational SQL database, version 10 server
ii  postgresql-12                                  12.14-0ubuntu0.20.04.1                       amd64        object-relational SQL database, version 12 server
ii  postgresql-14                                  14.9-0ubuntu0.22.04.1                        amd64        The World's Most Advanced Open Source Relational Database
ii  postgresql-client-10                           10.23-0ubuntu0.18.04.1                       amd64        front-end programs for PostgreSQL 10
ii  postgresql-client-12                           12.14-0ubuntu0.20.04.1                       amd64        front-end programs for PostgreSQL 12
ii  postgresql-client-14                           14.9-0ubuntu0.22.04.1                        amd64        front-end programs for PostgreSQL 14

So it may get removed, but you'll be able to re-install it once you've upgraded.

Alexis Wilke
  • 2,787