22

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?

Improve this question
3
  • "Is there any way e.g. to download and install from source?" Yes. Start here. Commented Nov 6, 2023 at 8:16
  • @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. Commented Nov 6, 2023 at 8:23
  • Read Bionic not suppported. It includes instructions on where it has been moved to. Commented Nov 6, 2023 at 15:57

2 Answers 2

Reset to default
62

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

Improve this answer
Sign up to request clarification or add additional context in comments.

4 Comments

its showing me as deb command not found.... also I am unable to install postgesql 14
@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.
yeah i already fixed it, thanks @Laenka-Oss
maybe RUN sed -i s/apt.postgresql.org/apt-archive.postgresql.org/g /etc/apt/sources.list.d/pgdg.list would be helpful
-1

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.

Improve this answer

3 Comments

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.
...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.
The source code from GitHub is from postgresql.org, whether you get the same thing or different depends on your installation procedure.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.