我想用MinGW 去编译postgresql 虽然UNICODE-8支持中文,但是日本人就开发了一个日文的包装入进去了……
但是我载了一个POSTGRESQL源代码,我也没有编译过去啊。有人帮我吗?
MinGW都应该怎么设置?PostgreSQL Win32 Installer
Some quick notes
Requirements
------------
1. WiX toolkit (
http://wix.sourceforge.net)
2. Perl (tested with ActiveState perl 5.8.3)
3. MingW (uses "real" Makefiles. May work with other Makes, but
really, MingW is needed for postgresql build anyway)
4. Installed tree of postgresql
5. PostgreSQL source tree
6. pgAdmin Support module (from
http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/pgadmin-tools/support/)
7. Npgsql (from
http://gborg.postgresql.org/project/npgsql)
8. psqlODBC (from
http://gborg.postgresql.org/project/psqlodbc)
9. PostgreSQL JDBC (from
http://jdbc.postgresql.org)
10. PgOleDb (from
http://gborg.postgresql.org/projects/oledb)
11a. PostGIS (from
http://postgis.refractions.net)
11b. libgeos (from
http://geos.refractions.net)
11c. proj4 (from
http://www.remotesensing.org/proj)
Directory layout
----------------
bmp/ Contains bitmap images used in the installer
ca/ Source for custom action DLL
inst/ Utility files installed by the installer that are
not included in postgresql.
package/Contains files included in ZIPs but not in the MSI
txt/ Contains textfiles used in the installer
util/ Contains utility scripts used during build
wxi/ Contains WiX include files (autogenerated)
wxs/ Contains WiX source files
Build preparations
------------------
1. Run "make Makefile.paths" to get a template of this file. Then edit the
Makefile.paths file and set the correct paths.
2. Compile the PG source tree *without* SSL support.
3. Build libpqstatic.a in the ca/ directory.
4. Build and install PostgreSQL *with* SSL support. The standard options are
./configure --with-openssl --with-perl --with-tcl --with-python --enable-nls
Note: Step 3 builds a non-SSL static libpq from the main builds object files
for the installers custom action code to use. This needs to be updated when
libpq changes in the PG source, but not normally during a build.
'make distclean' will remove libpqstatic.a.
Building PostGIS
----------------
1. Unpack proj4 in a suitable place. Run ./configure && make && make install
2. Unpack libgeos in a suitable place. Get a new timeval.h from
http://mywebpage.netscape.com/yongweiwu/timeval.h.txt and put it in
source\headers\geos\timeval.h.
Edit source\headers\geos\profiler.h and replace the
#include <sys/time.h>
with
#include "timeval.h"
(This is expected to be included in the next version of libgeos)
Run ./configure && make && make install
3. Go into /usr/local/lib and run:
g++ -shared -o libgeos.dll -Wl,--out-implib=libgeos.dll.a
-Wl,--export-all-symbols -Wl,--enable-auto-import -Wl,--whole-archive libgeos.a
-Wl,--no-whole-archive /c/mingw/lib/libmingw32.a
(all on the same line! It's a long command!)
Then run:
strip libgeos.dll
(otherwise, the DLL is just *huge*)
4. Unpack PostGIS into $PGSRC/contrib/postgis (note! Remove the version number!)
run "make"
Do *NOT* run "make install", because postgis installs some files in the wrong location and they
get picked up by the general contrib scripts.