pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: teknokrat <teknokrat@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: pg on windows server 2003 64 bit edition
Date: Mon, 12 Feb 2007 18:20:54 +0000
Message-ID: <eqqb6b$2i3j$1@news.hub.org> (raw)
In-Reply-To: <075201c74ebe$4c64dda0$6701a8c0@RnDworkstation>
References: <eqps5o$v4u$1@news.hub.org>
	<075201c74ebe$4c64dda0$6701a8c0@RnDworkstation>

Ted Byers wrote:
> I do not know about Windows server 2003, because I don't have it, but I 
> DO have the 64 bit version of Windows XP pro (and it seems to be much 
> more responsive that its 32 bit counterpart on the AMD Turion64 in my 
> system), and Postgresql works fine on it.  As for the amount of memory, 
> I have only 2GB RAM, but that still works fine for me.  Being 32 bit, 
> postgesql will almost certainly not take direct advantage of more than 4 
> GB of data, but if at least part of it works by spawning new threads or 
> processes, use of more than 4 GB would be more a question of how the OS 
> handles it, would it not? But if you don't need it to access more than 4 
> GB of memory, you should have no problems running it.
> 
> Unless Windows Server 2003 is radically different from XP, you should be 
> fine based on what I have seen, at least if you use a binary 
> distribution. I haven't tried compiling Postgresql myself, and I have 
> not been able to get cygwin to install on 64 bit Windows. I would have 
> thought cygwin programs would run like any other 32 bit app, but they 
> don't.  One of the things I look at is how 64 bit versions of an 
> application behave relative to their 32 bit counterparts.  I can do this 
> with Perl (the 64 bit version from Activestate doesn't have any CPAN 
> packages or even provide a way to find them, the CPAN executable runs 
> but doesn't know about any archives, and when I tried pointing at 32 bit 
> archives, the installation always failed), PHP, MS Visual studio and MS 
> SQL Server, and MySQL.  The bottom line is that the 32 bit Windows 
> binary for Postgresql seems to work like any other 32 bit Windows 
> application.  But if you want it to directly use more than 4 GB memory, 
> you probably need to build a 64 bit version yourself, with all the 
> headaches that entails.
> 
> HTH
> 
> Ted
> 
> ----- Original Message ----- From: "teknokrat" <teknokrat@yahoo.com>
> To: <pgsql-admin@postgresql.org>
> Sent: Monday, February 12, 2007 9:04 AM
> Subject: [ADMIN] pg on windows server 2003 64 bit edition
> 
> 
>> Can anyone tell me if the win32 version of postgresql will install and 
>> run on the 64 bit windows 2003 server? Will it work ok with ram > 4GB?
>>
>> thanks
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: explain analyze is your friend
>>
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 

ok, thanks.



view thread (3+ messages)

Message-ID: <eqqb6b$2i3j$1@news.hub.org>
Permalink:  ../eqqb6b$2i3j$1@news.hub.org/
Also on:    postgresql.org/message-id/eqqb6b$2i3j$1@news.hub.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: teknokrat@yahoo.com
  Subject: Re: pg on windows server 2003 64 bit edition
  In-Reply-To: <eqqb6b$2i3j$1@news.hub.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox