Thread: Postgres on 64bit Windows Server with WOW64

Does anyone have experience with running Postgres on Windows Server 2003 64bit using WOW64?

In theory it *should* work, but it is always nice to hear from someone that has already taken the plunge :-)

Thanks,
-Mont

Mont Rothstein wrote:
> Does anyone have experience with running Postgres on Windows Server 2003
> 64bit using WOW64?

There is a 64bit version of World of Warcraft?
>
> In theory it *should* work, but it is always nice to hear from someone that
> has already taken the plunge :-)
>
> Thanks,
> -Mont
>


--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

I wouldn't know that one way or the other :-)

I was referring to Windows on Windows 64.

Enables 32bit apps to run on 64bit Windows OSs, in case anyone wasn't familiar with it (I wasn't until today).

-Mont

Yes, the 32bit release should work on a 64bit Windows. Please let me know in case you find any compatibility problems which I dont think so will be any.
-
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)





-

Mont Rothstein wrote:
> I wouldn't know that one way or the other :-)
>
> I was referring to Windows on Windows
> 64<http://en.wikipedia.org/wiki/WoW64>
> .
>
> Enables 32bit apps to run on 64bit Windows OSs, in case anyone wasn't
> familiar with it (I wasn't until today).

In theory you should be able to compile PostgreSQL to 64bit windows. We
support 64bit everywhere else.

Does mingw support 64bit?

Joshua D. Drake


>
> -Mont
>
>
>
> On 7/31/06, Joshua D. Drake <jd@commandprompt.com> wrote:
>>
>> Mont Rothstein wrote:
>> > Does anyone have experience with running Postgres on Windows Server
>> 2003
>> > 64bit using WOW64?
>>
>> There is a 64bit version of World of Warcraft?
>> >
>> > In theory it *should* work, but it is always nice to hear from someone
>> that
>> > has already taken the plunge :-)
>> >
>> > Thanks,
>> > -Mont
>> >
>>
>>
>> --
>>
>>     === The PostgreSQL Company: Command Prompt, Inc. ===
>> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
>>     Providing the most comprehensive  PostgreSQL solutions since 1997
>>               http://www.commandprompt.com/
>>
>>
>>
>


--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Previous threads indicate that it isn't currently possible:

http://archives.postgresql.org/pgsql-general/2006-04/msg00628.php

http://archives.postgresql.org/pgsql-general/2006-04/msg01264.php

-Mont

Joshua D. Drake wrote:
> Mont Rothstein wrote:
>> I wouldn't know that one way or the other :-)
>>
>> I was referring to Windows on Windows
>> 64<http://en.wikipedia.org/wiki/WoW64>
>> .
>>
>> Enables 32bit apps to run on 64bit Windows OSs, in case anyone wasn't
>> familiar with it (I wasn't until today).
>
> In theory you should be able to compile PostgreSQL to 64bit windows. We
> support 64bit everywhere else.
>
> Does mingw support 64bit?

no it does not.
To get 64bit on windows we will need to get VC fully supported for now ...

Stefan

On 7/31/06, Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> wrote:
> Joshua D. Drake wrote:
> > Mont Rothstein wrote:
> >> I wouldn't know that one way or the other :-)
> >>
> >> I was referring to Windows on Windows
> >> 64<http://en.wikipedia.org/wiki/WoW64>
> >> .
> >>
> >> Enables 32bit apps to run on 64bit Windows OSs, in case anyone wasn't
> >> familiar with it (I wasn't until today).
> >
> > In theory you should be able to compile PostgreSQL to 64bit windows. We
> > support 64bit everywhere else.
> >
> > Does mingw support 64bit?
>
> no it does not.
> To get 64bit on windows we will need to get VC fully supported for now ...

magnus managed to compile pg on msvc.  that would be fast path to 64
bit pg on win 64.

with a little elbow grease, it might be possible to compile 64 bit on
SUA.  depending on how you look at it this is not quite native app.

mingw64 does not look like it is coming anytime soon...

merlin

Hello Mont, hello List,

I am the person who wrote these threads and since, I haven't found the
solution to compile PostgreSQL on Windows 64 bits...Instead, I used a 32
bit release of PostgreSQL on Windows 64 bits.
I worked with "Microsoft Windows Server 2003, Enterprise Edition with
SP1 for Itanium-based Systems". I managed to have an environment of
compilation on Windows 64 bits via a trial release of MKS Toolkit (as
mingw does not support 64 bits). It was the only tool which brought the
shell script (sh.exe) used to launch the ./configure command.

But when I executed the ./configure command, I had errors as the
configuration of my server was not recognized.
My problems were in the "config.guess" file. In this file, the case
"ia64" is only present for Linux, AIX and HP-UX, not for Windows 64 bits.
I tried to make changes but I didn't not manage to compile PostgreSQL...

If someone manages to compile PostgreSQL without using Microsoft Visual
C, I shall be interested to know how he made ! :-)

Regards,
Alexandra DANTE


Mont Rothstein wrote:

> Previous threads indicate that it isn't currently possible:
>
> http://archives.postgresql.org/pgsql-general/2006-04/msg00628.php
>
> http://archives.postgresql.org/pgsql-general/2006-04/msg01264.php
>
> -Mont
>
>
> On 7/31/06, *Joshua D. Drake* < jd@commandprompt.com
> <mailto:jd@commandprompt.com>> wrote:
>
>     Mont Rothstein wrote:
>     > I wouldn't know that one way or the other :-)
>     >
>     > I was referring to Windows on Windows
>     > 64<http://en.wikipedia.org/wiki/WoW64>
>     > .
>     >
>     > Enables 32bit apps to run on 64bit Windows OSs, in case anyone
>     wasn't
>     > familiar with it (I wasn't until today).
>
>     In theory you should be able to compile PostgreSQL to 64bit
>     windows. We
>     support 64bit everywhere else.
>
>     Does mingw support 64bit?
>
>     Joshua D. Drake
>
>
>     >
>     > -Mont
>     >
>     >
>     >
>     > On 7/31/06, Joshua D. Drake <jd@commandprompt.com
>     <mailto:jd@commandprompt.com>> wrote:
>     >>
>     >> Mont Rothstein wrote:
>     >> > Does anyone have experience with running Postgres on Windows
>     Server
>     >> 2003
>     >> > 64bit using WOW64?
>     >>
>     >> There is a 64bit version of World of Warcraft?
>     >> >
>     >> > In theory it *should* work, but it is always nice to hear
>     from someone
>     >> that
>     >> > has already taken the plunge :-)
>     >> >
>     >> > Thanks,
>     >> > -Mont
>     >> >
>     >>
>     >>
>     >> --
>     >>
>     >>     === The PostgreSQL Company: Command Prompt, Inc. ===
>     >> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
>     >>     Providing the most comprehensive  PostgreSQL solutions
>     since 1997
>     >>               http://www.commandprompt.com/
>     >>
>     >>
>     >>
>     >
>
>
>     --
>
>         === The PostgreSQL Company: Command Prompt, Inc. ===
>     Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
>         Providing the most comprehensive  PostgreSQL solutions since 1997
>                   http://www.commandprompt.com/
>
>
>

Thanks for the info.  Good to hear from someone that has actually used WOW64 successfully.

Thanks,
-Mont