Thread: 32-bit libpq with 64-bit server
Hello all,
On Windows, I have a 32-bit client application that uses the 32-bit libpq.dll. In testing the client application with a Postgres 9.2 64-bit server I’ve noticed no problems, and was wondering if anyone knows of any caveats in this – AFAICS the tcp communication is between the 32-bit libpq and the 64-bit backend is compatible.
- Mark Watson
On Wed, Jun 20, 2012 at 10:07 AM, Marc Watson <mark.watson@jurisconcept.ca> wrote: > Hello all, > > On Windows, I have a 32-bit client application that uses the 32-bit > libpq.dll. In testing the client application with a Postgres 9.2 64-bit > server I’ve noticed no problems, and was wondering if anyone knows of any > caveats in this – AFAICS the tcp communication is between the 32-bit libpq > and the 64-bit backend is compatible. It should pretty much work. The main thing to watch out for is that very large results sets will hit the upper limit on memory allocations. merlin
Hello all,
On Windows, I have a 32-bit client application that uses the 32-bit libpq.dll. In testing the client application with a Postgres 9.2 64-bit server I’ve noticed no problems, and was wondering if anyone knows of any caveats in this – AFAICS the tcp communication is between the 32-bit libpq and the 64-bit backend is compatible.
Unless you go to considerable efforts to ensure otherwise, the protocol is text-based and isn't affected by endianness or word size. I'm not sure about the binary protocol, but it's rarely used.
--
Craig Ringer
-----Message d'origine-----
De : Merlin Moncure [mailto:mmoncure@gmail.com]
Envoyé : June-20-12 11:36 AM
It should pretty much work. The main thing to watch out for is that very large results sets will hit the upper limit on memory allocations.
merlin
De : Craig Ringer [mailto:ringerc@ringerc.id.au]
Envoyé : June-20-12 10:47 PM
On 06/20/2012 11:07 PM, Marc Watson wrote:
Hello all,
On Windows, I have a 32-bit client application that uses the 32-bit libpq.dll. In testing the client application with a Postgres 9.2 64-bit server I’ve noticed no problems, and was wondering if anyone knows of any caveats in this – AFAICS the tcp communication is between the 32-bit libpq and the 64-bit backend is compatible.
Unless you go to considerable efforts to ensure otherwise, the protocol is text-based and isn't affected by endianness or word size. I'm not sure about the binary protocol, but it's rarely used.
--
Craig Ringer
Thanks Craig and Merlin. I’ll continue with my testing of 9.2-64 bit.
Mark Watson