If I strip it down to
no optimization
32-bit COFF (YUCK)
and
point "ld" to ./src/port/libpgport
it works:
$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
<snip>
Success. You can now start the database server using:
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
or
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
[1] 377052
$ /usr/local/pgsql/bin/createdb test
CREATE DATABASE
$ /usr/local/pgsql/bin/psql test
Welcome to psql 8.0.2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
test=# \q
But I **really** don't want 32-bit, or unoptimized code.
-- Ross
-----Original Message-----
From: pgsql-ports-owner@postgresql.org [mailto:pgsql-ports-owner@postgresql.org] On Behalf Of Mohan, Ross
Sent: Tuesday, May 24, 2005 7:55 PM
To: pgsql-ports@postgresql.org
Subject: [PORTS] Which library has these symbols?
So Close, Yet So Far!
Compiling PostgreSQL 8.0.2 on AIX5.3 under xlc7.00 and gnumake3.80:
xlc -O5 -q64 -L../../src/port access/SUBSYS.o bootstrap/SUBSYS.o catalog/SUBSYS.o parser/SUBSYS.o commands/SUBSYS.o
executor/SUBSYS.olib/SUBSYS.o libpq/SUBSYS.o main/SUBSYS.o nodes/SUBSYS.o optimizer/SUBSYS.o port/SUBSYS.o
postmaster/SUBSYS.oregex/SUBSYS.o rewrite/SUBSYS.o storage/SUBSYS.o tcop/SUBSYS.o utils/SUBSYS.o
../../src/timezone/SUBSYS.o-Wl,-bE:../../src/backend/postgres.imp -lpgport_srv -lcygipc -lunix -lresolv -lPW -lgen
-lBSD-lcompat -lld -ldld -llc -lIPC -lipc -lsocket -lnsl -ldl -lm -o postgres
1586-404 (E) Archive library file "libcygipc.a" not found. 1586-404 (E) Archive library file "libunix.a" not found.
1586-404(E) Archive library file "libresolv.a" not found. 1586-404 (E) Archive library file "libgen.a" not found.
1586-404(E) Archive library file "libBSD.a" not found. 1586-404 (E) Archive library file "libcompat.a" not found.
1586-404(E) Archive library file "libdld.a" not found. 1586-404 (E) Archive library file "liblc.a" not found. 1586-404
(E)Archive library file "libIPC.a" not found. 1586-404 (E) Archive library file "libipc.a" not found. 1586-404 (E)
Archivelibrary file "libsocket.a" not found.
ld: 0711-317 ERROR: Undefined symbol: .set_pglocale_pgservice
ld: 0711-317 ERROR: Undefined symbol: .pg_usleep
ld: 0711-317 ERROR: Undefined symbol: .pg_strcasecmp
ld: 0711-317 ERROR: Undefined symbol: .pg_set_noblock
ld: 0711-317 ERROR: Undefined symbol: .get_progname
ld: 0711-317 ERROR: Undefined symbol: .find_my_exec
ld: 0711-317 ERROR: Undefined symbol: .get_pkglib_path
ld: 0711-317 ERROR: Undefined symbol: .pg_strncasecmp
ld: 0711-317 ERROR: Undefined symbol: .get_share_path
ld: 0711-317 ERROR: Undefined symbol: .pg_tolower
ld: 0711-317 ERROR: Undefined symbol: .make_native_path
ld: 0711-317 ERROR: Undefined symbol: .canonicalize_path
ld: 0711-317 ERROR: Undefined symbol: .first_dir_separator
ld: 0711-317 ERROR: Undefined symbol: .first_path_separator
ld: 0711-317 ERROR: Undefined symbol: .get_parent_directory
ld: 0711-317 ERROR: Undefined symbol: .join_path_components
ld: 0711-317 ERROR: Undefined symbol: .rmtree
ld: 0711-317 ERROR: Undefined symbol: .pg_toupper
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. 1586-347 (S) An error occurred during
linkingof the object produced by the IPA Link step. The link return code was 8.
make[2]: *** [postgres] Error 1
make[2]: Leaving directory `/home/app/postgresql-8.0.2/src/backend'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/home/app/postgresql-8.0.2/src'
make: *** [all] Error 2
My flags are:
CFLAGS=' -O5 -q64 '
LDFLAGS=' -Xlinker -lpgport -Xlinker -lpgtypes -Xlinker -lpgport_srv '
I see some, but not all of these in ./src/port/libpgport.a. Anyways, it's ignoring the loader flags anyways. Sorry for
crosspost,but am a bit desperate here.
Any ideas?
- Ross
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend