Re: I suggest improving install steps for CentOS 8

Hello,

I have found a problem with the following page.

page: /download/linux/redhat/

I tried install PostgreSQL12 into CentOS 8 as written on this page.
However, I couldn't install it by the following error.

# dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
# dnf install -y postgresql12
Failed to set locale, defaulting to C
PostgreSQL 10 for RHEL/CentOS 8 - x8 100 kB/s | 539 kB 00:05
PostgreSQL 11 for RHEL/CentOS 8 - x8 121 kB/s | 629 kB 00:05
PostgreSQL 12 for RHEL/CentOS 8 - x8 91 kB/s | 471 kB 00:05
PostgreSQL 9.4 for RHEL/CentOS 8 - x 75 kB/s | 361 kB 00:04
PostgreSQL 9.5 for RHEL/CentOS 8 - x 108 kB/s | 425 kB 00:03
PostgreSQL 9.6 for RHEL/CentOS 8 - x 55 kB/s | 518 kB 00:09
No match for argument: postgresql12
Error: Unable to find a match

There is a workaround for this problem.
I executed a below command.
I could install it.

# dnf module disable postgresql

This problem has already reported to Red Hat Bugzilla.
(https://bugzilla.redhat.com/show_bug.cgi?id=1718201#c1)

However, this problem has been already closed.
Because it seems that is not a bug.

Therefore I suggest that add a workaround in this document like an
attachment.

Thanks,

Adding -www as this isn't a documentation issue but a website issue.

> On 14 Nov 2019, at 03:36, Yasuhiro Horimoto <horimoto(at)clear-code(dot)com> wrote:
>
> Hello,
>
> I have found a problem with the following page.
>
> page: /download/linux/redhat/
>
> I tried install PostgreSQL12 into CentOS 8 as written on this page.
> However, I couldn't install it by the following error.
>
>
> # dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
> # dnf install -y postgresql12
> Failed to set locale, defaulting to C
> PostgreSQL 10 for RHEL/CentOS 8 - x8 100 kB/s | 539 kB 00:05
> PostgreSQL 11 for RHEL/CentOS 8 - x8 121 kB/s | 629 kB 00:05
> PostgreSQL 12 for RHEL/CentOS 8 - x8 91 kB/s | 471 kB 00:05
> PostgreSQL 9.4 for RHEL/CentOS 8 - x 75 kB/s | 361 kB 00:04
> PostgreSQL 9.5 for RHEL/CentOS 8 - x 108 kB/s | 425 kB 00:03
> PostgreSQL 9.6 for RHEL/CentOS 8 - x 55 kB/s | 518 kB 00:09
> No match for argument: postgresql12
> Error: Unable to find a match
>
>
> There is a workaround for this problem.
> I executed a below command.
> I could install it.
>
> # dnf module disable postgresql
>
> This problem has already reported to Red Hat Bugzilla.
> (https://bugzilla.redhat.com/show_bug.cgi?id=1718201#c1)
>
> However, this problem has been already closed.
> Because it seems that is not a bug.

Agreed, it's not a bug.

> Therefore I suggest that add a workaround in this document like an
> attachment.
>
> Thanks,
> diff --git a/templates/pages/download/linux/redhat.html b/templates/pages/download/linux/redhat.html
> index 568085a..3b0cbaf 100644
> --- a/templates/pages/download/linux/redhat.html
> +++ b/templates/pages/download/linux/redhat.html
> @@ -51,6 +51,9 @@ The PostgreSQL Yum Repository currently supports:
> <p><strong>^*Note</strong>: due to the shorter support cycle
> on Fedora, all supported versions of PostgreSQL are not available on this platform. We do not recommend
> using Fedora for server deployments.
> +
> +<p><strong>^*Note</strong>: PostgreSQL can't install in CentOS 8 or RedHat Enterprise 8 just execute the following steps.
> +We need to execute "dnf module disable postgresql" before install the client package.

This doesn't explain what the problem is, and why the above command works (or
what side effects it may have). I don't think it's a bad idea to mention this
problem on the page but we should phrase it in such a way that it's clear what
the underlying problem is, and what the fix means. Linking to offical RPM docs
can be a good way too?

cheers ./daniel

Hello,

Thank you for your comments.

I've fixed my patch according to your comments.
I attached it.

Thanks,

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
Subject: Re: I suggest improving install steps for CentOS 8
Date: Thu, 14 Nov 2019 10:29:01 +0100

> Adding -www as this isn't a documentation issue but a website issue.
>
>> On 14 Nov 2019, at 03:36, Yasuhiro Horimoto <horimoto(at)clear-code(dot)com> wrote:
>>
>> Hello,
>>
>> I have found a problem with the following page.
>>
>> page: /download/linux/redhat/
>>
>> I tried install PostgreSQL12 into CentOS 8 as written on this page.
>> However, I couldn't install it by the following error.
>>
>>
>> # dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
>> # dnf install -y postgresql12
>> Failed to set locale, defaulting to C
>> PostgreSQL 10 for RHEL/CentOS 8 - x8 100 kB/s | 539 kB 00:05
>> PostgreSQL 11 for RHEL/CentOS 8 - x8 121 kB/s | 629 kB 00:05
>> PostgreSQL 12 for RHEL/CentOS 8 - x8 91 kB/s | 471 kB 00:05
>> PostgreSQL 9.4 for RHEL/CentOS 8 - x 75 kB/s | 361 kB 00:04
>> PostgreSQL 9.5 for RHEL/CentOS 8 - x 108 kB/s | 425 kB 00:03
>> PostgreSQL 9.6 for RHEL/CentOS 8 - x 55 kB/s | 518 kB 00:09
>> No match for argument: postgresql12
>> Error: Unable to find a match
>>
>>
>> There is a workaround for this problem.
>> I executed a below command.
>> I could install it.
>>
>> # dnf module disable postgresql
>>
>> This problem has already reported to Red Hat Bugzilla.
>> (https://bugzilla.redhat.com/show_bug.cgi?id=1718201#c1)
>>
>> However, this problem has been already closed.
>> Because it seems that is not a bug.
>
> Agreed, it's not a bug.
>
>> Therefore I suggest that add a workaround in this document like an
>> attachment.
>>
>> Thanks,
>> diff --git a/templates/pages/download/linux/redhat.html b/templates/pages/download/linux/redhat.html
>> index 568085a..3b0cbaf 100644
>> --- a/templates/pages/download/linux/redhat.html
>> +++ b/templates/pages/download/linux/redhat.html
>> @@ -51,6 +51,9 @@ The PostgreSQL Yum Repository currently supports:
>> <p><strong>^*Note</strong>: due to the shorter support cycle
>> on Fedora, all supported versions of PostgreSQL are not available on this platform. We do not recommend
>> using Fedora for server deployments.
>> +
>> +<p><strong>^*Note</strong>: PostgreSQL can't install in CentOS 8 or RedHat Enterprise 8 just execute the following steps.
>> +We need to execute "dnf module disable postgresql" before install the client package.
>
> This doesn't explain what the problem is, and why the above command works (or
> what side effects it may have). I don't think it's a bad idea to mention this
> problem on the page but we should phrase it in such a way that it's clear what
> the underlying problem is, and what the fix means. Linking to offical RPM docs
> can be a good way too?
>
> cheers ./daniel
>

Hello,

Would this modification be acceptable?

Thanks,

From: Yasuhiro Horimoto <horimoto(at)clear-code(dot)com>
Subject: Re: I suggest improving install steps for CentOS 8
Date: Mon, 18 Nov 2019 16:21:05 +0900 (JST)

> Hello,
>
> Thank you for your comments.
>
> I've fixed my patch according to your comments.
> I attached it.
>
> Thanks,
>
> From: Daniel Gustafsson <daniel(at)yesql(dot)se>
> Subject: Re: I suggest improving install steps for CentOS 8
> Date: Thu, 14 Nov 2019 10:29:01 +0100
>
>> Adding -www as this isn't a documentation issue but a website issue.
>>
>>> On 14 Nov 2019, at 03:36, Yasuhiro Horimoto <horimoto(at)clear-code(dot)com> wrote:
>>>
>>> Hello,
>>>
>>> I have found a problem with the following page.
>>>
>>> page: /download/linux/redhat/
>>>
>>> I tried install PostgreSQL12 into CentOS 8 as written on this page.
>>> However, I couldn't install it by the following error.
>>>
>>>
>>> # dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
>>> # dnf install -y postgresql12
>>> Failed to set locale, defaulting to C
>>> PostgreSQL 10 for RHEL/CentOS 8 - x8 100 kB/s | 539 kB 00:05
>>> PostgreSQL 11 for RHEL/CentOS 8 - x8 121 kB/s | 629 kB 00:05
>>> PostgreSQL 12 for RHEL/CentOS 8 - x8 91 kB/s | 471 kB 00:05
>>> PostgreSQL 9.4 for RHEL/CentOS 8 - x 75 kB/s | 361 kB 00:04
>>> PostgreSQL 9.5 for RHEL/CentOS 8 - x 108 kB/s | 425 kB 00:03
>>> PostgreSQL 9.6 for RHEL/CentOS 8 - x 55 kB/s | 518 kB 00:09
>>> No match for argument: postgresql12
>>> Error: Unable to find a match
>>>
>>>
>>> There is a workaround for this problem.
>>> I executed a below command.
>>> I could install it.
>>>
>>> # dnf module disable postgresql
>>>
>>> This problem has already reported to Red Hat Bugzilla.
>>> (https://bugzilla.redhat.com/show_bug.cgi?id=1718201#c1)
>>>
>>> However, this problem has been already closed.
>>> Because it seems that is not a bug.
>>
>> Agreed, it's not a bug.
>>
>>> Therefore I suggest that add a workaround in this document like an
>>> attachment.
>>>
>>> Thanks,
>>> diff --git a/templates/pages/download/linux/redhat.html b/templates/pages/download/linux/redhat.html
>>> index 568085a..3b0cbaf 100644
>>> --- a/templates/pages/download/linux/redhat.html
>>> +++ b/templates/pages/download/linux/redhat.html
>>> @@ -51,6 +51,9 @@ The PostgreSQL Yum Repository currently supports:
>>> <p><strong>^*Note</strong>: due to the shorter support cycle
>>> on Fedora, all supported versions of PostgreSQL are not available on this platform. We do not recommend
>>> using Fedora for server deployments.
>>> +
>>> +<p><strong>^*Note</strong>: PostgreSQL can't install in CentOS 8 or RedHat Enterprise 8 just execute the following steps.
>>> +We need to execute "dnf module disable postgresql" before install the client package.
>>
>> This doesn't explain what the problem is, and why the above command works (or
>> what side effects it may have). I don't think it's a bad idea to mention this
>> problem on the page but we should phrase it in such a way that it's clear what
>> the underlying problem is, and what the fix means. Linking to offical RPM docs
>> can be a good way too?
>>
>> cheers ./daniel
>>

Hi,

On Thu, 2019-11-14 at 10:29 +0100, Daniel Gustafsson wrote:
> Adding -www as this isn't a documentation issue but a website issue.

Adding Magnus :-)

