Thread: Porting/platforms/buildfarm open issues
First, we still do not have any test with 8.0 on the following platforms: HP-UX IRIX Tru64 UNIX SCO OpenServer Second, we have regressions (vs. 7.4) on the following platforms: Linux Alpha (buildfarm hare) Linux ARM (see http://archives.postgresql.org/pgsql-hackers/2005-01/msg00094.php) Other open targets can be found here: http://developer.postgresql.org/docs/postgres/supported-platforms.html but those were the most important ones. -- Peter Eisentraut http://developer.postgresql.org/~petere/
On Thursday 06 Jan 2005 3:52 pm, Peter Eisentraut wrote: > First, we still do not have any test with 8.0 on the following platforms: > > HP-UX All the 96 tests are passed on RC3. I can rerun the tests with additional configure flags if required..But I can not install anything new on HP-UX machine. $ ./configure --without-readline --without-zlib;gmake;gmake check $ uname -a HP-UX machine B.11.00 A 9000/785 2005950738 two-user license FWIW, I also ran on my Linux machine. It passes there as well.. $ ./configure;make;make check $ uname -a Linux machine 2.6.7 #1 Wed Jun 16 16:23:03 PDT 2004 i686 unknown unknown GNU/Linux $ cat /etc/slackware-version Slackware 10.0.0 Shridhar
Hello. From: Peter Eisentraut <peter_e@gmx.net> Subject: [HACKERS] Porting/platforms/buildfarm open issues Date: Thu, 6 Jan 2005 11:22:56 +0100 > Tru64 UNIX I tried RC3 on Tru64 box with cc(Compaq C V6.1-011). There are some errors to build and install. All tests (make installcheck) are passed. bash-2.05b$ uname -a OSF1 kiss.my.domain V5.0 910 alpha bash-2.05b$ make installcheck ... ======================All 96 tests passed. ====================== Error Reports: (Sorry for my poor English.) 1) configure? I got below error when simply configure and make: /usr/bin/ld -shared -expect_unresolved '*' fe-auth.o fe-connect.o fe-exec.ofe-misc.o fe-print.o fe-lobj.o fe-protocol2.o fe-protocol3.o pqexpbuffer.o pqsignal.o fe-secure.o md5.o ip.o wchar.oencnames.o noblock.o pgstrcasecmp.o thread.o getaddrinfo.o -L../../../src/port -lresolv -Wl,-rpath -Wl,/usr/local/pgsql/lib-o libpq.so.3.2 /usr/bin/ld: Invalid flag usage: Wl,-rpath, -Wx,-option must appear after -_SYSTYPE_SVR4/usr/bin/ld: Usage: /usr/bin/ld [options] file [...] make[3]: *** [libpq.so.3.2] Error 1 In Makefile.osf, rpath are defined as 'rpath = -Wl,-rpath -Wl,$(rpathdir)'. But, Makefile.global were set LD to /usr/bin/ld by configure script: bash-2.05b$ grep "LD " Makefile.global LD = /usr/bin/ld So, I need a patch to build: bash-2.05b$ diff Makefile.osf.DIST Makefile.osf 4c4 < rpath = -Wl,-rpath -Wl,$(rpathdir) --- > rpath = -rpath $(rpathdir) (Because LDREL=-r is fixed in Makefile.global.in and cc command can not pass "-r"flag to linker, I did not set LD environmentvriable to "/usr/bin/cc".) I believe that it will be no problem if I had used gcc. 2) mkdir? Due to odd behavior of 'mkdir -p' command, I got below error when 'make install': mkdir -p -- /usr/local/pgsql/bin /usr/local/pgsql/sharemkdir: cannot create /usr/local/pgsql/share. /usr/local/pgsql/share: File exists make[2]: *** [installdirs]Error 2 So, i needed patches below: bash-2.05b$ diff include/Makefile.DIST include/Makefile 21c21 < nodes optimizer parser port regex rewrite storage tcop utils \ --- > nodes optimizer parser regex rewrite storage tcop utils \ (port directory were specified twice.) bash-2.05b$ diff backend/Makefile.DIST backend/Makefile 184c184 < $(mkinstalldirs) $(DESTDIR)$(bindir) $(DESTDIR)$(datadir) --- > $(mkinstalldirs) $(DESTDIR)$(datadir) $(DESTDIR)$(bindir) (The mkdir command(of OS standard) fail if there are no-existing directory in middle of paths of the argument. For example, bash-2.05b$ mkdir abc --- success.bash-2.05b$ mkdir -p abc abc2 --- success. the last 'abc2' don't exist.bash-2.05b$ mkdir -p abc3 abc abc2 --- failure. the first 'abc3' don't existmkdir: cannot create abc.abc: File existsbash-2.05b$ mkdir -p abc5 abc5 --- failuer. both of 'abc5' don't existmkdir:cannot create abc5.abc5: File exists ) regards, -- Shigehiro Honda
Shridhar Daithankar <ghodechhap@ghodechhap.net> writes:
> On Thursday 06 Jan 2005 3:52 pm, Peter Eisentraut wrote:
>> First, we still do not have any test with 8.0 on the following platforms:
>>
>> HP-UX
> All the 96 tests are passed on RC3. I can rerun the tests with additional
> configure flags if required..But I can not install anything new on HP-UX
> machine.
> $ ./configure --without-readline --without-zlib;gmake;gmake check
> $ uname -a
> HP-UX machine B.11.00 A 9000/785 2005950738 two-user license
I can assure you it works on 10.20 as well ;-)
$ uname -a
HP-UX sss2 B.10.20 C 9000/780 2004473515 32-user license
I have done port testing using both gcc and vendor's cc on HPUX 11.11
(PA-RISC) and 11.23 (Itanium) at HP's testdrive farm. The last time was
a month or two back, so it's possible that something broke since then,
but it seems highly unlikely. It's also been a month or two since I
last tried vendor's cc on 10.20, but I doubt that broke either.
regards, tom lane
Peter Eisentraut wrote: > >Second, we have regressions (vs. 7.4) on the following platforms: > >Linux Alpha (buildfarm hare) > > > This was apparently an old Alpha chip, and Jim was going to try on a more modern machine not known to have FP problems. So take this result with many grains of salt. cheers andrew
Honda Shigehiro <fwif0083@mb.infoweb.ne.jp> writes:
> So, I need a patch to build:
> bash-2.05b$ diff Makefile.osf.DIST Makefile.osf
> 4c4
> < rpath = -Wl,-rpath -Wl,$(rpathdir)
> ---
> > rpath = -rpath $(rpathdir)
OK; this simply reverts a cosmetic change I made awhile ago. Evidently
that wasn't a good idea on all platforms after all :-(
> Due to odd behavior of 'mkdir -p' command, I got below error when 'make install':
> mkdir -p -- /usr/local/pgsql/bin /usr/local/pgsql/share
> mkdir: cannot create /usr/local/pgsql/share.
I think you ought to report this as a bug in the local version of mkdir.
> bash-2.05b$ diff backend/Makefile.DIST backend/Makefile
> 184c184
> < $(mkinstalldirs) $(DESTDIR)$(bindir) $(DESTDIR)$(datadir)
> ---
> > $(mkinstalldirs) $(DESTDIR)$(datadir) $(DESTDIR)$(bindir)
I'm not following the point of this change?
regards, tom lane
Am Donnerstag, 6. Januar 2005 16:30 schrieb Honda Shigehiro: > 2) mkdir? > Due to odd behavior of 'mkdir -p' command, I got below error when 'make > install': mkdir -p -- /usr/local/pgsql/bin /usr/local/pgsql/share > mkdir: cannot create /usr/local/pgsql/share. > /usr/local/pgsql/share: File exists > make[2]: *** [installdirs] Error 2 Would you place the attached version of mkinstalldirs in the config/ directory in the PostgreSQL source tree and try installing again? (Of course, you might need to delete /usr/local/pgsql first to have the same preconditions.) Please report whether it works better. -- Peter Eisentraut http://developer.postgresql.org/~petere/
Hello, This installdirs are worked well. 'make install' succeeds without modifying Makefiles. Thank you. regards, -- Shigehiro Honda From: Peter Eisentraut <peter_e@gmx.net> Subject: Re: [HACKERS] Porting/platforms/buildfarm open issues Date: Fri, 7 Jan 2005 10:53:56 +0100 > Am Donnerstag, 6. Januar 2005 16:30 schrieb Honda Shigehiro: > > 2) mkdir? > > Due to odd behavior of 'mkdir -p' command, I got below error when 'make > > install': mkdir -p -- /usr/local/pgsql/bin /usr/local/pgsql/share > > mkdir: cannot create /usr/local/pgsql/share. > > /usr/local/pgsql/share: File exists > > make[2]: *** [installdirs] Error 2 > > Would you place the attached version of mkinstalldirs in the config/ directory > in the PostgreSQL source tree and try installing again? (Of course, you > might need to delete /usr/local/pgsql first to have the same preconditions.) > Please report whether it works better. > > -- > Peter Eisentraut > http://developer.postgresql.org/~petere/
Am Freitag, 7. Januar 2005 13:10 schrieb Honda Shigehiro: > This installdirs are worked well. 'make install' succeeds without > modifying Makefiles. Does anyone object to installing the new mkinstalldirs? I took the latest version from the automake CVS. The important change was apparently to use mkdir -p only with GNU mkdir. -- Peter Eisentraut http://developer.postgresql.org/~petere/
Peter Eisentraut <peter_e@gmx.net> writes:
> Does anyone object to installing the new mkinstalldirs? I took the latest
> version from the automake CVS. The important change was apparently to use
> mkdir -p only with GNU mkdir.
Could you post a diff against what we have now?
regards, tom lane
Am Freitag, 7. Januar 2005 17:20 schrieb Tom Lane: > > Does anyone object to installing the new mkinstalldirs? I took the > > latest version from the automake CVS. The important change was > > apparently to use mkdir -p only with GNU mkdir. > > Could you post a diff against what we have now? Attached. -- Peter Eisentraut http://developer.postgresql.org/~petere/
Hello We made Compiere (Open source ERP system) to Firebird (Fyracle) This is special version of Firebird with added Oracle compatibility (Oracle PL/SQL). It made porting much easier, but our experience show that it would be now also not very difficult with other databases like PostgreSQL. Compiere contained lot of PL/SQL which size is now largely reduced. Main problem is some SQL constructions which are not supported. Particulary something like this is very important:UPDATE sometable set (col1,col2) = (select col_a,col_b from another_table where ....) This construction seems to be quite useful in another cases. Would be it diffcult and possible to add such syntax to PostgreSQL ? Marek Mosiewicz http://www.jotel.com.pl
Peter Eisentraut <peter_e@gmx.net> writes:
> Am Freitag, 7. Januar 2005 17:20 schrieb Tom Lane:
>> Could you post a diff against what we have now?
> Attached.
Looks ok to me.
regards, tom lane