Unable to install pgsql under RHEL8

Hi,

I am not able to install postgresql11 under a fresh RHEL8.

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

They are enabled:

# yum --quiet repolist pgdg1*
repo id repo name status
pgdg10 PostgreSQL 10 8 - x86_64 239
pgdg11 PostgreSQL 11 8 - x86_64 104

Packages are known by the repository:

# yum --quiet repoquery --repo pgdg11 postgresql11-server*
postgresql11-server-0:11.2-2PGDG.rhel8.x86_64
postgresql11-server-0:11.3-1PGDG.rhel8.x86_64

But they are unknown from local cache:

# yum search postgresql11-server
Updating Subscription Management repositories.
Last metadata expiration check: 0:23:08 ago on Fri May 17 00:23:20 2019.
No matches found.

If I try to groupinstall:

# yum groupinstall postgresqldbserver11
Updating Subscription Management repositories.
Last metadata expiration check: 0:24:27 ago on Fri May 17 00:23:20 2019.
No match for group package "postgresql11"
No match for group package "postgresql11-contrib"
No match for group package "postgresql11-server"
Dependencies resolved.
=========================================================================
Package Arch Version Repository Size
=========================================================================
Installing group/module packages:
postgresql11-libs x86_64 11.3-1PGDG.rhel8 pgdg11 385 k
[...]

If I yum install using direct URL, it obviously works and pull
postgresql11-libs as dependency:

# yum install $PGDG_URL/postgresql11-11.3-1PGDG.rhel8.x86_64.rpm
$PGDG_URL/postgresql11-server-11.3-1PGDG.rhel8.x86_64.rpm

Any clue? Some issue with the provided package list?

Thanks,

Hi,

On Fri, 2019-05-17 at 00:57 +0200, Jehan-Guillaume de Rorthais wrote:
> I am not able to install postgresql11 under a fresh RHEL8.

