On Mon, 17 Jun 2024 at 19:16, Matteo Beccati <p...@beccati.com> wrote: > > Hi, > > Il 17/06/2024 19:03, Peter Kokot ha scritto: > > On Mon, 17 Jun 2024 at 18:58, Pierre <pierre-...@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.
