If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > PostgreSQL > 64bit windows, related components

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: May 2009
Posts: 18
64bit windows, related components

We're about to purchase a new server for our Postgres 8.4 database. Research suggests that 64bit offers little benefit to Postgres, but we'd like to go 64bit to take advantage of possible future developments.

I understand that Postgres "runs just fine" within Windows 64bit, but research hinted that related components may have trouble:


PostgreSQL vs 64-bit windows - Magnus Hagander's PostgreSQL blog

"How about the ODBC drivers for postgresql on a windows 64 bit?"

"Need 64 bit client libraries here too! Maybe there is a 'simple' way to make the 64bit client library?"


And points in this wiki page:

64bit Windows port - PostgreSQL Wiki

"64 bit applications may require a 64 bit libpq.dll."

"We'll need 64 bit builds of these support libraries - OpenSSL, libxml2"


I'm happy to run Postgres and all related components on 32bit versions. We run NpgSQL, and rely on OpenSSL.

Could someone confirm that a vanilla installation of 32bit Postgres + related components will work fine in Windows 64bit environment? We do NOT want to have to start performing our own recompilations of any components.

Thanks in advance,
-Brendan
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Aug 2009
Location: Olympia, WA
Posts: 337
Yeah, you'd definitely be better off using 64-bit *nix.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: May 2009
Posts: 18
Quote:
Originally Posted by artacus72 View Post
Yeah, you'd definitely be better off using 64-bit *nix.
We run a Windows farm.

Can anyone confirm whether Postgres + add on components like NpgSql & OpenSSL 32bit versions run fine in 64bit?
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Aug 2009
Location: Olympia, WA
Posts: 337
Quote:
Originally Posted by brendan.hill View Post
We run a Windows farm.

Can anyone confirm whether Postgres + add on components like NpgSql & OpenSSL 32bit versions run fine in 64bit?
Last I heard there were still some issues with some libraries like libxml2. But I don't use Windows so I don't really pay much attention. You'd be better off asking on the Pg general mailing list... unless someone else here is running it on 64-bit Windows.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: May 2009
Posts: 18
OK, thanks.
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Sep 2010
Posts: 2
I run both 64 bit and 32 bit PostgreSQL 9.0 RC1 beta on 64 Bit Vista and 64 bit Windows 7 for development. There are 64 bit libraries like libxml 2 and dependents that need porting to 64 bit Windows.

In general I can run both versions of PostgreSQL concurrently, on different ports, on the same 64 bit box and connect from pgadmin III.

The 64 bit Windows O/S has a stricter security model so I generally write code in 32 bit and test there before deploying to 64 bit for testing.

The Windows 64 Bit O/S runs 32 bit apps run under WOW64 emulation with thunking for system calls. If you are planning to run 32 bit production apps on a 64 bit box check out the MSDN site for the performance and memory limitations of WOW64.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On