Re: Regarding installation of FDW on Windows

On Fri, Jul 13, 2012 at 5:37 PM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
> 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

Laurenz,

How do I use PGXS with MinGW)?

Atri

--
Regards,

Atri
l'apprenant