This is the mail archive of the
cygwin-apps@cygwin.com
mailing list for the Cygwin project.
postgresql-7.4.5-1 ready for review
- From: Reini Urban <rurban at x-ray dot at>
- To: Jason Tishler <jason at tishler dot net>
- Cc: pgsql-cygwin at postgresql dot org, Cygwin Apps <cygwin-apps at cygwin dot com>
- Date: Wed, 25 Aug 2004 20:09:26 +0200
- Subject: postgresql-7.4.5-1 ready for review
- References: <412B9BDF.1010806@x-ray.at> <20040824202450.GA84212@tishler.net> <412BCB6E.405@x-ray.at> <20040825120544.GE84948@tishler.net> <412C9E89.3030000@x-ray.at> <20040825171659.GA85492@tishler.net>
ok, postgresql-7.4.5-1 is ready.
The problems were cygipc related (of course), which I
patched away in configure.
All tests passed ok (besides one minor cr/lf issue. see attached)
The files are at
http://xarch.tu-graz.ac.at/home/rurban/software/cygwin/postgresql/postgresql-7.4.5-1/
just the setup.hint is missing. This is your (Jason) job :)
The src package is similar to your old setup,
(orisrc/ plus orisrc/CYGWIN-PATCHES/)
but it really should be changed to
<orisrc>.tar.bz2 and the build and patch file.
I'll to change that with the 8.0.0beta1 package.
Jason Tishler schrieb:
On Wed, Aug 25, 2004 at 04:13:29PM +0200, Reini Urban wrote:
Attached is my 7.4.5 build script,
not yet converted to the new generic-build-script mechanism.
In order to fix the tcl issues I needed perl.
There are still minor tcl issues, but I'll fix them soon.
IMO, I would hold off on Tcl until 8.0 in order to get 7.4.5 out ASAP.
There's another short Makefile.cygwin patch to build contrib/dbase
correctly. Hope this will be accepted (or looked at) upstream.
Sending patches to pgsql-patches@ is a better way to get noticed. :,)
ok, I'll do.
With the standard order of libs from configure it will fail, because
our libiconv is shared.
With just the needed libs in the correct order it builds fine:
$ gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declarations dbf.o dbf2pg.o endian.o -lpq -L../../src/port
-lpgport -lintl -o dbf2pg
dbf2pg from 7.4.3 built cleanly for me:
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations dbf.o dbf2pg.o endian.o -L../../src/interfaces/libpq -lpq -L../../src/port -L/usr/local/lib -lssl -lcrypto -lz -lreadline -lcrypt -lpgport -o dbf2pg
Why is it failing for you?
Because a had -lintl also, which is dynamically resolved.
your built doesn't use libintl.
I wanted to have nls support. :)
The first standard regression test attempt (--max-connections=10)
failed with:
I recommend using the following:
make MAX_CONNECTIONS=1 check
I certainly wouldn't use MAX_CONNECTIONS > 5 as indicated in the README.
[snip]
Seems to be a cygserver issue. cygserver is running as service. I'll
hunt that down, but looks strange. Seems that I really linked against
cygipc and so it doesn't use cygserver :(
Hmm... What does cygcheck indicate?
The problem was this autoconf line (configure.in):
AC_CHECK_LIB(cygipc, shmget)
we have now "native" cygwin shmget support. so this check is bogus.
we really should add a check if shmget is in sys/shm.h
something like
AC_CHECK_LIB(, shmget)
(untested)
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
*** ./expected/horology-no-DST-before-1970.out Thu Sep 25 17:16:34 2003
--- ./results/horology.out Wed Aug 25 18:33:14 2004
***************
*** 1787,1796 ****
| Wed Mar 15 13:14:02 2000 PST | @ 34 years | Tue Mar 15 13:14:02 1966 PST
| Sun Dec 31 17:32:01 2000 PST | @ 34 years | Sat Dec 31 17:32:01 1966 PST
| Mon Jan 01 17:32:01 2001 PST | @ 34 years | Sun Jan 01 17:32:01 1967 PST
! | Sat Sep 22 18:19:20 2001 PDT | @ 34 years | Fri Sep 22 18:19:20 1967 PST
! | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours | Thu Jul 31 12:00:00 1969 PST
! | Thu Jan 01 00:00:00 1970 PST | @ 5 mons | Fri Aug 01 00:00:00 1969 PST
! | Thu Jan 01 00:00:00 1970 PST | @ 3 mons | Wed Oct 01 00:00:00 1969 PST
| Thu Jan 01 00:00:00 1970 PST | @ 10 days | Mon Dec 22 00:00:00 1969 PST
| Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30 21:56:56 1969 PST
| Thu Jan 01 00:00:00 1970 PST | @ 5 hours | Wed Dec 31 19:00:00 1969 PST
--- 1787,1796 ----
| Wed Mar 15 13:14:02 2000 PST | @ 34 years | Tue Mar 15 13:14:02 1966 PST
| Sun Dec 31 17:32:01 2000 PST | @ 34 years | Sat Dec 31 17:32:01 1966 PST
| Mon Jan 01 17:32:01 2001 PST | @ 34 years | Sun Jan 01 17:32:01 1967 PST
! | Sat Sep 22 18:19:20 2001 PDT | @ 34 years | Fri Sep 22 18:19:20 1967 PDT
! | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours | Thu Jul 31 12:00:00 1969 PDT
! | Thu Jan 01 00:00:00 1970 PST | @ 5 mons | Fri Aug 01 00:00:00 1969 PDT
! | Thu Jan 01 00:00:00 1970 PST | @ 3 mons | Wed Oct 01 00:00:00 1969 PDT
| Thu Jan 01 00:00:00 1970 PST | @ 10 days | Mon Dec 22 00:00:00 1969 PST
| Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30 21:56:56 1969 PST
| Thu Jan 01 00:00:00 1970 PST | @ 5 hours | Wed Dec 31 19:00:00 1969 PST
======================================================================