Install Postgresql on Ubuntu 18.04 Bionic (repo removed)

Question

I'm getting

E: The repository 'https://apt.postgresql.org/pub/repos/apt bionic-pgdg Release' no longer has a Release file.

on sudo apt update. That means that repo for bionic is not accessible.

In my case for this time I can't upgrade Ubuntu version to a newer one and somehow need to manage that. In this case I suppose I need to remove file from /etc/apt/sources.list.d which contains:

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

But then how can I have a possibility to install Postgresql on Bionic? Is there any way e.g. to download and install from source?

Wise

"Is there any way e.g. to download and install from source?" Yes. Start here. – Recalescence

@Someprogrammerdude thanks. Downloading from source is more life the last resort. Now I'm just wondering that Postgresql provide that they still support Bionic: postgresql.org/download/linux/ubuntu but in real - they don't. – Wise

Read Bionic not suppported. It includes instructions on where it has been moved to. – Adalineadall

Answer 1

The packages have been moved to apt-archive.

Point your sources.list entry to

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

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

Exactitude

its showing me as deb command not found.... also I am unable to install postgesql 14 – Marxismleninism

@SidharthPanda you update by opening the file sudo vi /etc/apt/sources.list.d/pgdg.list and replacing the containing line deb http://apt.postgresql.org/pub/repos/apt bionic-pgdg main with deb https://apt-archive.postgresql.org/pub/repos/apt bionic-pgdg main. Save and exit. – Hex

yeah i already fixed it, thanks @Hex – Marxismleninism

Answer 2

The PostgreSQL repo package for Linux seems to be missing. You can install PostgreSQL from source by getting it from the unofficial GitHub repository:repo. You choose the right branch of PostgreSQL depending on the version of PostgreSQL you want, then do installation process from your terminal.

Mangonel

1) The source can be found on the Download page under Source code at link File Browser. 2) This message shows you where to get the archived packages for Ubuntu. – Adalineadall

...And you've verified that if I clone the source code, I'm getting the exact same thing as when I click the download link on postgresql.org? Projects this large rarely work in such a simplistic fashion. – Ci

The source code from GitHub is from postgresql.org, whether you get the same thing or different depends on your installation procedure. – Mangonel