The repository 'https://apt.postgresql.org/pub/repos/apt bionic-pgdg Release' does not have a Release file

Overview

PostgreSQL decided to remove Bionic apt.postgresql.org and move it to apt-archive.postgresql.org.

This was carried out on Nov 5th.

For that reason, some older stacks might have outdated information on/etc/apt/sources.list.d/pgdg.listand Chef runs will fail for this reason.

While we are working on a permanent fix for v6, this has not yet been implemented at the time of writing this, and might never get implemented on any stack older than v6. In the long term, you should consider Migrating your instances to v7 Stack, or the latest stack at the time you are reading this.

Solution

The suggested process is using the overlay method. Specifically, if you are running stack v6 and the permanent fix mentioned in the overview has not been completed yet, you must edit the pgdg file from the runbook under /etc/chef/recipes/cookbooks/postgresql/files/default/pgdg.list

  • Current value:
    • deb https://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
      deb https://apt-archive.postgresql.org/pub/repos/apt bionic-pgdg-archive main
  • Expected value:
    • deb https://apt-archive.postgresql.org/pub/repos/apt bionic-pgdg main
      deb https://apt-archive.postgresql.org/pub/repos/apt bionic-pgdg-archive main

Comments

Article is closed for comments.