Postgres 32bit on Windows 64bit, related components

We're about to purchase a new server for our Postgres 8.4 database.
We’d like to go with Windows 64bit for possible future developments,
but are happy to stick with 32bit Postgres + Npgsql, ODBC, OpenSSL,
slony2 and libxml2, libpq.

Any specific reasons for choosing Windows? Once in a while, I see someone
posting issues about PostgreSQL on windows and replies which go 'Windows?
hmmm...not sure about that ..". Of course, those were not questions about
queries/query tuning etc. Those get answered. These questions mostly deal
with crashes/recovery/security related and so on.

DISCLAIMER:

"The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all copies of the original communication.
IBS makes no warranty, express or implied, nor guarantees the accuracy,
adequacy or completeness of the information contained in this email or any
attachment and is not liable for any errors, defects, omissions, viruses
or for resultant loss or damage, if any, direct or indirect."

Hi Jayadevan,

We're adding to our server farm, which is Windows. We use Windows as our application is .NET based, and related components in our systems require Windows. Switching to *nix is not an option.

I'm just after some assurance that all the extra 32bit components in Postgres will run OK under 64bit Windows. I mean allegedly *anything* 32bit is supposed to run under 64bit, but it's not always this simple in practice.

-Brendan

-----Original Message-----
From: Jayadevan M [mailto:Jayadevan.Maymala@ibsplc.com]
Sent: Wednesday, 8 September 2010 4:42 PM
To: Brendan Hill
Cc: pgsql-general@postgresql.org; pgsql-general-owner@postgresql.org
Subject: Re: [GENERAL] Postgres 32bit on Windows 64bit, related components

We're about to purchase a new server for our Postgres 8.4 database.
We’d like to go with Windows 64bit for possible future developments,
but are happy to stick with 32bit Postgres + Npgsql, ODBC, OpenSSL,
slony2 and libxml2, libpq.

Any specific reasons for choosing Windows? Once in a while, I see someone
posting issues about PostgreSQL on windows and replies which go 'Windows?
hmmm...not sure about that ..". Of course, those were not questions about
queries/query tuning etc. Those get answered. These questions mostly deal
with crashes/recovery/security related and so on.

On Wed, Sep 8, 2010 at 03:31, Brendan Hill <brendanh@jims.net> wrote:

We're about to purchase a new server for our Postgres 8.4 database. We’d
like to go with Windows 64bit for possible future developments, but are
happy to stick with 32bit Postgres + Npgsql, ODBC, OpenSSL, slony2 and
libxml2, libpq.

I understand that Postgres 32bit runs fine in Windows 64bit, but I’m
concerned about whether all of the extra components will. I don’t want to
run into any compatibility issues, and I certainly don’t want to have to
recompile any components manually. Happy to run all components in 32 bit.

In general, as long as you run *all* components in 32-bit mode, things
will be fine. It's only when you start mixing 32 and 64-bit that
things can go bad. You can have 64-bit client/32-bit server or the
other way around, but mixing 32 and 64 bit components *within* the
server or *within* the client will make things a lot harder.

Also note that PostgreSQL 9.0 will be available natively 64-bit on Windows.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

On Wed, Sep 8, 2010 at 9:29 AM, Magnus Hagander <magnus@hagander.net> wrote:

On Wed, Sep 8, 2010 at 03:31, Brendan Hill <brendanh@jims.net> wrote:

We're about to purchase a new server for our Postgres 8.4 database. We’d
like to go with Windows 64bit for possible future developments, but are
happy to stick with 32bit Postgres + Npgsql, ODBC, OpenSSL, slony2 and
libxml2, libpq.

Also note that PostgreSQL 9.0 will be available natively 64-bit on Windows.

Yeah, but Slony/PostGIS won't.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company

On Wed, 8 Sep 2010 11:31:47 +1000, Brendan Hill
<brendanh@jims.net> wrote:

We're about to purchase a new server for our Postgres 8.4 database.
We'd like to go with Windows 64bit for possible future developments,
but are happy to stick with 32bit Postgres + Npgsql, ODBC, OpenSSL,
slony2 and libxml2, libpq.

[...]

Can anyone confirm whether an 32bit installation of all these
components will work together successfully in a 64bit Windows environment?

Npgsql before 2.09 had a Problem when using SSPI-authentication on
Windows 64 but you should't have any problem with recent versions.

http://lists.pgfoundry.org/pipermail/npgsql-devel/2010-January/001062.html

Regards

Brar Piening