Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
Aravind Phaneendra
Date:

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 ?
  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 ?
  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

 

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

From
Bruce Momjian
Date:
On Wed, Aug 17, 2022 at 03:43:55AM +0000, Aravind Phaneendra wrote:
> 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 ?
>  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 ?
>  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 ?

The community produces the source code, and third parties like Debian,
Red Hat, EDB, and our own packagers build the binaries you are asking
about.  I think you need to contact wherever you are getting your
binaries and ask them about 32-bit support.  You can certainly build
32-bit binaries yourself if you wish.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson