MIME-Version: 1.0
References: 
 <CAHcM7L13D4MAByVkMz35BKtfDQB2rTXP88hrFj5TLHfSm16F3w@mail.gmail.com>
 <YCmN13P0W7PBFaVv@msg.df7cb.de>
In-Reply-To: <YCmN13P0W7PBFaVv@msg.df7cb.de>
From: Saif Hakim <saif@benchling.com>
Date: Sun, 14 Feb 2021 14:58:46 -0800
Message-ID: 
 <CAHcM7L04BVsj4z0KatkCzwJWyvy_1jinz0VazDy5n7jMv7tumA@mail.gmail.com>
Subject: Re: libpq 11.10 / 11.11 are not propertly released for bionic
To: Christoph Berg <myon@debian.org>, Saif Hakim <saif@benchling.com>,
 pgsql-pkg-debian@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000070012e05bb53d013"
Precedence: bulk

--00000000000070012e05bb53d013
Content-Type: text/plain; charset="UTF-8"

Hi Christoph,

> that is indeed stale, thanks for spotting that. The problem is present
> in the other distributions as well. I have now manually updated
> bionic-pgdg, but I will leave the other untouched until I can figure

Thanks!, I've confirmed that my repro no longer works and version 11 is
installed.

> That said, you shouldn't worry about libpq5 11 - using the 13 version
> from the "main" repository component is the recommended way.

For my own understanding, what are the ramifications of using the
non-"main" repository component / what are the differences?

I was also under the impression that since the version number tracks the
postgres release it is compatible with, that I should be choosing the
version that matches the version of postgres I'm running, i.e. since I'm
running Postgres 11, I should be using libpq5-11.xx. I'm primarily
installing libpq for python; however, taking a closer look at psycopg2 docs
(https://www.psycopg.org/docs/install.html#runtime-requirements), I see
that they are in agreement with what you're saying:

> Note: Whatever version of libpq psycopg2 is compiled with, it will
> be possible to connect to PostgreSQL servers of any supported
> version: just install the most recent libpq version or the most
> practical, without trying to match it to the version of the
> PostgreSQL server you will have to connect to.

Out of curiosity, if we were running libpq5-11 with Postgres 13, would we
see any issues or does postgres maintain backwards compatibility with these
libs as well?

Thanks again!

Best,
Saif

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

<div dir=3D"ltr"><div dir=3D"ltr">Hi Christoph,<div><br><div><div>&gt; that=
 is indeed stale, thanks for spotting that. The problem is present<br>&gt; =
in the other distributions as well. I have now manually updated<br>&gt; bio=
nic-pgdg, but I will leave the other untouched until I can figure<br></div>=
<div><br></div><div>Thanks!, I&#39;ve confirmed that my repro no longer wor=
ks and version 11 is installed.</div><div><div><br></div><div>&gt; That sai=
d, you shouldn&#39;t worry about libpq5 11 - using the 13 version</div>&gt;=
 from the &quot;main&quot; repository component is the recommended way.=C2=
=A0</div><div><br></div><div>For my own understanding, what are the ramific=
ations of using=C2=A0the non-&quot;main&quot; repository component / what a=
re the differences?</div><div><br></div><div>I was also under the impressio=
n that since the version number tracks the postgres release it is compatibl=
e with, that I should be choosing the version that matches the version of p=
ostgres I&#39;m running, i.e. since I&#39;m running Postgres 11, I should b=
e using libpq5-11.xx. I&#39;m primarily installing libpq for python; howeve=
r, taking a closer look at psycopg2 docs (<a href=3D"https://www.psycopg.or=
g/docs/install.html#runtime-requirements">https://www.psycopg.org/docs/inst=
all.html#runtime-requirements</a>), I see that they are in agreement with=
=C2=A0what you&#39;re saying:</div><div><br></div><div>&gt; Note: Whatever =
version of libpq psycopg2 is compiled with, it will<br>&gt; be possible to =
connect to PostgreSQL servers of any supported<br>&gt; version: just instal=
l the most recent libpq version or the most<br>&gt; practical, without tryi=
ng to match it to the version of the<br>&gt; PostgreSQL server you will hav=
e to connect to.<br></div><div><br>Out of curiosity, if we were running lib=
pq5-11 with Postgres 13, would we see any issues or does postgres maintain =
backwards compatibility with these libs as well?</div></div></div><div><br>=
</div><div>Thanks again!</div><div><br></div><div>Best,</div><div>Saif</div=
></div>
</div>

--00000000000070012e05bb53d013--