Re: Regarding installation of FDW on Windows

Atri Sharma wrote:
> On Fri, Jul 13, 2012 at 2:11 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>> On Fri, Jul 13, 2012 at 9:31 AM, Atri Sharma <atri(dot)jiit(at)gmail(dot)com>
wrote:
>>> I am trying to install my FDW project on windows.I did some research
>>> and I believe I shall be requiring pre compiled binaries(dll
files).I
>>> tried cross compiling using MinGW on my Ubuntu.I am using PGXS for
>>> compiling and making my project.I tried overriding CC and setting it
>>> to the MinGW C compiler,but I am getting header file not found
errors.
>>>
>>> How can I compile binaries for windows with PGXS?

>> Are you trying to build them to use with the EDB distribution, or
your
>> own builds? If the former, then you'll likely need to build with VC++
>> which means you cannot use PGXS. If it's your own build, then as long
>> as you used Mingw/Msys in the first place, you should be able to use
>> PGXS as you would on Linux.

> I am sorry,I am not too sure about EDB.Cannot I cross compile even for
> EnterpriseDB version?
>
> I am not too good with windows.I downloaded PostgreSQL 9.1 for windows
> from PostgreSQL website.
>
> What should I be doing?

I have never tried cross compiling PostgreSQL for Windows, and I
don't know if it works. If you have a Windows machine, do it there,
if not, forget it since you cannot even test your binaries :^)

You can either use PGXS with MinGW, which should work just like
building on UNIX, or use Microsoft Visual C++ / Windows SDK.

If you use EnterpriseDB's binary downloads, which are built
with MSVC, you'll have to compile your extension "by hand".

I have read a report that extensions built with MinGW are
compatible with EDB's binaries if you use --disable-float8-byval
(http://www.postgresonline.com/journal/archives/246-ODBC-Foreign-Data-wr
apper-odbc_fdw-on-windows.html).

Yours,
Laurenz Albe