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