Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B93169FB6D6 for ; Mon, 12 Feb 2007 14:45:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 22939-02-2 for ; Mon, 12 Feb 2007 14:45:52 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id D97639FB6CA for ; Mon, 12 Feb 2007 14:45:38 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id l1CIjcN5094091 for ; Mon, 12 Feb 2007 14:45:38 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id l1CIL0qG084718 for pgsql-admin@postgresql.org; Mon, 12 Feb 2007 14:21:00 -0400 (AST) (envelope-from news) From: teknokrat X-Newsgroups: pgsql.admin Subject: Re: pg on windows server 2003 64 bit edition Date: Mon, 12 Feb 2007 18:20:54 +0000 Organization: Hub.Org Networking Services Lines: 55 Message-ID: References: <075201c74ebe$4c64dda0$6701a8c0@RnDworkstation> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) In-Reply-To: <075201c74ebe$4c64dda0$6701a8c0@RnDworkstation> To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/162 X-Sequence-Number: 24627 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" > To: > 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.