Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9F4AA9FBB49 for ; Wed, 2 May 2007 03:52:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 43188-01 for ; Wed, 2 May 2007 03:52:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc1-s33.bay0.hotmail.com (bay0-omc1-s33.bay0.hotmail.com [65.54.246.105]) by postgresql.org (Postfix) with ESMTP id 816AC9FBB45 for ; Wed, 2 May 2007 03:52:42 -0300 (ADT) Received: from hotmail.com ([65.54.174.11]) by bay0-omc1-s33.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Tue, 1 May 2007 23:52:41 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 1 May 2007 23:52:41 -0700 Message-ID: Received: from 65.54.174.200 by by103fd.bay103.hotmail.msn.com with HTTP; Wed, 02 May 2007 06:52:39 GMT X-Originating-IP: [203.59.232.223] X-Originating-Email: [vernaviolet@hotmail.com] X-Sender: vernaviolet@hotmail.com From: "Verna Violet" To: pgsql-admin@postgresql.org Subject: Compile Postgres 8.2.4 under Windows failing Date: Wed, 02 May 2007 16:22:39 +0930 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 02 May 2007 06:52:41.0299 (UTC) FILETIME=[7A8E2230:01C78C86] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.909 tagged_above=0 required=5 tests=BAYES_50=0.001, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, MSGID_FROM_MTA_HEADER=0 X-Spam-Level: * X-Archive-Number: 200705/11 X-Sequence-Number: 25331 I am currently running Windows XP Pro and need to re-compile PostgreSQL as we need to increase the length of the NAMEDATALENGTH parameter to 128. Before attempting to change this value I thought I would see if I could successfully compile PostgreSQl under Windows. I downloaded and installed all options in MingGW-5.1.3.exe to the directory c:\MinGW I downloaded postgresql-8.2.4.tar.bz2 and extracted the files. I started MSys and cd to the location of Postgres extract I ran ./configure --without-zlib successfully - exit 0 When I run make install I get the following output and can't work out what's wrong. make -C doc install make[1]: Entering directory `/home/Verna/sources/PostgreSQL/postgresql-8.2.4/doc' gzip -d -c ./postgres.tar.gz | ( cd /usr/local/pgsql/doc/html && /bin/tar xf - ) for file in man1/*.1 man7/*.7 ; do \ /bin/sh.exe ../config/install-sh -c -m 644 $file /usr/local/pgsql/man/$file || exit; \ done make[1]: Leaving directory `/home/Verna/sources/PostgreSQL/postgresql-8.2.4/doc' make -C src install make[1]: Entering directory `/home/Verna/sources/PostgreSQL/postgresql-8.2.4/src' /bin/sh.exe ../config/mkinstalldirs '/usr/local/pgsql/lib/pgxs/src' /bin/sh.exe ../config/install-sh -c -m 644 Makefile.global '/usr/local/pgsql/lib/pgxs/src/Makefile.global' /bin/sh.exe ../config/install-sh -c -m 644 Makefile.port '/usr/local/pgsql/lib/pgxs/src/Makefile.port' /bin/sh.exe ../config/install-sh -c -m 644 ./Makefile.shlib '/usr/local/pgsql/lib/pgxs/src/Makefile.shlib' /bin/sh.exe ../config/install-sh -c -m 644 ./nls-global.mk '/usr/local/pgsql/lib/pgxs/src/nls-global.mk' make -C port install make[2]: Entering directory `/home/Verna/sources/PostgreSQL/postgresql-8.2.4/src/port' gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -I../../src/port -DFRONTEND -I../../src/include -I./src/include/port/win32 -DEXEC_BACKEND "-I../../src/include/port/win32" -c -o getrusage.o getrusage.c In file included from ../../src/include/rusagestub.h:17, from getrusage.c:18: c:/MinGW/bin/../lib/gcc/mingw32/3.4.2/../../../../include/sys/time.h:27: error: redefinition of `struct timezone' c:/MinGW/bin/../lib/gcc/mingw32/3.4.2/../../../../include/sys/time.h:40: error: conflicting types for 'gettimeofday' ../../src/include/port.h:292: error: previous declaration of 'gettimeofday' was here c:/MinGW/bin/../lib/gcc/mingw32/3.4.2/../../../../include/sys/time.h:40: error: conflicting types for 'gettimeofday' ../../src/include/port.h:292: error: previous declaration of 'gettimeofday' was here make[2]: *** [getrusage.o] Error 1 make[2]: Leaving directory `/home/Verna/sources/PostgreSQL/postgresql-8.2.4/src/port' make[1]: *** [install] Error 2 make[1]: Leaving directory `/home/Verna/sources/PostgreSQL/postgresql-8.2.4/src' make: *** [install] Error 2 What am I doing wrong? Cheers _________________________________________________________________ Advertisement: Its simple! Sell your car for just $30 at carsales.com.au http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801577%2Fpi%5F1005244%2Fai%5F838588&_t=754951090&_r=tig&_m=EXT