Troubleshooting Access Issues to Webpage Due to PostgreSQL Change in v6

Overview

A customer may experience difficulties accessing their site due to a host error. This has been reported for stack v6

Solution

This issue occurs because the upstream PostgreSQL project has archived the packages for Ubuntu bionic, which is the base of Stack v6. As such, this line prompts Chef to fail as the repository is no longer there.

The suggested process for a quicker fix is to modify the blank ey-custom Recipes. Still, you can consider using the less recommended overlay method. Specifically, you can modify the URI under /etc/apt/sources.list.d/pgdg.list:

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

Replace the old value with the 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

In the long term, consider migrating your instances to v7 Stack to enjoy faster fixes.

Summary

By modifying the URI under `/etc/apt/sources.list.d/pgdg.list` to reflect the new location, the customer can resolve the issue of accessing the webpage due to a host error caused by a change made by PostgreSQL. For a long-term solution, consider migrating your instances to v7 Stack.

FAQ

  1. What is the cause of the host error when accessing the webpage?
    The host error is caused by a change made by PostgreSQL, which moved Bionic apt.postgresql.org to apt-archive.postgresql.org.
  2. How can I resolve this issue?
    You can resolve this issue by modifying the URI under `/etc/apt/sources.list.d/pgdg.list` to reflect the new location.
  3. What is the long-term solution to this problem?
    The long-term solution to this problem is to migrate your instances to v7 Stack.

Comments

Article is closed for comments.