IRIX OID problems after compile...
От | Ian Abbott |
---|---|
Тема | IRIX OID problems after compile... |
Дата | |
Msg-id | 3874CF51.2B3529EC@cinesite.co.uk обсуждение исходный текст |
Список | pgsql-ports |
If PostgreSQL failed to compile on your computer or you found a bug that is likely to be specific to one platform then please fill out this form and e-mail it to pgsql-ports@postgresql.org. To report any other bug, fill out the form below and e-mail it to pgsql-bugs@postgresql.org. If you not only found the problem but solved it and generated a patch then e-mail it to pgsql-patches@postgresql.org instead. Please use the command "diff -c" to generate the patch. You may also enter a bug report at http://www.postgresql.org/ instead of e-mail-ing this form. ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name: Ian Abbott Your email address: iana@cinesite.co.uk System Configuration ===================== Architecture: SGI MIPS R4400 Operating System: IRIX 6.2 IP22 PostgreSQL version: PostgreSQL-6.5.3 Compiler used: MIPSpro cc Version 7.2.1 Please enter a FULL description of your problem: ================================================ PostgreSQL cannot 'destroydb' from script or monitor. Error given: template1=> drop database firstdb; ERROR: typeidTypeRelid: Invalid type - oid = 0 Can be considered a MAJOR problem. Database unusable without ability to remove data... :) Please describe a way to repeat the problem. Please try to provide a concise reproducible example, if at all possible: ====================================================================== PostgreSQL is notoriously difficult on IRIX machines, particularly the 'n32' ABI that we require for compatibility with other libraries. Compilation flags were as follows for 6.5.3 (in order to achieve any compile at all), using recommendations for compilation from pgsql-ports and the SGI freeware site (freeware.sgi.com): /etc/compiler.defaults (ensures we make n32) -------------------------------------------- -DEFAULT:abi=n32:isa=mips3 config.status ------------- configure --prefix=/usr/freeware/pgsql --with-perl --with-pgport=5432 \ --enable-hba --with-CC=/usr/bin/cc --without-CXX \ --with-includes=/usr/freeware/include \ --with-libraries=/usr/freeware/lib32 Makefile.custom --------------- PERL = /usr/freeware/bin/perl5.00502-n32 CUSTOM_COPT = -O2 \ -woff 1009,1014,1048,1110,1116,1185,1188,1204,1230,1233 \ -Wl,-woff,85,-woff,84 config.cache amendments ----------------------- # libgen, libnsl and libsocket disabled as recommended on SGI # freeware site (then executed config.status --recheck) ac_cv_lib_gen_main=${ac_cv_lib_gen_main='no'} ac_cv_lib_nsl_main=${ac_cv_lib_nsl_main='no'} ac_cv_lib_socket_main=${ac_cv_lib_socket_main='no'} Makefile.shlib -------------- # rpath added to find libraries as recommended on pgsql-ports ifeq ($(PORTNAME), irix5) install-shlib-dep := install-shlib shlib := lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION) LDFLAGS_SL := -shared -rpath $(LIBDIR) CFLAGS += $(CFLAGS_SL) endif build ----- executed using GNU Make version 3.76.1 from SGI Freeware If you know how this problem might be fixed, list the solution below: ===================================================================== If somebody could successfully compile PostgreSQL for the IRIX 6.2+ n32 ABI, inst-package it and get it over to SGI for testing (installing in /usr/freeware/pgsql to maintain their structures) it would be fantastic. Apart from that, how about offering an IRIX binary on the PostgreSQL website. I've been trying to compile the software for going on 3 months now (in different permutations of o32/n32/cc/gcc/g++/ecgs...) and I'm starting to lose my mind. PostgreSQL has so many good features (triggers, rules, refint) that the other systems like MySQL don't support and I really would like to move over from our miraculously once-only compile of the o32 ABI version (we can't even get that to recompile again) as everything else is n32 now. Please help... Ian A
В списке pgsql-ports по дате отправления:
Следующее
От: jgramke@oak.computing.csbsju.edu (Jim Gramke)Дата:
Сообщение: Regression Tests failed: