Linux package upgrade without dependency conflicts

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Linux package upgrade without dependency conflicts

Zwettler Markus (OIZ)

We run Postgres 9.6 + 12 Community Edition on RHEL7 which we install directly out of the PGDG channels using RPMs. We also run Patroni installed with RPMs provided by Github.

 

Currently we have major dependency conflicts with each quarterly Linux package upgrade (yum upgrade), especially on PostGIS and Patroni.

 

I was told that there will be no dependency conflicts anymore when we install Postgres from sourcecode and Patroni with pip.

 

Is that correct? Because all Linux packages required by Postgres will continue to be updated.

 

-Markus

Reply | Threaded
Open this post in threaded view
|

AW: Linux package upgrade without dependency conflicts

Zwettler Markus (OIZ)

Any hints on this one?

 

Thanks, Markus

 

 

 

Von: Zwettler Markus (OIZ) <[hidden email]>
Gesendet: Donnerstag, 19. November 2020 14:50
An: [hidden email]
Betreff: Linux package upgrade without dependency conflicts

 

We run Postgres 9.6 + 12 Community Edition on RHEL7 which we install directly out of the PGDG channels using RPMs. We also run Patroni installed with RPMs provided by Github.

 

Currently we have major dependency conflicts with each quarterly Linux package upgrade (yum upgrade), especially on PostGIS and Patroni.

 

I was told that there will be no dependency conflicts anymore when we install Postgres from sourcecode and Patroni with pip.

 

Is that correct? Because all Linux packages required by Postgres will continue to be updated.

 

-Markus

Reply | Threaded
Open this post in threaded view
|

Re: AW: Linux package upgrade without dependency conflicts

Adrian Klaver-4
On 11/20/20 1:38 AM, Zwettler Markus (OIZ) wrote:
> Any hints on this one?

Are you sure the Postgres packages are coming from the PGDG repos and
not the RH repos?

What are the dependency conflicts?


>
> Thanks, Markus
>
> *Von:*Zwettler Markus (OIZ) <[hidden email]>
> *Gesendet:* Donnerstag, 19. November 2020 14:50
> *An:* [hidden email]
> *Betreff:* Linux package upgrade without dependency conflicts
>
> We run Postgres 9.6 + 12 Community Edition on RHEL7 which we install
> directly out of the PGDG channels using RPMs. We also run Patroni
> installed with RPMs provided by Github.
>
> Currently we have major dependency conflicts with each quarterly Linux
> package upgrade (yum upgrade), especially on PostGIS and Patroni.
>
> I was told that there will be no dependency conflicts anymore when we
> install Postgres from sourcecode and Patroni with pip.
>
> Is that correct? Because all Linux packages required by Postgres will
> continue to be updated.
>
> -Markus
>


--
Adrian Klaver
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: Linux package upgrade without dependency conflicts

Magnus Hagander-2
In reply to this post by Zwettler Markus (OIZ)
On Thu, Nov 19, 2020 at 2:50 PM Zwettler Markus (OIZ)
<[hidden email]> wrote:

>
> We run Postgres 9.6 + 12 Community Edition on RHEL7 which we install directly out of the PGDG channels using RPMs. We also run Patroni installed with RPMs provided by Github.
>
>
>
> Currently we have major dependency conflicts with each quarterly Linux package upgrade (yum upgrade), especially on PostGIS and Patroni.
>
>
>
> I was told that there will be no dependency conflicts anymore when we install Postgres from sourcecode and Patroni with pip.
>
>
>
> Is that correct? Because all Linux packages required by Postgres will continue to be updated.

This is not really a PostgreSQL question, it's more of a RedHat
question I'd say.

In general, no. If you install from source you will have a different
kind of dependency management, and you need to handle all of that
manually. As long as you do, there shouldn't be issues.

That said, what are your dependency conflicts? As long as you're using
the PGDG repositories on RHEL7 it should work without that. There have
been some issues with PostGIS on RHEL8, but I think they are mostly
fine on RHEL7. But if you don't actually show us what your dependency
problems are, we can't tell you how to fix it...

(And why not use Patroni from the PDGD repositories?)


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


Reply | Threaded
Open this post in threaded view
|

AW: AW: Linux package upgrade without dependency conflicts

Zwettler Markus (OIZ)
In reply to this post by Adrian Klaver-4
Yes. Pretty sure. PGDG repos.

The last problems I remember had been related to Patroni + python-psycopg and PostGIS + pgrouting_96.

Regards, Markus



> -----Urspr√ľngliche Nachricht-----
> Von: Adrian Klaver <[hidden email]>
> Gesendet: Freitag, 20. November 2020 16:26
> An: Zwettler Markus (OIZ) <[hidden email]>; pgsql-
> [hidden email]
> Betreff: Re: AW: Linux package upgrade without dependency conflicts
>
> On 11/20/20 1:38 AM, Zwettler Markus (OIZ) wrote:
> > Any hints on this one?
>
> Are you sure the Postgres packages are coming from the PGDG repos and not the
> RH repos?
>
> What are the dependency conflicts?
>
>
> >
> > Thanks, Markus
> >
> > *Von:*Zwettler Markus (OIZ) <[hidden email]>
> > *Gesendet:* Donnerstag, 19. November 2020 14:50
> > *An:* [hidden email]
> > *Betreff:* Linux package upgrade without dependency conflicts
> >
> > We run Postgres 9.6 + 12 Community Edition on RHEL7 which we install
> > directly out of the PGDG channels using RPMs. We also run Patroni
> > installed with RPMs provided by Github.
> >
> > Currently we have major dependency conflicts with each quarterly Linux
> > package upgrade (yum upgrade), especially on PostGIS and Patroni.
> >
> > I was told that there will be no dependency conflicts anymore when we
> > install Postgres from sourcecode and Patroni with pip.
> >
> > Is that correct? Because all Linux packages required by Postgres will
> > continue to be updated.
> >
> > -Markus
> >
>
>
> --
> Adrian Klaver
> [hidden email]


Reply | Threaded
Open this post in threaded view
|

AW: Linux package upgrade without dependency conflicts

Zwettler Markus (OIZ)
In reply to this post by Magnus Hagander-2
> -----Urspr√ľngliche Nachricht-----
> Von: Magnus Hagander <[hidden email]>
> Gesendet: Freitag, 20. November 2020 16:29
> An: Zwettler Markus (OIZ) <[hidden email]>
> Cc: [hidden email]
> Betreff: Re: Linux package upgrade without dependency conflicts
>
> On Thu, Nov 19, 2020 at 2:50 PM Zwettler Markus (OIZ)
> <[hidden email]> wrote:
> >
> > We run Postgres 9.6 + 12 Community Edition on RHEL7 which we install directly
> out of the PGDG channels using RPMs. We also run Patroni installed with RPMs
> provided by Github.
> >
> >
> >
> > Currently we have major dependency conflicts with each quarterly Linux package
> upgrade (yum upgrade), especially on PostGIS and Patroni.
> >
> >
> >
> > I was told that there will be no dependency conflicts anymore when we install
> Postgres from sourcecode and Patroni with pip.
> >
> >
> >
> > Is that correct? Because all Linux packages required by Postgres will continue to
> be updated.
>
> This is not really a PostgreSQL question, it's more of a RedHat question I'd say.
>
> In general, no. If you install from source you will have a different kind of
> dependency management, and you need to handle all of that manually. As long as
> you do, there shouldn't be issues.
>
> That said, what are your dependency conflicts? As long as you're using the PGDG
> repositories on RHEL7 it should work without that. There have been some issues
> with PostGIS on RHEL8, but I think they are mostly fine on RHEL7. But if you don't
> actually show us what your dependency problems are, we can't tell you how to fix
> it...
>
> (And why not use Patroni from the PDGD repositories?)
>
>
> --
>  Magnus Hagander
>  Me: https://www.hagander.net/
>  Work: https://www.redpill-linpro.com/


The last problems I remember had been related to Patroni + python-psycopg and PostGIS + pgrouting_96.

We used Patroni before it had been provided by the PGDG repositories. I am actually planning to use the RPMs from the PGDG repo in the future.

I will post our actual problems the next time.

Thanks, Markus