public inbox for [email protected]  

help / color / mirror / Atom feed

From: Paul Brindusa <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: Devrim Gündüz <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: libpq5 error
Date: Tue, 8 Oct 2024 16:23:59 +0100
Message-ID: <CAFeSbqgmc4TGcRhGmd7YeVd7UdUOx2Hvotq7Z1zftFW8U-nLhg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAFeSbqi+oTocrvQT9fEwF3B4btcVQp7hW2LdY8iLLSn3SRj0vw@mail.gmail.com>
	<[email protected]>
	<CAFeSbqiVNCeadL=BezW+SyzpOxU9rpqkFJPMKhtBxOz0AWZWFg@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<CAFeSbqiw7wF5aK06dfraX6=uczWsCCcYHQPu0tJ4dL1zdL7PLA@mail.gmail.com>
	<[email protected]>

Hi guys,

I've just retried patching the host as we speak with no luck, I am getting
the exact same thing.
Following Devrim's guidance i've manually upgraded the repo file that came
down via dnf  and still getting the mismatch error:


Error: Transaction test error:
  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
  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

Any ideas?

On Tue, Oct 8, 2024 at 4:06 PM Adrian Klaver <[email protected]>
wrote:

> On 10/8/24 01:01, Paul Brindusa wrote:
> >   Good morning Devrim,
> >
> > Is libpq5 an important component that needs the upgrade?
>
>  From here:
>
> https://www.postgresql.org/docs/current/libpq.html
>
> "libpq is the C application programmer's interface to PostgreSQL. libpq
> is a set of library functions that allow client programs to pass queries
> to the PostgreSQL backend server and to receive the results of these
> queries.
>
> libpq is also the underlying engine for several other PostgreSQL
> application interfaces, including those written for C++, Perl, Python,
> Tcl and ECPG. So some aspects of libpq's behavior will be important to
> you if you use one of those packages. In particular, Section 32.15,
> Section 32.16 and Section 32.19 describe behavior that is visible to the
> user of any application that uses libpq."
>
> To me that is, yes it is important.
>
> > 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 AM Devrim Gündüz <[email protected]
> > <mailto:[email protected]>> 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=libpq5
> >
> >     under the [pgdg-common] section so that dnf will ignore that.
> >
> >     Regards,
> >
> >
> >     --
> >     Devrim Gündüz
> >     Open Source Solution Architect, PostgreSQL Major Contributor
> >     Twitter: @DevrimGunduz , @DevrimGunduzTR
> >
> >
> >
> > --
> > Kind Regards,
> > Paul Brindusa
> > [email protected] <mailto:[email protected]>
>
> --
> Adrian Klaver
> [email protected]
>
>

-- 
Kind Regards,
Paul Brindusa
[email protected]

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: libpq5 error
  In-Reply-To: <CAFeSbqgmc4TGcRhGmd7YeVd7UdUOx2Hvotq7Z1zftFW8U-nLhg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox