Re: [PORTS] Which library has these symbols? -- Additional INFO

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(at)postgresql(dot)org [mailto:pgsql-ports-owner(at)postgresql(dot)org] On Behalf Of Mohan, Ross
Sent: Tuesday, May 24, 2005 7:55 PM
To: pgsql-ports(at)postgresql(dot)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.o lib/SUBSYS.o libpq/SUBSYS.o main/SUBSYS.o nodes/SUBSYS.o optimizer/SUBSYS.o port/SUBSYS.o postmaster/SUBSYS.o regex/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) Archive library 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 linking of 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