Re: 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@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