Deployment failure of GovTool backend due to missing PostgreSQL repository

[placek]

Description:
The deployment of the GovTool backend application is failing due to an issue with installing the required PostgreSQL library. The base image used as the environment to compile the project must contain the PostgreSQL library, which is fetched from an external repository to ensure the use of a specific version.

The official documentation states that the required PostgreSQL repository should be available for Debian Buster (as described here: PostgreSQL for Debian). We are using the following script to add the repository and install PostgreSQL:

apt-get -y install curl ca-certificates lsb-release && \
install -d /usr/share/postgresql-common/pgdg && \
curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc && \
sh -c 'echo "deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' && \
apt-get update && \
apt-get install -y postgresql-14 libpq-dev

Error:
The deployment fails with the following error message:

Err:5 https://apt.postgresql.org/pub/repos/apt buster-pgdg Release
404  Not Found [IP: 147.75.85.69 443]
E: The repository 'https://apt.postgresql.org/pub/repos/apt buster-pgdg Release' does not have a Release file.

Steps to Reproduce:

1. Use the above script to add the PostgreSQL repository to a Debian Buster-based environment.
2. Run apt-get update and apt-get install for postgresql-14 and libpq-dev.
3. Observe the deployment failure due to a 404 error for the repository.

Expected Behavior:
The deployment process should successfully add the required PostgreSQL repository and install the PostgreSQL library and dependencies without any errors.

Actual Behavior:
The deployment fails due to a 404 error when trying to fetch the PostgreSQL repository, indicating that the repository URL may be incorrect or missing for the specified environment.

Possible Causes:

• The PostgreSQL repository URL for Debian Buster (buster-pgdg) is incorrect or deprecated.
• There may be an issue with the repository configuration or version compatibility.

Suggested Solutions:

1. Verify if the repository URL is correct for the Debian Buster version or if there has been any update or deprecation.
2. Check if an alternative PostgreSQL version or repository is available that supports Debian Buster.
3. Update the base image or environment to a newer version that supports the required PostgreSQL library.

Additional Information:

• Environment: Debian Buster
• PostgreSQL Version: 14
• Deployment tool: Docker (or specify if different)

Attachments:
Logs showing the error encountered during deployment (example).