Re: pg on windows server 2003 64 bit edition

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.