Re: Compiling PostgreSQL 8.1.5 with 64-bit on a G5 SOLVED

On 27-Nov-06, at 6:39 PM, Tom Lane wrote:
> If you don't help us debug it then 8.2 won't be any better.
I thought maybe this worked for 8.2. I'm glad to be able to help.
>
>> RETURNS trigger
>> AS '/Users/admin/Downloads/postgresql-8.1.5/src/test/
>> regress/../../../contrib/spi/refint.so'
>> LANGUAGE 'C';
>> + ERROR: could not load library "/Users/admin/Downloads/
>> postgresql-8.1.5/src/test/regress/../../../contrib/spi/refint.so":
>> inappropriate object file
>
> Try "make clean; make all" in src/test/regress and watch the make
> output
> to see exactly how refint.so is getting built. I suspect your 64-bit
> CFLAGS are not getting propagated there for some reason.

Here's a complete dump of make all, after doing a make clean, from
src/test/regress:

$ make all
sed -e 's,@bindir@,/usr/local/pgsql/bin,g' \
-e 's,@libdir@,/usr/local/pgsql/lib,g' \
-e 's,@pkglibdir@,/usr/local/pgsql/lib,g' \
-e 's,@datadir@,/usr/local/pgsql/share,g' \
-e 's/@VERSION@/8.1.5/g' \
-e 's/@host_tuple@/powerpc-apple-darwin8.8.0/g' \
-e 's,@GMAKE@,make,g' \
-e 's/@enable_shared@/yes/g' \
-e 's/@GCC@/yes/g' \
pg_regress.sh >pg_regress
chmod a+x pg_regress
gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -
Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-
aliasing -arch ppc64 -Wall -Wmissing-prototypes -Wpointer-arith -
Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-
aliasing -I../../../src/include -c -o regress.o regress.c
gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -
Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-
aliasing -arch ppc64 -Wall -Wmissing-prototypes -Wpointer-arith -
Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-
aliasing -bundle regress.o -L../../../src/port -
bundle_loader ../../../src/backend/postgres -o libregress.0.0.so
rm -f libregress.0.so
ln -s libregress.0.0.so libregress.0.so
rm -f libregress.so
ln -s libregress.0.0.so libregress.so
rm -f regress.so
ln -s libregress.0.0.so regress.so
sed -e 's,@abs_srcdir@,/Users/admin/Downloads/postgresql-8.1.5/src/
test/regress,g' -e 's,@abs_builddir@,/Users/admin/Downloads/
postgresql-8.1.5/src/test/regress,g' -e 's,@testtablespace@,/Users/
admin/Downloads/postgresql-8.1.5/src/test/regress/testtablespace,g' -
e 's/@DLSUFFIX@/.so/g' input/copy.source >sql/copy.sql
sed -e 's,@abs_srcdir@,/Users/admin/Downloads/postgresql-8.1.5/src/
test/regress,g' -e 's,@abs_builddir@,/Users/admin/Downloads/
postgresql-8.1.5/src/test/regress,g' -e 's,@testtablespace@,/Users/
admin/Downloads/postgresql-8.1.5/src/test/regress/testtablespace,g' -
e 's/@DLSUFFIX@/.so/g' input/create_function_1.source >sql/
create_function_1.sql
sed -e 's,@abs_srcdir@,/Users/admin/Downloads/postgresql-8.1.5/src/
test/regress,g' -e 's,@abs_builddir@,/Users/admin/Downloads/
postgresql-8.1.5/src/test/regress,g' -e 's,@testtablespace@,/Users/
admin/Downloads/postgresql-8.1.5/src/test/regress/testtablespace,g' -
e 's/@DLSUFFIX@/.so/g' input/create_function_2.source >sql/
create_function_2.sql
sed -e 's,@abs_srcdir@,/Users/admin/Downloads/postgresql-8.1.5/src/
test/regress,g' -e 's,@abs_builddir@,/Users/admin/Downloads/
postgresql-8.1.5/src/test/regress,g' -e 's,@testtablespace@,/Users/
admin/Downloads/postgresql-8.1.5/src/test/regress/testtablespace,g' -
e 's/@DLSUFFIX@/.so/g' input/misc.source >sql/misc.sql
sed -e 's,@abs_srcdir@,/Users/admin/Downloads/postgresql-8.1.5/src/
test/regress,g' -e 's,@abs_builddir@,/Users/admin/Downloads/
postgresql-8.1.5/src/test/regress,g' -e 's,@testtablespace@,/Users/
admin/Downloads/postgresql-8.1.5/src/test/regress/testtablespace,g' -
e 's/@DLSUFFIX@/.so/g' input/constraints.source >sql/constraints.sql
sed -e 's,@abs_srcdir@,/Users/admin/Downloads/postgresql-8.1.5/src/
test/regress,g' -e 's,@abs_builddir@,/Users/admin/Downloads/
postgresql-8.1.5/src/test/regress,g' -e 's,@testtablespace@,/Users/
admin/Downloads/postgresql-8.1.5/src/test/regress/testtablespace,g' -
e 's/@DLSUFFIX@/.so/g' input/tablespace.source >sql/tablespace.sql
sed -e 's,@abs_srcdir@,/Users/admin/Downloads/postgresql-8.1.5/src/
test/regress,g' -e 's,@abs_builddir@,/Users/admin/Downloads/
postgresql-8.1.5/src/test/regress,g' -e 's,@testtablespace@,/Users/
admin/Downloads/postgresql-8.1.5/src/test/regress/testtablespace,g' -
e 's/@DLSUFFIX@/.so/g' output/copy.source >expected/copy.out
sed -e 's,@abs_srcdir@,/Users/admin/Downloads/postgresql-8.1.5/src/
test/regress,g' -e 's,@abs_builddir@,/Users/admin/Downloads/
postgresql-8.1.5/src/test/regress,g' -e 's,@testtablespace@,/Users/
admin/Downloads/postgresql-8.1.5/src/test/regress/testtablespace,g' -
e 's/@DLSUFFIX@/.so/g' output/create_function_1.source >expected/
create_function_1.out
sed -e 's,@abs_srcdir@,/Users/admin/Downloads/postgresql-8.1.5/src/
test/regress,g' -e 's,@abs_builddir@,/Users/admin/Downloads/
postgresql-8.1.5/src/test/regress,g' -e 's,@testtablespace@,/Users/
admin/Downloads/postgresql-8.1.5/src/test/regress/testtablespace,g' -
e 's/@DLSUFFIX@/.so/g' output/create_function_2.source >expected/
create_function_2.out
sed -e 's,@abs_srcdir@,/Users/admin/Downloads/postgresql-8.1.5/src/
test/regress,g' -e 's,@abs_builddir@,/Users/admin/Downloads/
postgresql-8.1.5/src/test/regress,g' -e 's,@testtablespace@,/Users/
admin/Downloads/postgresql-8.1.5/src/test/regress/testtablespace,g' -
e 's/@DLSUFFIX@/.so/g' output/misc.source >expected/misc.out
sed -e 's,@abs_srcdir@,/Users/admin/Downloads/postgresql-8.1.5/src/
test/regress,g' -e 's,@abs_builddir@,/Users/admin/Downloads/
postgresql-8.1.5/src/test/regress,g' -e 's,@testtablespace@,/Users/
admin/Downloads/postgresql-8.1.5/src/test/regress/testtablespace,g' -
e 's/@DLSUFFIX@/.so/g' output/constraints.source >expected/
constraints.out
sed -e 's,@abs_srcdir@,/Users/admin/Downloads/postgresql-8.1.5/src/
test/regress,g' -e 's,@abs_builddir@,/Users/admin/Downloads/
postgresql-8.1.5/src/test/regress,g' -e 's,@testtablespace@,/Users/
admin/Downloads/postgresql-8.1.5/src/test/regress/testtablespace,g' -
e 's/@DLSUFFIX@/.so/g' output/tablespace.source >expected/tablespace.out
make -C ../../../contrib/spi refint.so autoinc.so
gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -
Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-
aliasing -arch ppc64 -Wall -Wmissing-prototypes -Wpointer-arith -
Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-
aliasing -DREFINT_VERBOSE -I. -I../../src/include -c -o refint.o
refint.c
gcc -no-cpp-precomp -bundle -o refint.so refint.o -
bundle_loader ../../src/backend/postgres
gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -
Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-
aliasing -arch ppc64 -Wall -Wmissing-prototypes -Wpointer-arith -
Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-
aliasing -DREFINT_VERBOSE -I. -I../../src/include -c -o autoinc.o
autoinc.c
gcc -no-cpp-precomp -bundle -o autoinc.so autoinc.o -
bundle_loader ../../src/backend/postgres
rm refint.o autoinc.o