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

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

From: "Mohan, Ross" <RMohan(at)arbinet(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [PORTS] Which library has these symbols? -- Additional INFO
Date: 2005-05-25 00:15:36
Message-ID: CC74E7E10A8A054798B6611BD1FEF4D30625DB0B@vamail01.thexchange.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-ports
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

pgsql-ports by date

Next:From: ПНПDate: 2005-05-25 02:02:00
Subject: Правовые аспекты коммерческой деятельности
Previous:From: Mohan, RossDate: 2005-05-24 23:55:00
Subject: Which library has these symbols?

pgsql-admin by date

Next:From: Tom LaneDate: 2005-05-25 02:52:49
Subject: Re: Which library has these symbols?
Previous:From: Mohan, RossDate: 2005-05-24 23:55:00
Subject: Which library has these symbols?

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