Skip site navigation (1) Skip section navigation (2)

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

From: Brian Wipf <brian(at)clickspace(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-ports(at)postgresql(dot)org, Brendan Duddridge <brendan(at)clickspace(dot)com>, Guido Neitzer <lists(at)event-s(dot)net>
Subject: Re: Compiling PostgreSQL 8.1.5 with 64-bit on a G5 SOLVED
Date: 2006-11-28 02:21:48
Message-ID: CADD371E-2F1C-47F0-A492-A24D8273AF5D@clickspace.com (view raw or flat)
Thread:
Lists: pgsql-ports
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



In response to

Responses

pgsql-ports by date

Next:From: Tom LaneDate: 2006-11-28 02:46:10
Subject: Re: Compiling PostgreSQL 8.1.5 with 64-bit on a G5 SOLVED
Previous:From: Jim NasbyDate: 2006-11-28 01:56:30
Subject: Fwd: [NOVICE] Which installer for Postgres on Windows?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group