RE: Regarding availability of 32bit client drivers for postgresql 13/14

Thank you Adrian for the response,

We are looking for 32bit client drivers for RHEL 8.5.
An another question .. How does the enterprise customers using PostgreSQL can subscribe to official support ?

Thanks & Regards,
Aravind Phaneendra
CICS TX and TXSeries Development & L3 Support
India Systems Development Labs
IBM Systems

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Date: Wednesday, 17 August 2022 at 9:57 AM
To: Aravind Phaneendra <aphaneen(at)in(dot)ibm(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: [EXTERNAL] Re: Regarding availability of 32bit client drivers for postgresql 13/14
On 8/16/22 20:46, Aravind Phaneendra wrote:
> Hi,
>
> My name is Aravind and I am part of IBM CICS TX product development and
> support. We have a requirement from one of our customers to use IBM CICS
> TX with PostgreSQL 13/14. IBM CICS TX is a Transaction Manager
> middleware product that is deployed as container on Kubernetes
> platforms. IBM CICS TX can interact with database products such as DB2,
> Oracle, MSSQL, PostgreSQL through XA/Open standards.
>
> CICS TX is a 32bit C runtime product and uses the databases’ 32bit
> client libraries to perform embedded SQL operations. The customer
> applications are Embedded SQL C or COBOL programs deployed on CICS TX
> and CICS TX runtime executes them as transactions ensuring the data
> integrity.
>
> We observed there are no 32bit client binaries/libraries available with
> PostgreSQL 13/14 and CICS TX require them to interact with the
> PostgreSQL server. Currently we have tested with PostgreSQL 10.12.1 and
> our customer wants to upgrade to PostgreSQL 13 or 14.
>
> Based on the above requirements and details, we have few questions which
> require your support.
>
> 1. Can we get 32bit client binaries/libraries for PostgreSQL 14 ?

The ODBC driver does it:

https://odbc.postgresql.org/docs/win32-compilation.html

Also the Build farm:

https://buildfarm.postgresql.org/cgi-bin/show_status.pl

has 32bit/i686 members that show green.

> 2. We also found that the libraries can be built by using the
> PostgreSQL 14 source. Is it possible to build the 32bit client
> binaries/libraries from the source available ?

Try it and see.

> 3. Is there an official support for 32bit client libraries/binaries
> built out of source for customers ?
> 4. Can the PostgreSQL 10.12.1 client work with PostgreSQL 14 server ?
> Do you still support PostgreSQL 10.12.1 client ?
>
> Thanks & Regards,
>
> Aravind Phaneendra
>
> CICS TX and TXSeries Development & L3 Support
>
> India Systems Development Labs
>
> IBM Systems
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com