Open link in a new tab

Content

Expand project menu

PostgresSQL 10 installation fails on Centos 8 stream

I have a fresh Centos 8 Stream server that I have been trying to install/configure openproject on.  It seems to be failing on installing PostgresSQL v10

When the UI exits:

[openproject] ./bin/configure
DONE
[legacy-installer] ./bin/preinstall
[openproject-edition] ./bin/preinstall
[postgres] ./bin/preinstall
INFO: autoinstall=install. A new PostgreSQL v10 server will be installed locally unless a conflicting installation is found.
INFO: Checking whether port 45432 is available... OK
+ echo 'INFO: Installing PostgreSQL v10...'
INFO: Installing PostgreSQL v10...
+ dnf install -y https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Failed to set locale, defaulting to C.UTF-8
Last metadata expiration check: 0:00:17 ago on Thu Jun 24 16:48:45 2021.
[MIRROR] pgdg-redhat-repo-latest.noarch.rpm: Status code: 404 for https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm (IP: 147.75.85.69)
[MIRROR] pgdg-redhat-repo-latest.noarch.rpm: Status code: 404 for https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm (IP: 147.75.85.69)
[MIRROR] pgdg-redhat-repo-latest.noarch.rpm: Status code: 404 for https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm (IP: 147.75.85.69)
[MIRROR] pgdg-redhat-repo-latest.noarch.rpm: Status code: 404 for https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm (IP: 147.75.85.69)
[FAILED] pgdg-redhat-repo-latest.noarch.rpm: Status code: 404 for https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm (IP: 147.75.85.69)
Status code: 404 for https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm (IP: 147.75.85.69)

Message actions

A quick search on the issue indicates that this URL shouldn't be used anymore.

https://postgrespro.com/list/thread-id/2528985

Message actions

The official Postgresql install documentation at  https://www.postgresql.org/download/linux/redhat/ says to use this URL for 10 and other versions:

https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Message actions

Hi everyone,

the PostgreSQL installation source has changed and we appear to have missed that. We just released 11.3.4 that fixes that for Centos 7 and 8:

https://github.com/opf/openproject/releases/tag/v11.3.4

Just pull the latest package from the OpenProject package source and it should work then.

Best

Oliver