Yeah, I saw it yesterday, too :( I built the new packages. Testing them ATM,
will release very soon.

Check the repo in 1,5 hours, please.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Hi Devrim,

On Fri, 17 May 2019 08:56:44 +0300
Devrim Gündüz <devrim(at)gunduz(dot)org> wrote:

> On Fri, 2019-05-17 at 00:57 +0200, Jehan-Guillaume de Rorthais wrote:
> > I am not able to install postgresql11 under a fresh RHEL8.
>
> Yeah, I saw it yesterday, too :( I built the new packages. Testing them ATM,
> will release very soon.

Thanks!

> Check the repo in 1,5 hours, please.

I suppose I'll have to be a bit more patient, or maybe your publication get
stuck somewhere in the middle?

Cannot download
'https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-8-x86_64':
Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors
were tried.

Cannot download
'https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-8-x86_64':
Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors
were tried.

Plus, lots of packages for other releases are still missing from package
lists :/

Let me know if I can do anything to help.

Cheers,

Hi,

On Fri, 2019-05-17 at 10:40 +0200, Jehan-Guillaume de Rorthais wrote:
> I suppose I'll have to be a bit more patient, or maybe your publication get
> stuck somewhere in the middle?

Yeah. The repoview command fails because of some customization that I made on
the previous build server and missing on the new one. I'll keep you updated.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

On Fri, 17 May 2019 13:00:18 +0300
Devrim Gündüz <devrim(at)gunduz(dot)org> wrote:

> Hi,
>
> On Fri, 2019-05-17 at 10:40 +0200, Jehan-Guillaume de Rorthais wrote:
> > I suppose I'll have to be a bit more patient, or maybe your publication get
> > stuck somewhere in the middle?
>
> Yeah. The repoview command fails because of some customization that I made on
> the previous build server and missing on the new one. I'll keep you updated.

Thanks! Good luck.

Hi,

On Fri, 2019-05-17 at 10:40 +0200, Jehan-Guillaume de Rorthais wrote:
> I suppose I'll have to be a bit more patient, or maybe your publication get
> stuck somewhere in the middle?

They should be in the repo now.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

On Fri, 17 May 2019 14:35:08 +0300
Devrim Gündüz <devrim(at)gunduz(dot)org> wrote:

> Hi,
>
> On Fri, 2019-05-17 at 10:40 +0200, Jehan-Guillaume de Rorthais wrote:
> > I suppose I'll have to be a bit more patient, or maybe your publication get
> > stuck somewhere in the middle?
>
> They should be in the repo now.

No more luck:

[root(at)srv1 ~]# yum install postgresql11 postgresql11-server \
postgresql11-contrib resource-agents-paf
Updating Subscription Management repositories.
Last metadata expiration check: 0:00:49 ago on Fri May 17 16:33:48 2019.
No match for argument: postgresql11
No match for argument: postgresql11-server
No match for argument: postgresql11-contrib
No match for argument: resource-agents-paf
Error: Unable to find a match

[root(at)srv1 ~]# yum search postgresql11
Updating Subscription Management repositories.
Last metadata expiration check: 0:00:57 ago on Fri May 17 16:33:48 2019.
======================================================================
Name Matched: postgresql11
======================================================================
postgresql11-tcl.x86_64 : A Tcl client library for PostgreSQL
postgresql11-libs.x86_64 : The shared libraries required for any PostgreSQL
clients postgresql11-odbc.x86_64 : PostgreSQL ODBC driver
postgresql11-devel.x86_64 : PostgreSQL development header files and libraries
postgresql11-llvmjit.x86_64 : Just-in-time compilation support for PostgreSQL
postgresql11-plpython.x86_64 : The Python procedural language for PostgreSQL

Just to keep the list up to date, an issue has been opened there:

https://redmine.postgresql.org/issues/4296

So far, the best workaround I found is to disable the module "postgresql"
from the official appstream distribution:

[root(at)localhost ~]# yum -qy module enable postgresql
[root(at)localhost ~]# yum -q info postgresql11-server|grep ^Name
Error: No matching Packages to list
[root(at)localhost ~]# yum -qy module disable postgresql
[root(at)localhost ~]# yum -q info postgresql11-server|grep ^Name
Name : postgresql11-server

++

On Wed, 5 Jun 2019 12:44:30 +0200
Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com> wrote:

> Just to keep the list up to date, an issue has been opened there:
>
> https://redmine.postgresql.org/issues/4296

For you information, Ken Gaillot adviced me to file a bug on the RH bug tracker
system. So here it is:

https://bugzilla.redhat.com/show_bug.cgi?id=1718201

++

Hi,

On Fri, 2019-06-07 at 10:50 +0200, Jehan-Guillaume de Rorthais wrote:
> For you information, Ken Gaillot adviced me to file a bug on the RH bug
> tracker
> system. So here it is:
>
> https://bugzilla.redhat.com/show_bug.cgi?id=1718201

I committed the fix that is mentioned here:

https://git.postgresql.org/gitweb/?p=pgrpms.git;a=commit;h=b94a8ca9b0c9fffb0d9d230161f1b4a0da8b60d3

I am not releasing the updated packages, until I get some feedback from some
people. I tested this on RHEL 6,7,8 and Fedora 29,30 . RHEL 6 and 7 did not
complain, which is good.

Still, more eyes will be better.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Hi,

On Thu, 27 Jun 2019 14:32:53 -0400
Devrim Gündüz <devrim(at)gunduz(dot)org> wrote:

> On Fri, 2019-06-07 at 10:50 +0200, Jehan-Guillaume de Rorthais wrote:
> > For you information, Ken Gaillot adviced me to file a bug on the RH bug
> > tracker
> > system. So here it is:
> >
> > https://bugzilla.redhat.com/show_bug.cgi?id=1718201
>
> I committed the fix that is mentioned here:
>
> https://git.postgresql.org/gitweb/?p=pgrpms.git;a=commit;h=b94a8ca9b0c9fffb0d9d230161f1b4a0da8b60d3
>
> I am not releasing the updated packages, until I get some feedback from some
> people.

Well, I'm really on the fence in regard with this fix. PGDG packages are not
hotfixes :/

In the past, PGDG repo was requiring to exclude some distro packages to work
correctly. Maybe the best fix for RHEL 8 is to require to disable the
postgresql module ?

Moreover, I believe the best plan is in fact to provide modules from the pgdg
repo itself. But this is a total different story, much bigger project
altogether.

> I tested this on RHEL 6,7,8 and Fedora 29,30 . RHEL 6 and 7 did not
> complain, which is good.

normal, they are probably ignoring this parameter as it is related to modules.
EL 6 and 7 are not aware of modules.