John DeSoi <desoi@xxxxxxxxxx> writes: > On Jan 17, 2005, at 2:10 PM, Matthew Metnetsky wrote: >> I'd appreciate any suggestions on getting a statically linked library >> against libpq. I'm currently compiling on a Fedora Core 3 machine with >> gcc-2.95.3 against the postgresql-libs-7.4.6-1.FC3.2 package. > This is what I'm using to create a version of psql on OS X with libpq > statically linked: > gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith > -Wendif-labels -fno-strict-aliasing command.o common.o help.o input.o > stringutils.o mainloop.o copy.o startup.o prompt.o variables.o > large_obj.o print.o describe.o psqlscan.o tab-complete.o mbprint.o > ../../../src/interfaces/libpq/libpq.a -L../../../src/interfaces/libpq > -L../../../src/port -lpgport -lz -lresolv -ldl -lm -o psql Presumably you are using a fairly vanilla set of configure options, too. Matthew's missing symbols are Kerberos subroutines, so evidently his problem is that he configured --with-krb5 but didn't bother to mention the Kerberos library(s) in his link command. What I would recommend if you want a plugin substitute for the RPM version of the library is to rebuild from the corresponding SRPM and look at the log output to determine what options were used and what libraries need to be mentioned while linking libpq. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html