Atri Sharma wrote: > On Fri, Jul 13, 2012 at 2:11 PM, Dave Page <dp...@pgadmin.org> wrote: >> On Fri, Jul 13, 2012 at 9:31 AM, Atri Sharma <atri.j...@gmail.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers