Re: [HACKERS] Call for port reports
--- Tom Lane [EMAIL PROTECTED] escreveu: If you don't see your favorite platform already listed as tested for 8.1 at http://developer.postgresql.org/docs/postgres/supported-platforms.html then please give it a try and send in your results. [EMAIL PROTECTED]:~# uname -a Linux foobar 2.4.29 #6 Thu Jan 20 16:30:37 PST 2005 i686 unknown unknown GNU/Linux [EMAIL PROTECTED]:~# cat /etc/slackware-version Slackware 10.1.0 [EMAIL PROTECTED]:~# gcc --version gcc (GCC) 3.3.4 Copyright (C) 2003 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. [EMAIL PROTECTED]:~# gmake --version GNU Make 3.80 Copyright (C) 2002 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. [EMAIL PROTECTED]:~# == All 98 tests passed. == [EMAIL PROTECTED]:~# /dados/pg/install/bin/pg_config BINDIR = /dados/pg/install/bin DOCDIR = /dados/pg/install/doc/postgresql INCLUDEDIR = /dados/pg/install/include PKGINCLUDEDIR = /dados/pg/install/include/postgresql INCLUDEDIR-SERVER = /dados/pg/install/include/postgresql/server LIBDIR = /dados/pg/install/lib PKGLIBDIR = /dados/pg/install/lib/postgresql LOCALEDIR = /dados/pg/install/share/locale MANDIR = /dados/pg/install/man SHAREDIR = /dados/pg/install/share/postgresql SYSCONFDIR = /dados/pg/install/etc/postgresql PGXS = /dados/pg/install/lib/postgresql/pgxs/src/makefiles/pgxs.mk CONFIGURE = '--prefix=/dados/pg/install' '--enable-nls=pt_BR' '--enable-debug' '--enable-cassert' '--enable-depend' '--enable-integer-datetimes' '--enable-thread-safety' '--with-pgport=9876' '--with-openssl' 'CFLAGS=-O2 -mcpu=i686 -march=i686' CC = gcc CPPFLAGS = -D_GNU_SOURCE CFLAGS = -O2 -mcpu=i686 -march=i686 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-labels -fno-strict-aliasing -g CFLAGS_SL = -fpic LDFLAGS = -Wl,-rpath,/dados/pg/install/lib LDFLAGS_SL = LIBS = -lpgport -lssl -lcrypto -lz -lreadline -ltermcap -lcrypt -lresolv -lnsl -ldl -lm VERSION = PostgreSQL 8.1RC1 [EMAIL PROTECTED]:~# Euler Taveira de Oliveira euler[at]yahoo_com_br ___ Promoção Yahoo! Acesso Grátis: a cada hora navegada você acumula cupons e concorre a mais de 500 prêmios! Participe! http://yahoo.fbiz.com.br/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] Call for port reports
Hi, PostgreSql 8.1 RC1 ( --with-perl --with-python) passed all tests on Slackware Linux 10.2 (kernel 2.4.31, x86) Regards, Adrian Maier ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports
Tom, FreeBSD 5.4 Opteron 64 SMP pass. --Josh ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Call for port reports
Josh Berkus wrote: Tom, FreeBSD 5.4 Opteron 64 SMP pass. BSD/OS 4.3.1 i386 SMP passes. -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[HACKERS] Call for port reports
If you don't see your favorite platform already listed as tested for 8.1 at http://developer.postgresql.org/docs/postgres/supported-platforms.html then please give it a try and send in your results. I'd recommend using 8.1beta4 or later, as beta4 already includes a few small portability fixes over beta3 --- no point in reinventing that work. regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Call for port reports
Tom, SuSE Linux 9.3 Professional, 2.6.11.4-20a-default, gcc (GCC) 3.3.5, Athlon64 --with-perl --with-integer-datetimes --with-pgport=5801 --prefix=/usr/local/pg81 == All 98 tests passed. == -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] Call for port reports
Hello Tom, Slackware 10.0, kernel 2.6.12, x86, gcc 3.3.4 All 98 tests passed. Sergey * Sergey E. Koposov Max-Planck Institut fuer Astronomie Web: http://lnfm1.sai.msu.ru/~math E-mail: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Call for port reports
8.0.0rc1 builds and passes 'make check' on Gentoo Linux (amd64) with the dependencies I have to hand (no tcl or kerberos): $ ./configure --prefix=/home/oliver/pg/8.0.0rc1 --with-pgport=5800 -enable-thread-safety --with-perl --with-python --with-pam -with-openssl $ uname -a Linux extrashiny 2.6.9-gentoo-r3-patched #3 Sun Nov 14 15:18:33 NZDT 2004 x86_64 AMD Athlon(tm) 64 Processor 3500+ AuthenticAMD GNU/Linux $ 8.0.0rc1/bin/psql template1 -t -c 'select version()' PostgreSQL 8.0.0rc1 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 20040623 (Gentoo Linux 3.3.4-r1, ssp-3.3.2-2, pie-8.7.6) -O ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for port reports
Prototype is #include signal.h int sigwait (sigset_t *set); but fe_secure.c calls sigwait(sigpipe_sigset, signo); so there's effectively one argument too much! reards On Fri, 17 Dec 2004, Tom Lane wrote: Date: Fri, 17 Dec 2004 12:49:59 -0500 From: Tom Lane [EMAIL PROTECTED] To: Bruce Momjian [EMAIL PROTECTED] Cc: [EMAIL PROTECTED], pgsql-hackers list [EMAIL PROTECTED] Subject: Re: [HACKERS] Call for port reports Bruce Momjian [EMAIL PROTECTED] writes: [EMAIL PROTECTED] wrote: UX:acomp: ERREUR: fe-secure.c, ligne 1316 : prototype mismatch: 2 args passed, 1 expected: sigwait() What is your prototype for sigwait()? Whatever it is, it doesn't agree with the Single Unix Spec: http://www.opengroup.org/onlinepubs/007908799/xsh/sigwait.html On HPUX 10.20 I see #include pthread.h int sigwait(sigset_t *set); and indeed --enable-thread-safety doesn't work on this platform, although we fail the thread safety configure test so there are other problems beside sigwait(). My feeling about this is too bad, we are not supporting threading on platforms whose pthread.h doesn't follow SUS. regards, tom lane -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] -- Make your life a dream, make your dream a reality. (St Exupery) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Call for port reports
Has anybody tried Solaris8 or 9/ADM64(SUN Fire v40 for example) combo? I personally don't have access to this platform, but am interested in someone else has already tried. -- Tatsuo Ishii I have started filling in the supported platform list for the 8.0.0 release with the information from the build farm: http://developer.postgresql.org/docs/postgres/supported-platforms.html It's now time to fill the holes. Briefly, I'm looking for exit status 0 on ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \ --with-perl --with-python --with-krb5 --with-pam -with-openssl make make install make check with PostgreSQL 8.0.0rc1 or later. If you know what you're doing, you can also try other options, but please tell what you did. (I would like the build farm members for Windows and Cygwin to use more feature-enabling options, because in those cases we really need the information about which extra features compile and work.) If your system provides multiple compilers (for example, a vendor compiler and GCC), test with all of them. Call configure as follows: ./configure CC=/foo/cc --prefix=... If your system has multiple compilation modes, such as 32 bit and 64 bit, it may be worth trying both. Report the output of SELECT version(); as well as a common name of the operating system under which it can be listed (e.g., the distributor, in case of a Linux-based system). -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] Call for port reports
This did'nt get thru so I repost it! 8.0.0rc1 fails to compile on Unixware 714 with --enable-thread-safety : CC=cc LDFLAGS=-R/usr/local/lib ANT_HOME=/usr/local/jakarta/ant JAVA_HOME=/usr/java2 PATH=$PATH:/usr/local/jakarta/ant/bin #PREFIX=-prefix=/databases/pgsql-v7.4 --with-port=5532 #DEBUG=--enable-debug --enable-cassert THREADS=--enable-thread-safety export PATH CC ANT_HOME JAVA_HOME CPPFLAGS ./configure $PREFIX --enable-locale $DEBUG --with-ssl --with-perl --with-tcl --with-tk --enable-syslog --with-tclconfig=/usr/local/lib --with-tkconfig=/usr/local/lib --with-includes=/usr/local/include --with-libs=/usr/local/lib --with-java --without-CXX --without-x --with-ssl $THREADS UX:acomp: ERREUR: fe-secure.c, ligne 1316 : prototype mismatch: 2 args passed, 1 expected: sigwait() gmake[3]: *** [fe-secure.o] Error 1 gmake[2]: *** [all] Error 2 gmake[1]: *** [all] Error 2 gmake: *** [all] Error 2 UX:make: ERREUR: erreur irrémédiable. It passes all tests without thread-safety. Regards, -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] -- Make your life a dream, make your dream a reality. (St Exupery) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Call for port reports
[EMAIL PROTECTED] wrote: This did'nt get thru so I repost it! 8.0.0rc1 fails to compile on Unixware 714 with --enable-thread-safety : CC=cc LDFLAGS=-R/usr/local/lib ANT_HOME=/usr/local/jakarta/ant JAVA_HOME=/usr/java2 PATH=$PATH:/usr/local/jakarta/ant/bin #PREFIX=-prefix=/databases/pgsql-v7.4 --with-port=5532 #DEBUG=--enable-debug --enable-cassert THREADS=--enable-thread-safety export PATH CC ANT_HOME JAVA_HOME CPPFLAGS ./configure $PREFIX --enable-locale $DEBUG --with-ssl --with-perl --with-tcl --with-tk --enable-syslog --with-tclconfig=/usr/local/lib --with-tkconfig=/usr/local/lib --with-includes=/usr/local/include --with-libs=/usr/local/lib --with-java --without-CXX --without-x --with-ssl $THREADS UX:acomp: ERREUR: fe-secure.c, ligne 1316 : prototype mismatch: 2 args passed, 1 expected: sigwait() gmake[3]: *** [fe-secure.o] Error 1 gmake[2]: *** [all] Error 2 gmake[1]: *** [all] Error 2 gmake: *** [all] Error 2 UX:make: ERREUR: erreur irr?m?diable. It passes all tests without thread-safety. What is your prototype for sigwait()? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports
Bruce Momjian [EMAIL PROTECTED] writes: [EMAIL PROTECTED] wrote: UX:acomp: ERREUR: fe-secure.c, ligne 1316 : prototype mismatch: 2 args passed, 1 expected: sigwait() What is your prototype for sigwait()? Whatever it is, it doesn't agree with the Single Unix Spec: http://www.opengroup.org/onlinepubs/007908799/xsh/sigwait.html On HPUX 10.20 I see #include pthread.h int sigwait(sigset_t *set); and indeed --enable-thread-safety doesn't work on this platform, although we fail the thread safety configure test so there are other problems beside sigwait(). My feeling about this is too bad, we are not supporting threading on platforms whose pthread.h doesn't follow SUS. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Call for port reports
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: [EMAIL PROTECTED] wrote: UX:acomp: ERREUR: fe-secure.c, ligne 1316 : prototype mismatch: 2 args passed, 1 expected: sigwait() What is your prototype for sigwait()? Whatever it is, it doesn't agree with the Single Unix Spec: http://www.opengroup.org/onlinepubs/007908799/xsh/sigwait.html On HPUX 10.20 I see #include pthread.h int sigwait(sigset_t *set); and indeed --enable-thread-safety doesn't work on this platform, although we fail the thread safety configure test so there are other problems beside sigwait(). My feeling about this is too bad, we are not supporting threading on platforms whose pthread.h doesn't follow SUS. I think we have to at least test for this in configure and give them an error message there rather than generating a compile error later. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Call for port reports
Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: My feeling about this is too bad, we are not supporting threading on platforms whose pthread.h doesn't follow SUS. I think we have to at least test for this in configure and give them an error message there rather than generating a compile error later. No objection here --- feel free to extend the thread-safety test so that it fails if sigwait has the wrong signature. regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Call for port reports
I tested with what dependencies were already available. Unfortunately, even --with-perl couldn't be used because the libraries are apparently non-shared (or so the build process reported). == AIX 5.1, 32-bit, four Power4 processors, # SELECT version(); PostgreSQL 8.0.0rc1 on powerpc-ibm-aix5.1.0.0, compiled by /usr/bin/cc_r ./configure \ CC=/usr/bin/cc_r \ CFLAGS='-qmaxmem=-1' \ --prefix=SOMEWHERE \ --enable-thread-safety \ --with-openssl \ make make install make check All 96 tests passed. == == AIX 5.1, 64-bit, four Power4 processors, # SELECT version(); PostgreSQL 8.0.0rc1 on powerpc-ibm-aix5.1.0.0, compiled by /usr/bin/cc_r export OBJECT_MODE=64 ./configure \ CC=/usr/bin/cc_r \ CFLAGS='-qmaxmem=-1 -q64' \ --prefix=SOMEWHERE \ --enable-thread-safety \ --without-readline \ --without-zlib make make install make check All 96 tests passed. == ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports
Port report for Solaris 8: No errors. uname -a: SunOS sunos58.build 5.8 Generic_117350-11 sun4u sparc SUNW,UltraAX-i2 gcc -v: Reading specs from /gcc-3.4.0/sunos5/bin/../lib/gcc/sparc-sun-solaris2.8/3.4.0/specs Configured with: /gcc-3.4.0/src/dist/configure --prefix=/usr/site/gcc-3.4.0 --enable-shared --with-cpu=v9 Thread model: posix gcc version 3.4.0 configure: ./configure --prefix=/usr/site/pg800rc1 --enable-thread-safety --with-tcl --with-perl --with-python --with-krb5 --with-openssl CFLAGS: -O3 -fno-sched-interblock make check: == All 96 tests passed. == version: postgresql-8.0.0rc1 Port report for Redhat Enterprise 3: No errors. uname -a: Linux rhel3 2.4.21-15.EL #1 Thu Apr 22 00:27:41 EDT 2004 i686 i686 i386 GNU/Linux gcc -v: Reading specs from /gcc-3.4.0/rhel3/bin/../lib/gcc/i686-pc-linux-gnu/3.4.0/specs Configured with: /gcc-3.4.0/src/dist/configure --prefix=/usr/site/gcc-3.4.0 --enable-shared --with-tune=pentium3 --with-arch=i686 : (reconfigured) /build/gcc-3.4.0/src/dist/configure --prefix=/usr/site/gcc-3.4.0 --enable-shared --with-tune=pentium3 --with-arch=i686 Thread model: posix gcc version 3.4.0 configure: ./configure --prefix=/usr/site/pg800rc1 --enable-thread-safety --with-tcl --with-perl --with-python --with-krb5 --with-openssl CFLAGS: -O3 make check: == All 96 tests passed. == version: postgresql-8.0.0rc1 Port report for Redhat 9: No errors. uname -a: Linux redhat9.build 2.4.20-31.9 #1 Fri Jun 25 16:52:01 CDT 2004 i686 i686 i386 Gx gcc -v: Reading specs from /opt/opt.CORE/gcc-3.4.0/redhat9/bin/../lib/gcc/i686-pc-linux-gnu/3.4.0/specs Configured with: /build/gcc-3.4.0/src/dist/configure --prefix=/usr/site/gcc-3.4.0 --enable-shared --with-tune=pentium3 --with-arch=i686 Thread model: posix gcc version 3.4.0 configure: ./configure --prefix=/usr/site/pg800rc1 --enable-thread-safety --with-tcl --with-perl --with-python --with-krb5 --with-openssl CFLAGS: -O3 make check: == All 96 tests passed. == version: postgresql-8.0.0rc1 It would be nice if the regression tests actually executed a select version(); and logged the results in the regression test. Ken ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for port reports
Peter Eisentraut [EMAIL PROTECTED] writes: It's now time to fill the holes. Briefly, I'm looking for exit status 0 on ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \ --with-perl --with-python --with-krb5 --with-pam -with-openssl make make install make check with PostgreSQL 8.0.0rc1 or later. If you know what you're doing, you can also try other options, but please tell what you did. All regression tests pass on all seven architectures supported by Red Hat Enterprise Linux 3AS: i386generic Intel ia64Itanium x86_64 AMD ppc IBM pSeries ppc64 pSeries 64-bit s390IBM zSeries s390x zSeries 64-bit I did not test --with-tcl --with-python --with-krb5 --with-pam --with-openssl, for lack of installed packages, but since this is basically Linux I doubt there's much to be learned there. (If there is any problem with building with those packages added, I'll find out when I try to make Red Hat's RPMs ;-)) PostgreSQL 8.0.0rc1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-47) PostgreSQL 8.0.0rc1 on ia64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-24) PostgreSQL 8.0.0rc1 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-34) PostgreSQL 8.0.0rc1 on powerpc-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-38) PostgreSQL 8.0.0rc1 on powerpc64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-38) PostgreSQL 8.0.0rc1 on s390-ibm-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-47) PostgreSQL 8.0.0rc1 on s390x-ibm-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-47) regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for port reports
Peter Eisentraut wrote: Briefly, I'm looking for exit status 0 on ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \ --with-perl --with-python --with-krb5 --with-pam -with-openssl (I would like the build farm members for Windows and Cygwin to use more feature-enabling options, because in those cases we really need the information about which extra features compile and work.) I have successfully added --with-perl --with-python --with-openssl to the buildfarm cygwin member. Currently --with-tcl is giving me link problems. I'm not sure how relevant krb5 and pam are - I suspect not. cheers andrew ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Call for port reports
./configure \ --prefix=/usr/local/pgsql/8.0rc1 \ --enable-thread-safety \ --with-tcl \ --with-perl \ --with-python \ --with-krb5 \ --with-pam \ --with-openssl \ --with-includes=/sw/include/ \ --with-libraries=/sw/lib make check == All 96 tests passed. == test8=# select version() ; version PostgreSQL 8.0.0rc1 on powerpc-apple-darwin7.6.0, compiled by GCC gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build 1666) (1 row) On Dec 6, 2004, at 7:00 PM, Peter Eisentraut wrote: I have started filling in the supported platform list for the 8.0.0 release with the information from the build farm: http://developer.postgresql.org/docs/postgres/supported-platforms.html It's now time to fill the holes. Briefly, I'm looking for exit status 0 on ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \ --with-perl --with-python --with-krb5 --with-pam -with-openssl make make install make check with PostgreSQL 8.0.0rc1 or later. If you know what you're doing, you can also try other options, but please tell what you did. (I would like the build farm members for Windows and Cygwin to use more feature-enabling options, because in those cases we really need the information about which extra features compile and work.) If your system provides multiple compilers (for example, a vendor compiler and GCC), test with all of them. Call configure as follows: ./configure CC=/foo/cc --prefix=... If your system has multiple compilation modes, such as 32 bit and 64 bit, it may be worth trying both. Report the output of SELECT version(); as well as a common name of the operating system under which it can be listed (e.g., the distributor, in case of a Linux-based system). -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html Patrick B. Kelly -- v: 484.557.0646 http://patrickbkelly.org ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Eisentraut Sent: 07 December 2004 00:01 To: [EMAIL PROTECTED] Subject: [HACKERS] Call for port reports I have started filling in the supported platform list for the 8.0.0 release with the information from the build farm: http://developer.postgresql.org/docs/postgres/supported-platforms.html It's now time to fill the holes. Briefly, I'm looking for exit status 0 on ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \ --with-perl --with-python --with-krb5 --with-pam -with-openssl make make install make check All tests passed on Win32 (including a make installcheck in /contrib). *However*, note that PAM, Kerberos and pthreads do not (yet) work on Windows and were therefore excluded. SELECT version(): PostgreSQL 8.0.0rc1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.3.1 (mingw special 20030804-1) uname -a: MINGW32_NT-5.1 PC30 1.0.10(0.46/3/2) 2004-03-15 07:17 i686 unknown Regards, Dave ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Call for port reports
smallmouth:~/tmp ronz$ uname -a Darwin smallmouth.local 7.5.0 Darwin Kernel Version 7.5.0: Thu Aug 5 19:26:16 PDT 2004; root:xnu/xnu-517.7.21.obj~3/RELEASE_PPC Power Macintosh powerpc (or OS X 10.3.5) ./configure --prefix=/Users/ronz/tmp/pgsql8 --enable-thread-safety --with-tcl --with-perl --with-python --with-krb5 --with-pam -with-openssl --with-libs=/sw/lib --with-includes=/sw/include all 96 tests passed [local]:template1=# select version(); version PostgreSQL 8.0.0rc1 on powerpc-apple-darwin7.5.0, compiled by GCC gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build 1495) Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] Call for port reports
Title: RE: [HACKERS] Call for port reports Port report for Gentoo (www.gentoo.org) Linux: No errors. uname -a: Linux imgvmhost 2.4.26-gentoo-r3 #1 Tue Sep 7 14:20:02 EDT 2004 i686 Intel(R) Pentium(R) 4 CPU 2.40GHz GenuineIntel GNU/Linux gcc -v: gcc version 3.3.4 20040623 (Gentoo Linux 3.3.4-r1, ssp-3.3.2-2, pie-8.7.6) configure: ./configure --prefix=$mypg --enable-thread-safety --with-tcl --with-perl --with-python --with-krb5 --with-pam -with-openssl make check: == All 96 tests passed. == version: template1=# select version(); version PostgreSQL 8.0.0rc1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 20040623 (Gentoo Linux 3.3.4-r1, ssp-3.3.2-2, pie-8.7.6) (If there are other combinations of options anyone would like me to try, just let me know. I don't know which combinations are interesting, since the defaults work for my application.)
[HACKERS] Call for port reports
I have started filling in the supported platform list for the 8.0.0 release with the information from the build farm: http://developer.postgresql.org/docs/postgres/supported-platforms.html It's now time to fill the holes. Briefly, I'm looking for exit status 0 on ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \ --with-perl --with-python --with-krb5 --with-pam -with-openssl make make install make check with PostgreSQL 8.0.0rc1 or later. If you know what you're doing, you can also try other options, but please tell what you did. (I would like the build farm members for Windows and Cygwin to use more feature-enabling options, because in those cases we really need the information about which extra features compile and work.) If your system provides multiple compilers (for example, a vendor compiler and GCC), test with all of them. Call configure as follows: ./configure CC=/foo/cc --prefix=... If your system has multiple compilation modes, such as 32 bit and 64 bit, it may be worth trying both. Report the output of SELECT version(); as well as a common name of the operating system under which it can be listed (e.g., the distributor, in case of a Linux-based system). -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Call for port reports
Peter Eisentraut wrote: I have started filling in the supported platform list for the 8.0.0 release with the information from the build farm: http://developer.postgresql.org/docs/postgres/supported-platforms.html It's now time to fill the holes. Briefly, I'm looking for exit status 0 on ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \ --with-perl --with-python --with-krb5 --with-pam -with-openssl make make install make check buildfarm actually runs in this order: make make check make contrib make install ... more steps I assume that's ok. with PostgreSQL 8.0.0rc1 or later. If you know what you're doing, you can also try other options, but please tell what you did. (I would like the build farm members for Windows and Cygwin to use more feature-enabling options, because in those cases we really need the information about which extra features compile and work.) I will try. For Windows especially, it's possibly quite a deal of work - the client is running experimental code that is quite radically different from the released buildfarm code. Getting it to work with python, tcl, and openssl will be fun ... at any rate it will not be done by me for days. If anyone else (Magnus? Dave?) can supply this info for Windows I'd be glad. cheers andrew ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Call for port reports
Sorry, here is select version(); PostgreSQL 8.0.0rc1 on i386-pc-bsdi4.3.1, compiled by GCC 2.95.3 --- Peter Eisentraut wrote: I have started filling in the supported platform list for the 8.0.0 release with the information from the build farm: http://developer.postgresql.org/docs/postgres/supported-platforms.html It's now time to fill the holes. Briefly, I'm looking for exit status 0 on ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \ --with-perl --with-python --with-krb5 --with-pam -with-openssl make make install make check with PostgreSQL 8.0.0rc1 or later. If you know what you're doing, you can also try other options, but please tell what you did. (I would like the build farm members for Windows and Cygwin to use more feature-enabling options, because in those cases we really need the information about which extra features compile and work.) If your system provides multiple compilers (for example, a vendor compiler and GCC), test with all of them. Call configure as follows: ./configure CC=/foo/cc --prefix=... If your system has multiple compilation modes, such as 32 bit and 64 bit, it may be worth trying both. Report the output of SELECT version(); as well as a common name of the operating system under which it can be listed (e.g., the distributor, in case of a Linux-based system). -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports
== All 96 tests passed. == version PostgreSQL 8.0.0rc1 on i386-unknown-freebsd5.3, compiled by GCC gcc (GCC) 3.4.2 [FreeBSD] 20040728 (1 row) Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Call for port reports
Andrew Dunstan [EMAIL PROTECTED] writes: Peter Eisentraut wrote: ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \ --with-perl --with-python --with-krb5 --with-pam -with-openssl make make install make check buildfarm actually runs in this order: make make check make contrib make install ... more steps I assume that's ok. There is a difference, which is that on some (most?) platforms the latter sequence will involve make check invoking the libpq shared library that was installed by the previous iteration of make install. I'm not sure that this matters a whole lot for the buildfarm, since at worst it would result in failures for one test cycle when libpq.so changes incompatibly. But it's important to realize what you are testing. regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Call for port reports
Tom Lane said: Andrew Dunstan [EMAIL PROTECTED] writes: Peter Eisentraut wrote: ./configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \ --with-perl --with-python --with-krb5 --with-pam -with-openssl make make install make check buildfarm actually runs in this order: make make check make contrib make install ... more steps I assume that's ok. There is a difference, which is that on some (most?) platforms the latter sequence will involve make check invoking the libpq shared library that was installed by the previous iteration of make install. I'm not sure that this matters a whole lot for the buildfarm, since at worst it would result in failures for one test cycle when libpq.so changes incompatibly. But it's important to realize what you are testing. The script installs to a non-standard location ( buildroot/branch/inst ) and removes the installation at the end of each run. In fact, it refuses to run if this directory exists when the run starts, precisely so we don't get clobbered by previous runs. Also, note that since it stops on the first step that fails, the failure would persist rather than lasting one cycle, had we not prevented it in the first place. cheers andrew ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] Call for port reports
Kurt, this patch added special includes for testing un.h, and I believe it caused regression failures for the statistics collector. Is it still needed? What platform is this? --- Kurt Roeckx wrote: On Fri, Oct 24, 2003 at 11:37:32AM -0400, Bruce Momjian wrote: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. I need this small patch so it properly detects I have unix domain sockets. Otherwise no problems. Kurt [ Attachment, skipping... ] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Call for port reports
I just tested gcc 2.95.3 on BSD/OS i386 and didn't see any change when using -g3 vs -g in the size of the binaries. --- Neil Conway wrote: On Sat, 2003-10-25 at 21:29, Bruce Momjian wrote: configure --enable-debug will use -g for the compile, and with optimization. I'm just curious: would there be any benefit to using -g3 when --enable-debug is specified and -g3 is supported by gcc? From the gcc man page: -glevel [...] Request debugging information and also use level to specify how much information. The default level is 2. Level 1 produces minimal information, enough for making backtraces in parts of the program that you don't plan to debug. This includes descriptions of functions and external variables, but no information about local variables and no line numbers. Level 3 includes extra information, such as all the macro defini- tions present in the program. Some debuggers support macro expan- sion when you use -g3. Note that in order to avoid confusion between DWARF1 debug level 2, and DWARF2, neither -gdwarf nor -gdwarf-2 accept a concatenated debug level. Instead use an additional -glevel option to change the debug level for DWARF1 or DWARF2. -Neil -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Call for port reports
On Sat, Nov 08, 2003 at 06:36:38PM -0500, Bruce Momjian wrote:
Kurt, this patch added special includes for testing un.h, and I believe
it caused regression failures for the statistics collector. Is it still
needed? What platform is this?
It's a linux system with an (old) libc5. It's still needed for
that platform, but I doubt many people would use it.
On what platfrom does it break? Is the result of checking for
un.h different?
The stats collector has this code that is relevant:
for (addr = addrs; addr; addr = addr-ai_next)
{
#ifdef HAVE_UNIX_SOCKETS
/* Ignore AF_UNIX sockets, if any are returned. */
if (addr-ai_family == AF_UNIX)
continue;
#endif
if ((pgStatSock = socket(addr-ai_family, SOCK_DGRAM, 0)) = 0)
break;
}
Kurt
---(end of broadcast)---
TIP 8: explain analyze is your friend
Re: [HACKERS] Call for port reports
Bruce Momjian [EMAIL PROTECTED] writes: I just tested gcc 2.95.3 on BSD/OS i386 and didn't see any change when using -g3 vs -g in the size of the binaries. I saw the same with gcc 2.95.3 on HPUX. The gcc manual for this version does claim that -g3 dumps extra info, but perhaps that is only true in certain object-file formats. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for port reports
I wrote: For a change, here is one that does not work: HP-UX hpunix5 B.11.00 U 9000/803 2002765023 This one is OK now. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Call for port reports
Bruce Momjian writes:
It is time for people to report their port testing. Please test against
current CVS or beta5 and report your 'uname -a'.
For a change, here is one that does not work:
HP-UX hpunix5 B.11.00 U 9000/803 2002765023
Using the system compiler, I get several complaints about our use of
inline, for example:
cc -Ae +O2 -I../../../../src/include -D_XOPEN_SOURCE_EXTENDED -c -o dynahash.o
dynahash.c
cc: dynahash.c, line 466: error 1000: Unexpected symbol: calc_bucket.
cc: panic 2017: Cannot recover from earlier errors, terminating.
I had to patch it as follows to get it to work:
diff -ur ../cvs-pgsql/src/backend/utils/hash/dynahash.c
./src/backend/utils/hash/dynahash.c
--- ../cvs-pgsql/src/backend/utils/hash/dynahash.c 2003-08-19 03:13:41.0
+0200
+++ ./src/backend/utils/hash/dynahash.c 2003-10-31 11:05:05.0 +0100
@@ -462,7 +462,7 @@
/* Convert a hash value to a bucket number */
-static inline uint32
+static uint32
calc_bucket(HASHHDR *hctl, uint32 hash_val)
{
uint32 bucket;
diff -ur ../cvs-pgsql/src/backend/utils/sort/tuplesort.c
./src/backend/utils/sort/tuplesort.c
--- ../cvs-pgsql/src/backend/utils/sort/tuplesort.c 2003-08-17 21:58:06.0
+0200
+++ ./src/backend/utils/sort/tuplesort.c2003-10-31 11:10:12.0 +0100
@@ -1784,7 +1784,7 @@
/*
* Inline-able copy of FunctionCall2() to save some cycles in sorting.
*/
-static inline Datum
+static Datum
myFunctionCall2(FmgrInfo *flinfo, Datum arg1, Datum arg2)
{
FunctionCallInfoData fcinfo;
@@ -1816,7 +1816,7 @@
* and return a 3-way comparison result. This takes care of handling
* NULLs and sort ordering direction properly.
*/
-static inline int32
+static int32
inlineApplySortFunction(FmgrInfo *sortFunction, SortFunctionKind kind,
Datum datum1, bool isNull1,
Datum datum2, bool isNull2)
Any ideas?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Call for port reports
Peter Eisentraut [EMAIL PROTECTED] writes: HP-UX hpunix5 B.11.00 U 9000/803 2002765023 Using the system compiler, I get several complaints about our use of inline, for example: Interesting. CVS tip works fine for me on HPUX 10.20, using cc -Ae. It looks like configure deduces inline is not supported on this compiler, though: /* Define as `__inline' if that's what the C compiler calls it, or to nothing if it is not supported. */ #define inline What do you get on that compiler? I had to patch it as follows to get it to work: Odd. I count ten inline functions in the backend: src/backend/storage/lmgr/lock.c: 94: inline static bool src/backend/storage/lmgr/lock.c: 105: inline static void src/backend/storage/lmgr/lock.c: 126: inline static void src/backend/storage/lmgr/lwlock.c: 67: inline static void src/backend/storage/lmgr/lwlock.c: 77: inline static void src/backend/utils/adt/pg_lzcompress.c: 389: static inline int src/backend/utils/hash/dynahash.c: 465: static inline uint32 src/backend/utils/mmgr/aset.c: 256: static inline int src/backend/utils/sort/tuplesort.c: 1787: static inline Datum src/backend/utils/sort/tuplesort.c: 1819: static inline int32 Why would only three of them fail? I'm not eager to remove the inlining optimization for everyone just because this one compiler fails. I think a more reasonable approach would be to force inline to be #define'd as empty on that platform. Or file a bug report with HP. regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Call for port reports
Bruce Momjian [EMAIL PROTECTED] writes: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. I can confirm CVS tip on HPUX 10.20, using both gcc and vendor's cc. $ uname -a HP-UX sss2 B.10.20 C 9000/780 2004473515 32-user license Looks like there are already confirmations for the other platforms I have at hand ... regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Call for port reports
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
One other idea would be to set CFLAGS to before including template,
and just test to see if it is still after --- that might be cleaner
than saving the original value and comparing.
Yeah, that bothered me a bit too --- what if the template tries to set
CFLAGS to its already-existing value? I was thinking that unsetting
CFLAGS before running the template would be the best answer.
I assume he did it that way so if you do:
CFLAGS=
in the template file that it would be honored. I see lots of this in
configure:
ac_env_CFLAGS_set=${CFLAGS+set}
but that uses 'set' if the variable is null or unset:
${parameter:+word}
Use Alternate Value. If parameter is null or
unset, nothing is substituted, otherwise the expan-
sion of word is substituted.
However, I thought null meant , but I now think null basically means
the same as unset in this manual page. Notice that '+' tests only for
unset, and knows when you have done VAR= and VAR=:
$ echo ${Y+no}
$ Y=
$ echo ${Y+no}
no
$ Y=
$ echo ${Y+no}
no
$ unset Y
$ echo ${Y+no}
$
so the proper test would be to unset the variable, then use ${var+val}
to test CFLAGS after the template file is included.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.| Newtown Square, Pennsylvania 19073
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for port reports
Tom Lane writes: Odd. I count ten inline functions in the backend: Why would only three of them fail? I just remembered this Autoconf change: 2002-03-28 Kevin Ryde [EMAIL PROTECTED] * lib/autoconf/c.m4 (AC_C_INLINE): Test with a typedef return value, to avoid versions of HP C which don't allow that. So there you have it. Do we want to backpatch the new autoconf test, or define inline to empty for this particular version of this platform, or try to do without typedef'd types? I prefer option 1. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for port reports
Peter Eisentraut [EMAIL PROTECTED] writes: * lib/autoconf/c.m4 (AC_C_INLINE): Test with a typedef return value, to avoid versions of HP C which don't allow that. So there you have it. Do we want to backpatch the new autoconf test, or define inline to empty for this particular version of this platform, or try to do without typedef'd types? I prefer option 1. Me too, if the patch isn't too big. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports -- Failure on Linux
Did we ever find the cause of this failure? --- Rod Taylor wrote: -- Start of PGP signed section. Linux ns2 2.4.20-xfs #2 Tue Apr 15 10:04:43 EDT 2003 i686 unknown -- SNIP -- stats... FAILED == shutting down postmaster == === 1 of 93 tests failed. === *** ./expected/stats.outSat Sep 13 12:44:48 2003 --- ./results/stats.out Fri Oct 24 14:26:56 2003 *** *** 8,14 SHOW stats_start_collector; -- must be on stats_start_collector --- ! on (1 row) -- save counters --- 8,14 SHOW stats_start_collector; -- must be on stats_start_collector --- ! off (1 row) -- save counters *** *** 62,68 WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? | ?column? | ?column? --+--+--+-- ! t| t| t| t (1 row) SELECT st.heap_blks_read + st.heap_blks_hit = pr.heap_blks + cl.relpages, --- 62,68 WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? | ?column? | ?column? --+--+--+-- ! f| f| f| f (1 row) SELECT st.heap_blks_read + st.heap_blks_hit = pr.heap_blks + cl.relpages, *** *** 71,77 WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? --+-- ! t| t (1 row) -- clean up --- 71,77 WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? --+-- ! f| f (1 row) -- clean up On Fri, 2003-10-24 at 11:37, Bruce Momjian wrote: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. The current list is at: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html -- End of PGP section, PGP failed! -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for port reports
Bruce Momjian writes: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. This one is OK: OpenBSD ob.credativ.de 3.4 GENERIC#65 sparc -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: Fwd: Re: [HACKERS] Call for port reports
- Original Message - From: Tom Lane [EMAIL PROTECTED] To: Philip Yarra [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 29, 2003 10:58 PM Subject: Re: Fwd: Re: [HACKERS] Call for port reports Philip Yarra [EMAIL PROTECTED] writes: I've just tried the latest CVS on Tru64 (OSF) and I'm getting a surprising= number of failures. You seem to have some path problems: most of the errors look like + ERROR: could not access file /regress.so: No such file or directory or collateral damage. Check to see if the sed script that inserts path values into the regression scripts is doing the right things. I didn't see these objects actually made in the make log, although getting past all the warnings was painful, so maybe I missed it. cheers andrew ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
opteron port [was: Re: [HACKERS] Call for port reports]
Am So, den 26.10.2003 schrieb Bruce Momjian um 02:38: All 93 tests passed. ... Linux pergolesi 2.4.22 #1 SMP Mon Aug 25 20:56:25 CEST 2003 i686 GNU/Linux It says i686 but its AMD Opteron: [EMAIL PROTECTED]:~/pgsql$ cat /proc/cpuinfo |more ... model name : AMD Opteron(tm) Processor 240 ... I am confused how to handle this. Is this running in 32-bit mode? I am inclined to mention Opteron only when tested in 64-bit mode, because I think we all assume a 32-bit Opteron is the same as a standard AMD/Intel. Does uname report differently in 64-bit mode. You are right. Its now just like an i386 so it doesn't make sense to list it. When I will get access to an 64bit Opteron system I will test it again. -- Nol Kthe noel debian.org Debian GNU/Linux, www.debian.org signature.asc Description: Dies ist ein digital signierter Nachrichtenteil
Re: [HACKERS] Call for port reports
Bruce Momjian [EMAIL PROTECTED] writes: One other idea would be to set CFLAGS to before including template, and just test to see if it is still after --- that might be cleaner than saving the original value and comparing. Yeah, that bothered me a bit too --- what if the template tries to set CFLAGS to its already-existing value? I was thinking that unsetting CFLAGS before running the template would be the best answer. regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Call for port reports
On Fri, 2003-10-24 at 18:37, Bruce Momjian wrote: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. Sorry for the delay. All regression tests passed on Alpha Tru64/ Digital Unix version 4.0g using Digital CC. OSF1 emily V4.0 1530 alpha (the existing port list has only a report for Tru64 5.X) -- Alessio Bragadini [EMAIL PROTECTED] APL Financial Services (Overseas) Ltd ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports
Ports list updated: http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html --- Alessio Bragadini wrote: On Fri, 2003-10-24 at 18:37, Bruce Momjian wrote: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. Sorry for the delay. All regression tests passed on Alpha Tru64/ Digital Unix version 4.0g using Digital CC. OSF1 emily V4.0 1530 alpha (the existing port list has only a report for Tru64 5.X) -- Alessio Bragadini [EMAIL PROTECTED] APL Financial Services (Overseas) Ltd -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 8: explain analyze is your friend
Fwd: Re: [HACKERS] Call for port reports
I've just tried the latest CVS on Tru64 (OSF) and I'm getting a surprising number of failures. I've tested using gcc 2.95 and compaq's cc (both the same number of failures, can provide regression.* and make.out from /bin/cc run if required). The attached results are from gcc, which appears to be default unless I `export CC=/bin/cc` $ uname -a OSF1 hostname V4.0 1229 alpha [that's Tru64 v4.0F ] $ ./configure --with-thread-safety make clean check [snip] = 18 of 93 tests failed, 1 of these failures ignored. = I've attached regression.diffs and regression.out - the same CVS snapshot passed `make check` perfectly on Linux, BTW I saw Alessio's results from Tru64 v4.0g this morning - no problems there, so I wonder if I am doing something wrong... can anyone provide further suggestions? There may be some wierdness on my build host, so when time permits I'll try on a different alpha machine. I've also attached make.out.gz - the output of make. Regards, Philip Yarra. regression.out.gz Description: GNU Zip compressed data regression.diffs.gz Description: GNU Zip compressed data make.out.gz Description: GNU Zip compressed data ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: Fwd: Re: [HACKERS] Call for port reports
Philip Yarra [EMAIL PROTECTED] writes: I've just tried the latest CVS on Tru64 (OSF) and I'm getting a surprising= number of failures. You seem to have some path problems: most of the errors look like + ERROR: could not access file /regress.so: No such file or directory or collateral damage. Check to see if the sed script that inserts path values into the regression scripts is doing the right things. regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Call for port reports
Johan Henselmans [EMAIL PROTECTED] writes: I had trouble compiling postgressrc/pgsql/src/interfaces/ecpg/ecpglib and compiling pgsql/src/interfaces/ecpg/compatlib. Reason was I had asked during configure to include krb5 support. After adding the -lkrb5 flag to the Makefile in these subdirectories, everyting went fine. Okay, fixed. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports
Certainly other alpha gcc platforms must have problems with -O2? I am inclined to add something to configure.in for all alpha compiles that changes -O2 to -O. I'm not. It's one thing if FreeBSD thinks their compiler is broken. But before I accept that gcc is broken as a whole, I want to hear from the GCC folks. Well, I have no insite into the gcc camp, but, my understanding is that gcc 3.3 for the alpha isn't broken, but for gcc 2.X, it's pretty horked with any level of optimization. -sc -- Sean Chittenden ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Call for port reports (Win32 Client)
Yup, that works fine (just a few warnings about ERROR being redefined). Thanks, Dave. -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 02:50 To: Dave Page Cc: PostgreSQL-development Subject: Re: [HACKERS] Call for port reports (Win32 Client) This is all fixed in CVS --- would you try that? -- - Dave Page wrote: -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 26 October 2003 01:35 To: Dave Page Cc: PostgreSQL-development Subject: Re: [HACKERS] Call for port reports NMAKE : fatal error U1077: 'C:\PROGRA~1\MICROS~3\VC98\BIN\NMAKE.EXE' : return co de '0x2' Stop. I am confused why strings.h is being included because there is a test around it: #ifdef HAVE_STRINGS_H #include strings.h #endif Any ideas? Yesh I forgot to remove the cygwin pg_config.h before compiling. Sorry :-) Anyway, I now get the error below which is not surprising as Windows doesn't have pthreads, or pwd.h as standard. Regards, Dave. C:\cygwin\usr\local\src\postgresql-7.4beta5\srcnmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. cd include if not exist pg_config.h copy pg_config.h.win32 pg_config.h cd .. cd interfaces\libpq nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. Building the Win32 static library... cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nma03408. getaddrinfo.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmb03408. inet_aton.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmc03408. crypt.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmd03408. path.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nme03408. dllist.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmf03408. md5.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmg03408. ip.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmh03408. thread.c ..\..\include\utils/elog.h(37) : warning C4005: 'ERROR' : macro redefinition C:\PROGRA~1\MICROS~3\VC98\INCLUDE\wingdi.h(93) : see previous definition of 'ERROR' ..\..\port\thread.c(17) : fatal error C1083: Cannot open include file: 'pthread. h': No such file or directory NMAKE : fatal error U1077: 'cl.exe' : return code '0x2' Stop. NMAKE : fatal error U1077: 'C:\PROGRA~1\MICROS~3\VC98\BIN\NMAKE.EXE' : return co de '0x2' Stop. C:\cygwin\usr\local\src\postgresql-7.4beta5\src ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Call for port reports
On Sat, 2003-10-25 at 21:29, Bruce Momjian wrote: configure --enable-debug will use -g for the compile, and with optimization. I'm just curious: would there be any benefit to using -g3 when --enable-debug is specified and -g3 is supported by gcc? From the gcc man page: -glevel [...] Request debugging information and also use level to specify how much information. The default level is 2. Level 1 produces minimal information, enough for making backtraces in parts of the program that you don't plan to debug. This includes descriptions of functions and external variables, but no information about local variables and no line numbers. Level 3 includes extra information, such as all the macro defini- tions present in the program. Some debuggers support macro expan- sion when you use -g3. Note that in order to avoid confusion between DWARF1 debug level 2, and DWARF2, neither -gdwarf nor -gdwarf-2 accept a concatenated debug level. Instead use an additional -glevel option to change the debug level for DWARF1 or DWARF2. -Neil ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports (Win32 Client)
Windows client port list updated: http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html --- Dave Page wrote: Yup, that works fine (just a few warnings about ERROR being redefined). Thanks, Dave. -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 02:50 To: Dave Page Cc: PostgreSQL-development Subject: Re: [HACKERS] Call for port reports (Win32 Client) This is all fixed in CVS --- would you try that? -- - Dave Page wrote: -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 26 October 2003 01:35 To: Dave Page Cc: PostgreSQL-development Subject: Re: [HACKERS] Call for port reports NMAKE : fatal error U1077: 'C:\PROGRA~1\MICROS~3\VC98\BIN\NMAKE.EXE' : return co de '0x2' Stop. I am confused why strings.h is being included because there is a test around it: #ifdef HAVE_STRINGS_H #include strings.h #endif Any ideas? Yesh I forgot to remove the cygwin pg_config.h before compiling. Sorry :-) Anyway, I now get the error below which is not surprising as Windows doesn't have pthreads, or pwd.h as standard. Regards, Dave. C:\cygwin\usr\local\src\postgresql-7.4beta5\srcnmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. cd include if not exist pg_config.h copy pg_config.h.win32 pg_config.h cd .. cd interfaces\libpq nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. Building the Win32 static library... cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nma03408. getaddrinfo.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmb03408. inet_aton.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmc03408. crypt.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmd03408. path.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nme03408. dllist.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmf03408. md5.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmg03408. ip.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmh03408. thread.c ..\..\include\utils/elog.h(37) : warning C4005: 'ERROR' : macro redefinition C:\PROGRA~1\MICROS~3\VC98\INCLUDE\wingdi.h(93) : see previous definition of 'ERROR' ..\..\port\thread.c(17) : fatal error C1083: Cannot open include file: 'pthread. h': No such file or directory NMAKE : fatal error U1077: 'cl.exe' : return code '0x2' Stop. NMAKE : fatal error U1077: 'C:\PROGRA~1\MICROS~3\VC98\BIN\NMAKE.EXE' : return co de '0x2' Stop. C:\cygwin\usr\local\src\postgresql-7.4beta5\src ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Call for port reports
Am So, den 26.10.2003 schrieb Bruce Momjian um 02:20: (unstable)[EMAIL PROTECTED]:~/pgsql$ uname -a Linux raptor 2.4.19 #1 SMP Fri Nov 29 23:53:27 CET 2002 s390 GNU/Linux Updated. http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html Thx. Just a minor thing. The version of s/390 should be 7.4 and not 7.3. (maybe the same with OpenBSD/x86?) -- Nol Kthe noel debian.org Debian GNU/Linux, www.debian.org signature.asc Description: Dies ist ein digital signierter Nachrichtenteil
Re: [HACKERS] Call for port reports
I should mention that I don't have access to a FreeBSD Alpha box anymore :( Hence, I have no idea if it currently compiles or not. Chris Peter Eisentraut wrote: Bruce Momjian writes: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. FreeBSD svr1.postgresql.org 4.9-PRERELEASE FreeBSD 4.9-PRERELEASE #4: Sat Sep 20 14:41:58 ADT 2003 i386 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Call for port reports
On Sat, Oct 25, 2003 at 08:42:36PM -0400, Bruce Momjian wrote: I am confused by your report. I have success from Solaris kernel 5.8. I see 2.6 mentioned, and I know there is Solaris 7-9. What does uname -a show? SunOS oink 5.6 Generic_105182-09 i86pc i386 i86pc Which is the same as Solaris 2.6. Kurt ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for port reports
It's rumoured that Peter Eisentraut once said: Bruce Momjian writes: Uh, I am not inclined to mark the port as OK if the parallel regression tests fail --- what is the cause? They always have been on Cygwin. This platform just can't handle that many parallel connections. Previously though that just resulted in a few failed tests - the run always completed. This time I'm seeing it hang at some random point in the tests. The one difference between now and when I've run tests previously is that I'm now running a centrino laptop. I'll see if I can spend some more time on it later, though I have a very large project going live on Monday so finding time might be tricky :-( Regards, Dave. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] Call for port reports
Noèl Köthe wrote: -- Start of PGP signed section. Am So, den 26.10.2003 schrieb Bruce Momjian um 02:20: (unstable)[EMAIL PROTECTED]:~/pgsql$ uname -a Linux raptor 2.4.19 #1 SMP Fri Nov 29 23:53:27 CET 2002 s390 GNU/Linux Updated. http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html Thx. Just a minor thing. The version of s/390 should be 7.4 and not 7.3. (maybe the same with OpenBSD/x86?) Yep, fixed, and Freebsd/alpha too. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports
Christopher Kings-Lynne wrote: I should mention that I don't have access to a FreeBSD Alpha box anymore :( Hence, I have no idea if it currently compiles or not. No problem --- Peter go it. Chris Peter Eisentraut wrote: Bruce Momjian writes: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. FreeBSD svr1.postgresql.org 4.9-PRERELEASE FreeBSD 4.9-PRERELEASE #4: Sat Sep 20 14:41:58 ADT 2003 i386 -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports
Ports list updated: http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html Should I mention Solaris as 2.6 or 5.6? --- Kurt Roeckx wrote: On Sat, Oct 25, 2003 at 08:42:36PM -0400, Bruce Momjian wrote: I am confused by your report. I have success from Solaris kernel 5.8. I see 2.6 mentioned, and I know there is Solaris 7-9. What does uname -a show? SunOS oink 5.6 Generic_105182-09 i86pc i386 i86pc Which is the same as Solaris 2.6. Kurt ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Call for port reports
Dave Page wrote: It's rumoured that Peter Eisentraut once said: Bruce Momjian writes: Uh, I am not inclined to mark the port as OK if the parallel regression tests fail --- what is the cause? They always have been on Cygwin. This platform just can't handle that many parallel connections. Previously though that just resulted in a few failed tests - the run always completed. This time I'm seeing it hang at some random point in the tests. The one difference between now and when I've run tests previously is that I'm now running a centrino laptop. I'll see if I can spend some more time on it later, though I have a very large project going live on Monday so finding time might be tricky :-( Regards, Dave. No problem --- the port is already marked as working --- this is a known problem with the parallel tests. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for port reports
On Sun, Oct 26, 2003 at 08:27:10AM -0500, Bruce Momjian wrote: Ports list updated: http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html Should I mention Solaris as 2.6 or 5.6? Normally you speak about Solaris 2.5, 2.6, 7, 8 and 9. Which are also known as SunOS 5.5, 5.6, 5.7, 5.8 and 5.9. Either number will probably. PS: My 2.6/5.6 was on x86 hardware, not on a sparc. Kurt ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for port reports
-Original Message- From: Dave Page Sent: 26 October 2003 17:34 To: Bruce Momjian Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] Call for port reports No problem --- the port is already marked as working --- this is a known problem with the parallel tests. No it's not, that's what I'm saying. Normally the tests finish with a few failures (because Cygwin can't create enough sockets). I'm seeing a full blown hang. OK, cleaned up and rebuilt it looks OK now (well, as OK as it ever does on XP Pro). Regards, Dave. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Call for port reports
Kurt Roeckx wrote: On Sun, Oct 26, 2003 at 08:27:10AM -0500, Bruce Momjian wrote: Ports list updated: http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html Should I mention Solaris as 2.6 or 5.6? Normally you speak about Solaris 2.5, 2.6, 7, 8 and 9. Which are also known as SunOS 5.5, 5.6, 5.7, 5.8 and 5.9. Either number will probably. PS: My 2.6/5.6 was on x86 hardware, not on a sparc. Oh! Thanks. Updated. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Call for port reports / test horology FAILED
Hi together, keep on the nice work! On SuSE 8.0, uname -a Linux dell 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 unknown During compile I got the following warning: gcc -g -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../src/include -D_GNU_SOURCE -c trigger.c -o trigger.o /tmp/ccgcppC9.s: Assembler messages: /tmp/ccgcppC9.s:2014: Warning: using `%si' instead of `%esi' due to `w' suffix /tmp/ccgcppC9.s:2014: Warning: using `%ax' instead of `%eax' due to `w' suffix as -v GNU assembler version 2.11.92.0.10 (i486-suse-linux) using BFD version 2.11.92.0.10 20011021 (SuSE) gcc -v Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) I get the this failure (...something to do with the change to winter time last night?): test horology ... FAILED, diff follows. Bye, Tilo cat src/test/regress/regression.diffs *** ./expected/horology.out Thu Sep 25 08:58:06 2003 --- ./results/horology.out Sun Oct 26 22:54:56 2003 *** *** 583,595 SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as True; True -- ! t (1 row) SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as True; True -- ! t (1 row) SELECT (timestamp with time zone 'tomorrow' 'now') as True; --- 583,595 SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as True; True -- ! f (1 row) SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as True; True -- ! f (1 row) SELECT (timestamp with time zone 'tomorrow' 'now') as True; *** *** 836,842 + interval '02:01' AS time with time zone) AS time) AS 03:31:00; 03:31:00 -- ! 03:31:00 (1 row) SELECT CAST(cast(date 'today' + time with time zone '03:30' --- 836,842 + interval '02:01' AS time with time zone) AS time) AS 03:31:00; 03:31:00 -- ! 02:31:00 (1 row) SELECT CAST(cast(date 'today' + time with time zone '03:30' == *** ./expected/random.out Thu Feb 13 06:24:04 2003 --- ./results/random.outSun Oct 26 22:55:01 2003 *** *** 25,31 GROUP BY random HAVING count(random) 1; random | count +--- ! (0 rows) SELECT random FROM RANDOM_TBL WHERE random NOT BETWEEN 80 AND 120; --- 25,32 GROUP BY random HAVING count(random) 1; random | count +--- ! 113 | 2 ! (1 row) SELECT random FROM RANDOM_TBL WHERE random NOT BETWEEN 80 AND 120; == ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for port reports
- Original Message - From: Dave Page [EMAIL PROTECTED] To: Bruce Momjian [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, October 26, 2003 3:22 PM Subject: Re: [HACKERS] Call for port reports -Original Message- From: Dave Page Sent: 26 October 2003 17:34 To: Bruce Momjian Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] Call for port reports No problem --- the port is already marked as working --- this is a known problem with the parallel tests. No it's not, that's what I'm saying. Normally the tests finish with a few failures (because Cygwin can't create enough sockets). I'm seeing a full blown hang. OK, cleaned up and rebuilt it looks OK now (well, as OK as it ever does on XP Pro). I am seeing these hangs consistently (but not always in the same place) on XPHE running on a P4. uname: CYGWIN_NT-5.1 DUNSLANE 1.5.5(0.94/3/2) 2003-09-20 16:31 i686 unknown unknown Cygwin cheers andrew ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports (Win32 Client)
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 26 October 2003 01:35 To: Dave Page Cc: PostgreSQL-development Subject: Re: [HACKERS] Call for port reports NMAKE : fatal error U1077: 'C:\PROGRA~1\MICROS~3\VC98\BIN\NMAKE.EXE' : return co de '0x2' Stop. I am confused why strings.h is being included because there is a test around it: #ifdef HAVE_STRINGS_H #include strings.h #endif Any ideas? Yesh I forgot to remove the cygwin pg_config.h before compiling. Sorry :-) Anyway, I now get the error below which is not surprising as Windows doesn't have pthreads, or pwd.h as standard. Regards, Dave. C:\cygwin\usr\local\src\postgresql-7.4beta5\srcnmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. cd include if not exist pg_config.h copy pg_config.h.win32 pg_config.h cd .. cd interfaces\libpq nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. Building the Win32 static library... cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nma03408. getaddrinfo.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmb03408. inet_aton.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmc03408. crypt.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmd03408. path.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nme03408. dllist.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmf03408. md5.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmg03408. ip.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmh03408. thread.c ..\..\include\utils/elog.h(37) : warning C4005: 'ERROR' : macro redefinition C:\PROGRA~1\MICROS~3\VC98\INCLUDE\wingdi.h(93) : see previous definition of 'ERROR' ..\..\port\thread.c(17) : fatal error C1083: Cannot open include file: 'pthread. h': No such file or directory NMAKE : fatal error U1077: 'cl.exe' : return code '0x2' Stop. NMAKE : fatal error U1077: 'C:\PROGRA~1\MICROS~3\VC98\BIN\NMAKE.EXE' : return co de '0x2' Stop. C:\cygwin\usr\local\src\postgresql-7.4beta5\src ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for port reports
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 26 October 2003 13:29 To: Dave Page Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] Call for port reports Previously though that just resulted in a few failed tests - the run always completed. This time I'm seeing it hang at some random point in the tests. The one difference between now and when I've run tests previously is that I'm now running a centrino laptop. I'll see if I can spend some more time on it later, though I have a very large project going live on Monday so finding time might be tricky :-( Regards, Dave. No problem --- the port is already marked as working --- this is a known problem with the parallel tests. No it's not, that's what I'm saying. Normally the tests finish with a few failures (because Cygwin can't create enough sockets). I'm seeing a full blown hang. Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Call for port reports
Dave Page wrote: -Original Message- From: Dave Page Sent: 26 October 2003 17:34 To: Bruce Momjian Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [HACKERS] Call for port reports No problem --- the port is already marked as working --- this is a known problem with the parallel tests. No it's not, that's what I'm saying. Normally the tests finish with a few failures (because Cygwin can't create enough sockets). I'm seeing a full blown hang. OK, cleaned up and rebuilt it looks OK now (well, as OK as it ever does on XP Pro). OK, thanks. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports (Win32 Client)
This is all fixed in CVS --- would you try that? --- Dave Page wrote: -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 26 October 2003 01:35 To: Dave Page Cc: PostgreSQL-development Subject: Re: [HACKERS] Call for port reports NMAKE : fatal error U1077: 'C:\PROGRA~1\MICROS~3\VC98\BIN\NMAKE.EXE' : return co de '0x2' Stop. I am confused why strings.h is being included because there is a test around it: #ifdef HAVE_STRINGS_H #include strings.h #endif Any ideas? Yesh I forgot to remove the cygwin pg_config.h before compiling. Sorry :-) Anyway, I now get the error below which is not surprising as Windows doesn't have pthreads, or pwd.h as standard. Regards, Dave. C:\cygwin\usr\local\src\postgresql-7.4beta5\srcnmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. cd include if not exist pg_config.h copy pg_config.h.win32 pg_config.h cd .. cd interfaces\libpq nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. Building the Win32 static library... cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nma03408. getaddrinfo.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmb03408. inet_aton.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmc03408. crypt.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmd03408. path.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nme03408. dllist.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmf03408. md5.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmg03408. ip.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmh03408. thread.c ..\..\include\utils/elog.h(37) : warning C4005: 'ERROR' : macro redefinition C:\PROGRA~1\MICROS~3\VC98\INCLUDE\wingdi.h(93) : see previous definition of 'ERROR' ..\..\port\thread.c(17) : fatal error C1083: Cannot open include file: 'pthread. h': No such file or directory NMAKE : fatal error U1077: 'cl.exe' : return code '0x2' Stop. NMAKE : fatal error U1077: 'C:\PROGRA~1\MICROS~3\VC98\BIN\NMAKE.EXE' : return co de '0x2' Stop. C:\cygwin\usr\local\src\postgresql-7.4beta5\src ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Call for port reports / test horology FAILED
Tilo Schwarz wrote: Hi together, keep on the nice work! On SuSE 8.0, uname -a Linux dell 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 unknown During compile I got the following warning: gcc -g -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../src/include -D_GNU_SOURCE -c trigger.c -o trigger.o /tmp/ccgcppC9.s: Assembler messages: /tmp/ccgcppC9.s:2014: Warning: using `%si' instead of `%esi' due to `w' suffix /tmp/ccgcppC9.s:2014: Warning: using `%ax' instead of `%eax' due to `w' suffix as -v GNU assembler version 2.11.92.0.10 (i486-suse-linux) using BFD version 2.11.92.0.10 20011021 (SuSE) gcc -v Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Yes, I see that with the exact same version of gcc, but it seems to still run fine. I get the this failure (...something to do with the change to winter time last night?): test horology ... FAILED, diff follows. Yes, this is caused by the daylight savings time change --- it will be OK tomorrow. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for port reports
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 24 October 2003 16:38 To: PostgreSQL-development Subject: [HACKERS] Call for port reports It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. Cygwin == Parallel regression tests do not complete (we normally have problems with these anyway, though they do normally complete). Serial tests pass. CYGWIN_NT-5.1 pc30 1.5.5(0.94/3/2) 2003-09-20 16:31 i686 unknown unknown Cygwin Win32 Client (Windows XP Pro, VC++ 6.0) C:\cygwin\usr\local\src\postgresql-7.4beta5\srcnmake /f win32.mak ALL Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. cd include if not exist pg_config.h copy pg_config.h.win32 pg_config.h cd .. cd interfaces\libpq nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. Building the Win32 static library... cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nma02744. getaddrinfo.c ..\..\include\c.h(66) : fatal error C1083: Cannot open include file: 'strings.h' : No such file or directory NMAKE : fatal error U1077: 'cl.exe' : return code '0x2' Stop. NMAKE : fatal error U1077: 'C:\PROGRA~1\MICROS~3\VC98\BIN\NMAKE.EXE' : return co de '0x2' Stop. Regards, Dave. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for port reports
Bruce Momjian writes: BUT: The default CFLAGS are set by configure to -O2, although the template wants -O. I manually modified the CFLAGS to -O after configure. template/alpha has: case $host_cpu in alpha*) CFLAGS=$CFLAGS -O;; # alpha has problems with -O2 esac Is this not getting invoked? After further consideration, I think that the recent patch series that tried to centralize the CFLAGS handling in configure should be reverted to configure.in revision 1.293. Otherwise, it's much to complicated to handle all the special cases. There is, after all, a reason we have been forced to keep it this way all these years. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Call for port reports
Am Sa, den 25.10.2003 schrieb Nol Kthe um 01:17: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. The current list is at: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html here are some build reports. Its all on Debian GNU/Linux with different architectures: == All 93 tests passed. == rm regress.o make[2]: Leaving directory `/home/noel/pgsql/src/test/regress' make[1]: Leaving directory `/home/noel/pgsql/src/test' [EMAIL PROTECTED]:~/pgsql$ uname -a Linux pergolesi 2.4.22 #1 SMP Mon Aug 25 20:56:25 CEST 2003 i686 GNU/Linux It says i686 but its AMD Opteron: [EMAIL PROTECTED]:~/pgsql$ cat /proc/cpuinfo |more processor : 0 vendor_id : AuthenticAMD cpu family : 15 model : 5 model name : AMD Opteron(tm) Processor 240 stepping: 1 cpu MHz : 1394.299 cache size : 1024 KB ... -- Nol Kthe noel debian.org Debian GNU/Linux, www.debian.org signature.asc Description: Dies ist ein digital signierter Nachrichtenteil
Re: [HACKERS] Call for port reports
On Fri, Oct 24, 2003 at 11:37:32AM -0400, Bruce Momjian wrote: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. checking build system type... i386-pc-solaris2.6 checking host system type... i386-pc-solaris2.6 checking which template to use... solaris [...] checking for gcc... gcc checking for C compiler default output... a.out checking whether the C compiler works... yes [...] checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes configure: using CFLAGS=-g -O2 -fno-strict-aliasing checking whether the C compiler still works... no configure: error: cannot proceed oink% gcc -v Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.6/2.8.1/specs gcc version 2.8.1 CFLAGS=-g -O2 ./configure --without-readline [...] == All 93 tests passed. == Kurt ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Call for port reports
On Sat, Oct 25, 2003 at 01:03:37PM +0200, Noèl Köthe wrote: [EMAIL PROTECTED]:~/pgsql$ uname -a Linux pergolesi 2.4.22 #1 SMP Mon Aug 25 20:56:25 CEST 2003 i686 GNU/Linux It says i686 but its AMD Opteron: Just wondering, but does it run in 32 or 64 bit mode? I have a feeling it's only 32 bit mode ... Is it compiled for the i386 or the x86_64 arch? Did you have CONFIG_X86_64=y as compile time option? Kurt ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Call for port reports
Am Sa, den 25.10.2003 schrieb Kurt Roeckx um 13:48: Linux pergolesi 2.4.22 #1 SMP Mon Aug 25 20:56:25 CEST 2003 i686 GNU/Linux It says i686 but its AMD Opteron: Just wondering, but does it run in 32 or 64 bit mode? I have a feeling it's only 32 bit mode ... Is it compiled for the i386 or the x86_64 arch? Did you have CONFIG_X86_64=y as compile time option? Yes, you are right. Its only 32bit (kernel and userland). The Debian amd64 port team is still working on 64bit packages. -- Nol Kthe noel debian.org Debian GNU/Linux, www.debian.org signature.asc Description: Dies ist ein digital signierter Nachrichtenteil
Re: [HACKERS] Call for port reports
Peter Eisentraut wrote: Bruce Momjian writes: BUT: The default CFLAGS are set by configure to -O2, although the template wants -O. I manually modified the CFLAGS to -O after configure. template/alpha has: case $host_cpu in alpha*) CFLAGS=$CFLAGS -O;; # alpha has problems with -O2 esac Is this not getting invoked? After further consideration, I think that the recent patch series that tried to centralize the CFLAGS handling in configure should be reverted to configure.in revision 1.293. Otherwise, it's much to complicated to handle all the special cases. There is, after all, a reason we have been forced to keep it this way all these years. Remember the old code had CFLAGS= in lots of platforms, meaning they got no optimization. It seems right now Alpha is our only problem, and it is really just a message problem because the later flags override the earlier ones. Why can't get just remove -O2 from the alpha CFLAGS line via makefile magic? Frankly, we could just do CFLAGS=-O and be done with it because we would not be bringing in the -O2, but I would rather keep it clean and remove just -O2. I don't think going backwards is a good solution because it spreads the problem down to the templates again. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for port reports
--On Saturday, October 25, 2003 10:00:59 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: Peter Eisentraut wrote: Bruce Momjian writes: BUT: The default CFLAGS are set by configure to -O2, although the template wants -O. I manually modified the CFLAGS to -O after configure. template/alpha has: case $host_cpu in alpha*) CFLAGS=$CFLAGS -O;; # alpha has problems with -O2 esac Is this not getting invoked? After further consideration, I think that the recent patch series that tried to centralize the CFLAGS handling in configure should be reverted to configure.in revision 1.293. Otherwise, it's much to complicated to handle all the special cases. There is, after all, a reason we have been forced to keep it this way all these years. Remember the old code had CFLAGS= in lots of platforms, meaning they got no optimization. It seems right now Alpha is our only problem, and it is really just a message problem because the later flags override the earlier ones. Why can't get just remove -O2 from the alpha CFLAGS line via makefile magic? Frankly, we could just do CFLAGS=-O and be done with it because we would not be bringing in the -O2, but I would rather keep it clean and remove just -O2. We also get -g on UnixWare cc (NOT gcc) builds, which we didn't before, which means we do NOT get optimization (UnixWare's cc doesn't like -O and -g together). LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 pgp0.pgp Description: PGP signature
Re: [HACKERS] Call for port reports
Bruce Momjian wrote: Peter Eisentraut wrote: Bruce Momjian writes: BUT: The default CFLAGS are set by configure to -O2, although the template wants -O. I manually modified the CFLAGS to -O after configure. template/alpha has: case $host_cpu in alpha*) CFLAGS=$CFLAGS -O;; # alpha has problems with -O2 esac Is this not getting invoked? After further consideration, I think that the recent patch series that tried to centralize the CFLAGS handling in configure should be reverted to configure.in revision 1.293. Otherwise, it's much to complicated to handle all the special cases. There is, after all, a reason we have been forced to keep it this way all these years. Remember the old code had CFLAGS= in lots of platforms, meaning they got no optimization. It seems right now Alpha is our only problem, and it is really just a message problem because the later flags override the earlier ones. Why can't get just remove -O2 from the alpha CFLAGS line via makefile magic? Frankly, we could just do CFLAGS=-O and be done with it because we would not be bringing in the -O2, but I would rather keep it clean and remove just -O2. I don't think going backwards is a good solution because it spreads the problem down to the templates again. In fact, another question is why this alpha test is only done in freebsd? Certainly other alpha gcc platforms must have problems with -O2? I am inclined to add something to configure.in for all alpha compiles that changes -O2 to -O. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Call for port reports
Larry Rosenman wrote: After further consideration, I think that the recent patch series that tried to centralize the CFLAGS handling in configure should be reverted to configure.in revision 1.293. Otherwise, it's much to complicated to handle all the special cases. There is, after all, a reason we have been forced to keep it this way all these years. Remember the old code had CFLAGS= in lots of platforms, meaning they got no optimization. It seems right now Alpha is our only problem, and it is really just a message problem because the later flags override the earlier ones. Why can't get just remove -O2 from the alpha CFLAGS line via makefile magic? Frankly, we could just do CFLAGS=-O and be done with it because we would not be bringing in the -O2, but I would rather keep it clean and remove just -O2. We also get -g on UnixWare cc (NOT gcc) builds, which we didn't before, which means we do NOT get optimization (UnixWare's cc doesn't like -O and -g together). We are going to fix that, but what happens? Does the compile fail or does optimization just get turned off? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Call for port reports
Bruce Momjian writes: In fact, another question is why this alpha test is only done in freebsd? Ask that to the maintainers of the FreeBSD system compiler. Certainly other alpha gcc platforms must have problems with -O2? I am inclined to add something to configure.in for all alpha compiles that changes -O2 to -O. I'm not. It's one thing if FreeBSD thinks their compiler is broken. But before I accept that gcc is broken as a whole, I want to hear from the GCC folks. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Call for port reports
--On Saturday, October 25, 2003 10:14:14 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: Larry Rosenman wrote: After further consideration, I think that the recent patch series that tried to centralize the CFLAGS handling in configure should be reverted to configure.in revision 1.293. Otherwise, it's much to complicated to handle all the special cases. There is, after all, a reason we have been forced to keep it this way all these years. Remember the old code had CFLAGS= in lots of platforms, meaning they got no optimization. It seems right now Alpha is our only problem, and it is really just a message problem because the later flags override the earlier ones. Why can't get just remove -O2 from the alpha CFLAGS line via makefile magic? Frankly, we could just do CFLAGS=-O and be done with it because we would not be bringing in the -O2, but I would rather keep it clean and remove just -O2. We also get -g on UnixWare cc (NOT gcc) builds, which we didn't before, which means we do NOT get optimization (UnixWare's cc doesn't like -O and -g together). We are going to fix that, but what happens? Does the compile fail or does optimization just get turned off? just a warning on each compile and no optimization. LER -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 pgp0.pgp Description: PGP signature
Re: [HACKERS] Call for port reports
Peter Eisentraut wrote: Bruce Momjian writes: In fact, another question is why this alpha test is only done in freebsd? Ask that to the maintainers of the FreeBSD system compiler. Certainly other alpha gcc platforms must have problems with -O2? I am inclined to add something to configure.in for all alpha compiles that changes -O2 to -O. I'm not. It's one thing if FreeBSD thinks their compiler is broken. But before I accept that gcc is broken as a whole, I want to hear from the GCC folks. Oh, so it is only FreeBSD that emits that warning. Interesting. I haven't seen that error from any other platform, so you must be right. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Call for port reports
Peter Eisentraut wrote: Bruce Momjian writes: In fact, another question is why this alpha test is only done in freebsd? Ask that to the maintainers of the FreeBSD system compiler. Certainly other alpha gcc platforms must have problems with -O2? I am inclined to add something to configure.in for all alpha compiles that changes -O2 to -O. I'm not. It's one thing if FreeBSD thinks their compiler is broken. But before I accept that gcc is broken as a whole, I want to hear from the GCC folks. How does everyone like this patch? It removes -g from non-debug compiles, and changes -O2 to -O for FreeBSD/Alpha. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 Index: configure === RCS file: /cvsroot/pgsql-server/configure,v retrieving revision 1.306 diff -c -c -r1.306 configure *** configure 22 Oct 2003 04:16:27 - 1.306 --- configure 25 Oct 2003 15:44:00 - *** *** 2384,2389 --- 2384,2392 ac_compiler_gnu=$ac_cv_c_compiler_gnu + # Strip off -g added by autoconf + CFLAGS=`echo \$CFLAGS\ | sed 's/\( *\)-g\( *\)/\1\2/'` + # # Read the template # Index: configure.in === RCS file: /cvsroot/pgsql-server/configure.in,v retrieving revision 1.297 diff -c -c -r1.297 configure.in *** configure.in22 Oct 2003 04:16:39 - 1.297 --- configure.in25 Oct 2003 15:44:03 - *** *** 229,234 --- 229,237 AC_PROG_CC([$pgac_cc_list]) + # Strip off -g added by autoconf + CFLAGS=`echo \$CFLAGS\ | sed 's/\( *\)-g\( *\)/\1\2/'` + # # Read the template # Index: src/template/freebsd === RCS file: /cvsroot/pgsql-server/src/template/freebsd,v retrieving revision 1.27 diff -c -c -r1.27 freebsd *** src/template/freebsd9 Oct 2003 22:55:46 - 1.27 --- src/template/freebsd25 Oct 2003 15:44:09 - *** *** 1,6 ! case $host_cpu in ! alpha*) CFLAGS=$CFLAGS -O;; # alpha has problems with -O2 ! esac THREAD_SUPPORT=yes NEED_REENTRANT_FUNCS=yes --- 1,10 ! # alpha has problems with -O2 ! # is FreeBSD/Alpha the only gcc Alpha that can't handle -O2? ! if test $GCC = yes; then ! case $host_cpu in ! alpha*) CFLAGS=`echo \$CFLAGS\ | sed 's/\( *\)-O2\( *\)/\1-O\2/'` ;; ! esac ! fi THREAD_SUPPORT=yes NEED_REENTRANT_FUNCS=yes ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Call for port reports
Peter Eisentraut writes: FreeBSD 4.8-RELEASE alpha BUT: The default CFLAGS are set by configure to -O2, although the template wants -O. I manually modified the CFLAGS to -O after configure. I've committed a fix for the CFLAGS handling, and now this platform works perfectly. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Call for port reports
--On Saturday, October 25, 2003 18:35:06 +0200 Peter Eisentraut [EMAIL PROTECTED] wrote: Peter Eisentraut writes: FreeBSD 4.8-RELEASE alpha BUT: The default CFLAGS are set by configure to -O2, although the template wants -O. I manually modified the CFLAGS to -O after configure. I've committed a fix for the CFLAGS handling, and now this platform works perfectly. That commit also fixed my -g issue with UnixWare. I still have the following regression.diffs: *** ./expected/privileges.out Thu Oct 9 20:49:31 2003 --- ./results/privileges.outSat Oct 25 12:04:45 2003 *** *** 247,253 (1 row) CREATE FUNCTION testfunc3(int) RETURNS int AS 'select 2 * $1;' LANGUAGE sql; -- fail - ERROR: permission denied for language sql SET SESSION AUTHORIZATION regressuser3; SELECT testfunc1(5); -- fail ERROR: permission denied for function testfunc1 --- 247,252 == -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 pgp0.pgp Description: PGP signature
Re: [HACKERS] Call for port reports
Regression testing on AIX 5 using 7.4beta5: polymorphism ... ok stats... ok == shutting down postmaster == == All 93 tests passed. == bash-2.05$ uname -a AIX sn2 1 5 0044276A4C00 checking build system type... powerpc-ibm-aix5.1.0.0 checking host system type... powerpc-ibm-aix5.1.0.0 checking which template to use... aix bash-2.05$ gcc -v Reading specs from /usr/bin/../lib/gcc-lib/powerpc-ibm-aix5.1.0.0/2.9-aix43-010414/specs gcc version 2.9-aix43-010414 Good work :) Hans -- Cybertec Geschwinde u Schoenig Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria Tel: +43/2952/30706 or +43/660/816 40 77 www.cybertec.at, www.postgresql.at, kernel.cybertec.at ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports
It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. The current list is at: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html here are some build reports. Its all on Debian GNU/Linux with different architectures: == All 93 tests passed. == rm regress.o make[2]: Leaving directory `/home/noel/pgsql/src/test/regress' make[1]: Leaving directory `/home/noel/pgsql/src/test' [EMAIL PROTECTED]:~/pgsql$ uname -a Linux bruckner 2.4.21 #1 Don Aug 28 15:18:52 CEST 2003 ppc GNU/Linux - In file included from ../../../../src/include/storage/spin.h:50, from xlog.c:37: ../../../../src/include/storage/s_lock.h:543:2: #error This platform does not support native spinlocks. To continue the compile, rerun configure using --disable-spinlocks. However, performance will be poor. Please report this to [EMAIL PROTECTED] make[4]: *** [xlog.o] Error 1 make[4]: Leaving directory `/home/noel/pgsql/src/backend/access/transam' make[3]: *** [transam-recursive] Error 2 make[3]: Leaving directory `/home/noel/pgsql/src/backend/access' make[2]: *** [access-recursive] Error 2 make[2]: Leaving directory `/home/noel/pgsql/src/backend' make[1]: *** [all] Error 2 make[1]: Leaving directory `/home/noel/pgsql/src' make: *** [all] Error 2 [EMAIL PROTECTED]:~/pgsql$ uname -a Linux paer 2.4.20-64 #1 Fri Aug 1 23:40:10 UTC 2003 parisc64 GNU/Linux rebuild with --disable-spinlocks ... transactions ... ok random ... failed (ignored) portals ... ok ... == 92 of 93 tests passed, 1 failed test(s) ignored. == The differences that caused some tests to fail can be viewed in the file `./regression.diffs'. A copy of the test summary that you see above is saved in the file `./regression.out'. rm regress.o make[2]: Leaving directory `/home/noel/pgsql/src/test/regress' make[1]: Leaving directory `/home/noel/pgsql/src/test' [EMAIL PROTECTED]:~/pgsql$ uname -a Linux paer 2.4.20-64 #1 Fri Aug 1 23:40:10 UTC 2003 parisc64 GNU/Linux this is regression.diffs: *** ./expected/random.out Thu Feb 13 05:24:04 2003 --- ./results/random.outFri Oct 24 22:19:29 2003 *** *** 31,35 WHERE random NOT BETWEEN 80 AND 120; random ! (0 rows) --- 31,36 WHERE random NOT BETWEEN 80 AND 120; random ! 122 ! (1 row) --- == All 93 tests passed. == rm regress.o make[2]: Leaving directory `/home/noel/postgresql-cvs/pgsql/src/test/regress' make[1]: Leaving directory `/home/noel/postgresql-cvs/pgsql/src/test' (sid)[EMAIL PROTECTED]:~/postgresql-cvs/pgsql$ uname -a Linux debussy 2.4.19-netwinder #1 Thu Mar 20 03:14:34 CET 2003 armv4l GNU/Linux -- == All 93 tests passed. == rm regress.o make[2]: Leaving directory `/home/noel/pgsql/src/test/regress' make[1]: Leaving directory `/home/noel/pgsql/src/test' [EMAIL PROTECTED]:~/pgsql$ uname -a Linux merulo 2.4.18-itanium-smp #1 SMP Sat Nov 23 01:39:07 MST 2002 ia64 GNU/Linux ... transactions ... ok random ... failed (ignored) portals ... ok ... == 92 of 93 tests passed, 1 failed test(s) ignored. == The differences that caused some tests to fail can be viewed in the file `./regression.diffs'. A copy of the test summary that you see above is saved in the file `./regression.out'. rm regress.o make[2]: Leaving directory `/home/noel/pgsql/src/test/regress' make[1]: Leaving directory `/home/noel/pgsql/src/test' (unstable)[EMAIL PROTECTED]:~/pgsql$ uname -a Linux raptor 2.4.19 #1 SMP Fri Nov 29 23:53:27 CET 2002 s390 GNU/Linux -- reports of these slower systems will follow but they need a bit more time: Linux casals 2.4.19-r4k-ip22 #1 Tue Mar 18 15:38:10 CET 2003 mips unknown Linux crest 2.4.20 #1 Wed Mar 5 01:39:17 EST 2003 m68k unknown Linux escher 2.4.22 #2 Sat Sep 6 18:23:54 CEST 2003 alpha GNU/Linux -- Nol Kthe noel debian.org Debian GNU/Linux, www.debian.org signature.asc Description: Dies ist ein digital signierter Nachrichtenteil
Re: [HACKERS] Call for port reports
Bruce Momjian writes: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. After the just-committed fix, Tru64 5.1 alpha is OK with both cc and gcc. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Call for port reports
Larry Rosenman writes: *** ./expected/privileges.out Thu Oct 9 20:49:31 2003 --- ./results/privileges.out Sat Oct 25 12:04:45 2003 *** *** 247,253 (1 row) CREATE FUNCTION testfunc3(int) RETURNS int AS 'select 2 * $1;' LANGUAGE sql; -- fail - ERROR: permission denied for language sql SET SESSION AUTHORIZATION regressuser3; SELECT testfunc1(5); -- fail ERROR: permission denied for function testfunc1 --- 247,252 That sounds extremely strange. Can you step through the privileges.sql file manually (psql single-step mode) and check what the contents of pg_language, pg_shadow, current_user, and session_user are before the misbehaving command? -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] Call for port reports
Am Sa, den 25.10.2003 schrieb Nol Kthe um 01:17: reports of these slower systems will follow but they need a bit more time: Linux crest 2.4.20 #1 Wed Mar 5 01:39:17 EST 2003 m68k unknown Peter gave me this patch for m68k: -- src/include/port/linux.h.orig Sat Oct 25 13:45:44 2003 +++ src/include/port/linux.hSat Oct 25 12:21:41 2003 @@ -45,3 +45,8 @@ #endif +#if defined(__mc68000__) +#define HAS_TEST_AND_SET +typedef unsigned char slock_t; +#endif + == All 93 tests passed. == rm regress.o make[2]: Leaving directory `/home/noel/postgresql-cvs/pgsql/src/test/regress' make[1]: Leaving directory `/home/noel/postgresql-cvs/pgsql/src/test' (unstable)[EMAIL PROTECTED]:~/postgresql-cvs/pgsql$ uname -a Linux crest 2.4.20 #1 Wed Mar 5 01:39:17 EST 2003 m68k GNU/Linux Linux escher 2.4.22 #2 Sat Sep 6 18:23:54 CEST 2003 alpha GNU/Linux == All 93 tests passed. == rm regress.o make[2]: Leaving directory `/home/noel/pgsql/src/test/regress' make[1]: Leaving directory `/home/noel/pgsql/src/test' [EMAIL PROTECTED]:~/pgsql$ uname -a Linux escher 2.4.22 #2 Sat Sep 6 18:23:54 CEST 2003 alpha GNU/Linux -- Nol Kthe [EMAIL PROTECTED] Debian GNU/Linux, www.debian.org signature.asc Description: Dies ist ein digital signierter Nachrichtenteil
Re: [HACKERS] Call for port reports
Kurt Roeckx writes: configure: using CFLAGS=-g -O2 -fno-strict-aliasing checking whether the C compiler still works... no configure: error: cannot proceed oink% gcc -v Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.6/2.8.1/specs gcc version 2.8.1 CFLAGS=-g -O2 ./configure --without-readline I've installed a detection logic that finds out whether -fno-strict-aliasing works. Please give it a quick run through, then we check this platform off. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Call for port reports
--On Saturday, October 25, 2003 22:29:04 +0200 Peter Eisentraut [EMAIL PROTECTED] wrote: Larry Rosenman writes: *** ./expected/privileges.out Thu Oct 9 20:49:31 2003 --- ./results/privileges.outSat Oct 25 12:04:45 2003 *** *** 247,253 (1 row) CREATE FUNCTION testfunc3(int) RETURNS int AS 'select 2 * $1;' LANGUAGE sql; -- fail - ERROR: permission denied for language sql SET SESSION AUTHORIZATION regressuser3; SELECT testfunc1(5); -- fail ERROR: permission denied for function testfunc1 --- 247,252 That sounds extremely strange. Can you step through the privileges.sql file manually (psql single-step mode) and check what the contents of pg_language, pg_shadow, current_user, and session_user are before the misbehaving command? -- Peter Eisentraut [EMAIL PROTECTED] here ya go: Script started on Sat Oct 25 16:34:24 2003 $ psql -s reg? ?? ?? ?-U p? ?ler regression Welcome to psql 7.4beta5, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit regression=# \i privileges.sql ***(Single step mode: verify command)*** CREATE USER regressuser1; ***(press return to proceed or enter x and return to cancel) psql:privileges.sql:5: ERROR: user regressuser1 already exists ***(Single step mode: verify command)*** CREATE USER regressuser2; ***(press return to proceed or enter x and return to cancel) psql:privileges.sql:6: ERROR: user regressuser2 already exists ***(Single step mode: verify command)*** CREATE USER regressuser3; ***(press return to proceed or enter x and return to cancel) psql:privileges.sql:7: ERROR: user regressuser3 already exists ***(Single step mode: verify command)*** CREATE USER regressuser4; ***(press return to proceed or enter x and return to cancel) psql:privileges.sql:8: ERROR: user regressuser4 already exists ***(Single step mode: verify command)*** CREATE USER regressuser4; ***(press return to proceed or enter x and return to cancel) psql:privileges.sql:9: ERROR: user regressuser4 already exists ***(Single step mode: verify command)*** CREATE GROUP regressgroup1; ***(press return to proceed or enter x and return to cancel) psql:privileges.sql:11: ERROR: group regressgroup1 already exists ***(Single step mode: verify command)*** CREATE GROUP regressgroup2 WITH USER regressuser1, regressuser2; ***(press return to proceed or enter x and return to cancel) psql:privileges.sql:12: ERROR: group regressgroup2 already exists ***(Single step mode: verify command)*** ALTER GROUP regressgroup1 ADD USER regressuser4; ***(press return to proceed or enter x and return to cancel) ALTER GROUP ***(Single step mode: verify command)*** ALTER GROUP regressgroup2 ADD USER regressuser2; ***(press return to proceed or enter x and return to cancel) ALTER GROUP ***(Single step mode: verify command)*** ALTER GROUP regressgroup2 DROP USER regressuser2; ***(press return to proceed or enter x and return to cancel) ALTER GROUP ***(Single step mode: verify command)*** ALTER GROUP regressgroup2 ADD USER regressuser4; ***(press return to proceed or enter x and return to cancel) ALTER GROUP ***(Single step mode: verify command)*** SET SESSION AUTHORIZATION regressuser1; ***(press return to proceed or enter x and return to cancel) SET ***(Single step mode: verify command)*** SELECT session_user, current_user; ***(press return to proceed or enter x and return to cancel) session_user | current_user --+-- regressuser1 | regressuser1 (1 row) ***(Single step mode: verify command)*** CREATE TABLE atest1 ( a int, b text ); ***(press return to proceed or enter x and return to cancel) psql:privileges.sql:26: ERROR: relation atest1 already exists ***(Single step mode: verify command)*** SELECT * FROM atest1; ***(press return to proceed or enter x and return to cancel) a | b ---+- 1 | two 1 | two (2 rows) ***(Single step mode: verify
Re: [HACKERS] Call for port reports
On 24-okt-03, at 17:37, Bruce Momjian wrote: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. The current list is at: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported- platforms.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) I had trouble compiling postgressrc/pgsql/src/interfaces/ecpg/ecpglib and compiling pgsql/src/interfaces/ecpg/compatlib. Reason was I had asked during configure to include krb5 support. After adding the -lkrb5 flag to the Makefile in these subdirectories, everyting went fine. My configure options: export JAVA_HOME=/usr export PATH=/usr/local/bin:$PATH:/Developer/Java/J2EE/apache-ant-1.5.3/bin ./configure --bindir=/usr/local/bin --mandir=/usr/local/share/man/ --enable-recode --enable-odbc --enable-syslog --enable-unicode-conversion --enable-multibyte --with-CXX --enable-python --with-java --with-krb5=/usr --with-rendezvous --with-openssl=/usr/include/openssl uname -a: Darwin albatros.nest.nl 7.0.0 Darwin Kernel Version 7.0.0: Wed Sep 24 15:48:39 PDT 2003; root:xnu/xnu-517.obj~1/RELEASE_PPC Power Macintosh powerpc -johan Johan Henselmans http://www.netsense.nl Tel: +31-20-6267538 Fax: +31-20-6273852 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Call for port reports
Bruce Momjian wrote: How does everyone like this patch? It removes -g from non-debug compiles, and changes -O2 to -O for FreeBSD/Alpha. I'd be hesitant to remove -g from non-debug compiles. If something crashes, it's useful to be able to get a good stacktrace from the resulting core file. The -g option makes that possible for optimized code when compiling with gcc. Is there any way we can have configure put -g in when it detects gcc? -- Kevin Brown [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] Call for port reports
Peter Eisentraut wrote: Kurt Roeckx writes: configure: using CFLAGS=-g -O2 -fno-strict-aliasing checking whether the C compiler still works... no configure: error: cannot proceed oink% gcc -v Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.6/2.8.1/specs gcc version 2.8.1 CFLAGS=-g -O2 ./configure --without-readline I've installed a detection logic that finds out whether -fno-strict-aliasing works. Please give it a quick run through, then we check this platform off. I thought we'd have to do this in the end, although that is quite an old version of gcc! cheers andrew ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Call for port reports
After CVS update for optimization flags: Ports list updated: http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html --- Peter Eisentraut wrote: Bruce Momjian writes: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. This one is OK: FreeBSD 4.8-RELEASE alpha BUT: The default CFLAGS are set by configure to -O2, although the template wants -O. I manually modified the CFLAGS to -O after configure. -- Peter Eisentraut [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Call for port reports
Ports list updated: http://momjian.postgresql.org/main/writings/pgsql/sgml/supported-platforms.html --- Peter Eisentraut wrote: Bruce Momjian writes: It is time for people to report their port testing. Please test against current CVS or beta5 and report your 'uname -a'. This one is OK after the recent pthread.h patch: NetBSD 1.6 (GENERIC) i386 However, the compile pointed out that in src/interfaces/libpq/fe-auth.c line 472, variable cmsg is unused; and indeed it seems to be right. Bruce, you worked most often on the peer authentication code, so maybe you can check that. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
