MIME-Version: 1.0
References: <CAFeSbqi+oTocrvQT9fEwF3B4btcVQp7hW2LdY8iLLSn3SRj0vw@mail.gmail.com>
 <38f7cd4c-8586-4c34-9770-a70e083823a5@aklaver.com> <CAFeSbqiVNCeadL=BezW+SyzpOxU9rpqkFJPMKhtBxOz0AWZWFg@mail.gmail.com>
 <4a246d11-d250-414e-a7e6-1aeb6d1264aa@aklaver.com> <0a805069f207406b6c68a023bda5a9bbcda1db16.camel@gunduz.org>
In-Reply-To: <0a805069f207406b6c68a023bda5a9bbcda1db16.camel@gunduz.org>
From: Paul Brindusa <paulbrindusa88@gmail.com>
Date: Tue, 8 Oct 2024 09:01:39 +0100
Message-ID: <CAFeSbqiw7wF5aK06dfraX6=uczWsCCcYHQPu0tJ4dL1zdL7PLA@mail.gmail.com>
Subject: Re: libpq5 error
To: =?UTF-8?B?RGV2cmltIEfDvG5kw7x6?= <devrim@gunduz.org>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c419f50623f28c95"
Archived-At: <https://www.postgresql.org/message-id/CAFeSbqiw7wF5aK06dfraX6%3DuczWsCCcYHQPu0tJ4dL1zdL7PLA%40mail.gmail.com>
Precedence: bulk

--000000000000c419f50623f28c95
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

 Good morning Devrim,

Is libpq5 an important component that needs the upgrade?
I am wanting to try after Adrian's suggestion yesterday to see if I can
update the repo file first of all since it came with the rest of the
updates.

If that does not solve it, I would consider disabling the package.

On Tue, Oct 8, 2024 at 8:48=E2=80=AFAM Devrim G=C3=BCnd=C3=BCz <devrim@gund=
uz.org> wrote:

> Hi,
>
> On Mon, 2024-10-07 at 08:44 -0700, Adrian Klaver wrote:
> > > Unknown Error occurred: Transaction test error:\n file
> > > /usr/share/pgsql/postgres.bki from install of
> > > libpq5-17.0-42PGDG.rhel9.x86_64 conflicts with file from package
> > > postgresql-server-15.8-1.module+el9.4.0+25512+c6b50a48.x86_64\n file
> > > /usr/share/pgsql/system_constraints.sql from install of
> > > libpq5-17.0-42PGDG.rhel9.x86_64 conflicts with file from package
> > > postgresql-server-15.8-1.module+el9.4.0+25512+c6b50a48.x86_64\n.
>
> Ah ok. So basically it means PostgreSQL is installed from Red Hat
> packages, not PGDG. I would suggest you either not to use PGDG repos at
> all for consistency, or switch to PGDG repo and use our packages as a
> whole.
>
> ...or you can edit /etc/yum.repos.d/pgdg-redhat-all.repo file, and add
>
> exclude=3Dlibpq5
>
> under the [pgdg-common] section so that dnf will ignore that.
>
> Regards,
>
>
> --
> Devrim G=C3=BCnd=C3=BCz
> Open Source Solution Architect, PostgreSQL Major Contributor
> Twitter: @DevrimGunduz , @DevrimGunduzTR
>


--=20
Kind Regards,
Paul Brindusa
paulbrindusa88@gmail.com

--000000000000c419f50623f28c95
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div>=C2=A0Good morning Devrim,</div><div=
><br></div><div>Is libpq5 an important component that needs the upgrade?</d=
iv><div>I am wanting to try after Adrian&#39;s suggestion yesterday to see =
if I can update the repo file first of all since it came with the rest of t=
he updates.</div><div><br></div><div>If that does not solve it, I would con=
sider disabling the package.<br></div></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Tue, Oct 8, 2024 at 8:48=E2=80=AFA=
M Devrim G=C3=BCnd=C3=BCz &lt;<a href=3D"mailto:devrim@gunduz.org" target=
=3D"_blank">devrim@gunduz.org</a>&gt; wrote:<br></div><blockquote class=3D"=
gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20=
4,204,204);padding-left:1ex">Hi,<br>
<br>
On Mon, 2024-10-07 at 08:44 -0700, Adrian Klaver wrote:<br>
&gt; &gt; Unknown Error occurred: Transaction test error:\n file <br>
&gt; &gt; /usr/share/pgsql/postgres.bki from install of <br>
&gt; &gt; libpq5-17.0-42PGDG.rhel9.x86_64 conflicts with file from package =
<br>
&gt; &gt; postgresql-server-15.8-1.module+el9.4.0+25512+c6b50a48.x86_64\n f=
ile<br>
&gt; &gt; /usr/share/pgsql/system_constraints.sql from install of <br>
&gt; &gt; libpq5-17.0-42PGDG.rhel9.x86_64 conflicts with file from package =
<br>
&gt; &gt; postgresql-server-15.8-1.module+el9.4.0+25512+c6b50a48.x86_64\n.<=
br>
<br>
Ah ok. So basically it means PostgreSQL is installed from Red Hat<br>
packages, not PGDG. I would suggest you either not to use PGDG repos at<br>
all for consistency, or switch to PGDG repo and use our packages as a<br>
whole.<br>
<br>
...or you can edit /etc/yum.repos.d/pgdg-redhat-all.repo file, and add<br>
<br>
exclude=3Dlibpq5<br>
<br>
under the [pgdg-common] section so that dnf will ignore that.<br>
<br>
Regards,<br>
<br>
<br>
-- <br>
Devrim G=C3=BCnd=C3=BCz<br>
Open Source Solution Architect, PostgreSQL Major Contributor<br>
Twitter: @DevrimGunduz , @DevrimGunduzTR<br>
</blockquote></div><br clear=3D"all"><br><span class=3D"gmail_signature_pre=
fix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"l=
tr"><div>Kind Regards,</div><div>Paul Brindusa</div><div><a href=3D"mailto:=
paulbrindusa88@gmail.com" target=3D"_blank">paulbrindusa88@gmail.com</a></d=
iv></div></div></div>

--000000000000c419f50623f28c95--