Seriously speaking, for RHEL 8, we need to add

dnf -qy module disable postgresql

command. Magnus, can you patch this when you can?

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

On Mon, Dec 9, 2019 at 1:11 PM Devrim Gündüz <devrim(at)gunduz(dot)org> wrote:

>
> Hi,
>
> On Thu, 2019-11-14 at 10:29 +0100, Daniel Gustafsson wrote:
> > Adding -www as this isn't a documentation issue but a website issue.
>
> Adding Magnus :-)
>
> Seriously speaking, for RHEL 8, we need to add
>
> dnf -qy module disable postgresql
>
> command. Magnus, can you patch this when you can?
>

Yeah, it seems like it would be better to add this as part of the
instructions rather than as a note on the side.

What is the normal time to do this, in the sequence. After the repository
rpm is installed but before client packages?

And is there any case you'd want to add the pg repositories but *not* do
this? I assume not?

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Hi,

On Mon, 2019-12-09 at 13:17 +0100, Magnus Hagander wrote:
>
> What is the normal time to do this, in the sequence. After the repository
> rpm is installed but before client packages?

Right.

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

On Mon, Dec 9, 2019 at 6:38 PM Devrim Gündüz <devrim(at)gunduz(dot)org> wrote:

>
> Hi,
>
> On Mon, 2019-12-09 at 13:17 +0100, Magnus Hagander wrote:
> >
> > What is the normal time to do this, in the sequence. After the repository
> > rpm is installed but before client packages?
>
> Right.
>
>
I have pushed an update for this to the site.

//Magnus

Hello,

Thank you very much for your update.

I can successfully installed PostgreSQL
on CentOS 8 by this procedure.

Thanks,

From: Magnus Hagander <magnus(at)hagander(dot)net>
Subject: Re: I suggest improving install steps for CentOS 8
Date: Tue, 10 Dec 2019 21:00:06 +0100

> On Mon, Dec 9, 2019 at 6:38 PM Devrim Gündüz <devrim(at)gunduz(dot)org> wrote:
>
>>
>> Hi,
>>
>> On Mon, 2019-12-09 at 13:17 +0100, Magnus Hagander wrote:
>> >
>> > What is the normal time to do this, in the sequence. After the repository
>> > rpm is installed but before client packages?
>>
>> Right.
>>
>>
> I have pushed an update for this to the site.
>
> //Magnus

Hi Magnus,

On Tue, 2019-12-10 at 21:00 +0100, Magnus Hagander wrote:
> I have pushed an update for this to the site.

Thanks a lot!

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