Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:123656
Precedence: bulk
MIME-Version: 1.0
References: <CAAfnsFW8365PyxvQPSLBugTAZgM=uqe6fk+3p5088VNtX5zatg@mail.gmail.com>
 <201e1928-7a46-4586-9d24-b535c0a8cdfb@processus.org> <CAAfnsFVFMmKm8knR714xtbY2iNCndx5qqPv=bjqyVTpZLzNZFQ@mail.gmail.com>
 <5cc18d25-4c5a-44da-b778-c7e89792a93a@beccati.com>
In-Reply-To: <5cc18d25-4c5a-44da-b778-c7e89792a93a@beccati.com>
Date: Mon, 17 Jun 2024 19:21:56 +0200
Message-ID: <CAAfnsFU==v2f2-ZLgisg2h-KfmctH_yLZNX6mSPr9JFiBw4g2A@mail.gmail.com>
Subject: Re: [PHP-DEV] Bumping minimum PostgreSQL version to 10.0
To: Matteo Beccati <php@beccati.com>
Cc: Peter Kokot <petk@php.net>, Pierre <pierre-php@processus.org>, 
	Internals <internals@lists.php.net>
Content-Type: text/plain; charset="UTF-8"
From: petk@php.net (Peter Kokot)

On Mon, 17 Jun 2024 at 19:16, Matteo Beccati <php@beccati.com> wrote:
>
> Hi,
>
> Il 17/06/2024 19:03, Peter Kokot ha scritto:
> > On Mon, 17 Jun 2024 at 18:58, Pierre <pierre-php@processus.org> wrote:
> >>
> >> Would id affect the possibility to use an old PostgreSQL (eg. 9.6) via
> >> PHP (PDO or ext-pgsql) ?
> >>
> >> If so, it might be a dangerous move for oldest projects, you sometime
> >> can upgrade PHP and your software easily, but can't upgrade the database
> >> server.
> >>
> >> Regards,
> >>
> >> Pierre
> >
> > Yes, after such version increase it would affect PDO PGSQL extension
> > also and you'd need to upgrade the database. In the PR there is also
> > 9.6 mentioned as one version earlier as an alternative. I'm fine with
> > 9.6 also but PHP-8.4-dev code will need to be adjusted further.
>
> Please correct me if I'm wrong, but the basic capability of connecting
> to an older version shouldn't be compromised. It's only the build
> process requiring libpq > 10.
>
>
> Cheers
> --
> Matteo Beccati
>
> Development & Consulting - http://www.beccati.com/

When building for a certain PostgreSQL version, the pq library gets
linked to the extension and then this PostgreSQL version needs to be
used, yes. If you build for 10.0, then you need to use that exact
version. Linux packages have this resolved by dependencies on the
packages so when you install the extension it will work for that
distribution PostgreSQL package.