Thread: dyld: Library not loaded: /server_sw/lib/libpq.4.dylib

dyld: Library not loaded: /server_sw/lib/libpq.4.dylib

From
apple sucks
Date:
Well, I have issues.

Freshly downloaded 8.1 source - got a built
successfully message.
make install - got a installed successfully message.
Created the postgre user, made a data directory, and
successfully used "initdb" to make a cluster.
So far, so good. Everything seems to work.

Then I tried "createdb testdb" and it failed with this
message:

dyld: Library not loaded: /server_sw/lib/libpq.4.dylib
  Referenced from: /server_sw/pgsql/bin/createdb
  Reason: image not found
Trace/BPT trap

For what it's worth, looking in /server_sw/pgsql/lib I
*DO* find:

-rwxr-xr-x    1 root  postgre   118120 Nov 11 16:50
libpq.4.1.dylib*
lrwxr-xr-x    1 root  postgre       15 Nov 11 16:50
libpq.4.dylib@ -> libpq.4.1.dylib

Also, several of the commands in the pgsql/bin give me
this error.
HOWEVER, I *was able* to connect to the database with
"psql template1".
So I know the database server itself is working.

Just for fun, I did try
     setenv LD_LIBRARY_PATH /server_sw/pgsql/lib
but it didn't help me any.

So, I dunno what else to do and I am looking for
assistance. I am running under Mac OS 10.4.3 with all
software updates installed, on a Powerbook G4. The
output of pg_config is as follows:

BINDIR = /server_sw/pgsql/bin
DOCDIR = /server_sw/pgsql/doc/postgresql
INCLUDEDIR = /server_sw/pgsql/include
PKGINCLUDEDIR = /server_sw/pgsql/include/postgresql
INCLUDEDIR-SERVER =
/server_sw/pgsql/include/postgresql/server
LIBDIR = /server_sw/pgsql/lib
PKGLIBDIR = /server_sw/pgsql/lib/postgresql
LOCALEDIR =
MANDIR = /usr/local/share/man
SHAREDIR = /server_sw/pgsql/share/postgresql
SYSCONFDIR = /server_sw/pgsql/etc/postgresql
PGXS =
/server_sw/pgsql/lib/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/server_sw'
'--mandir=/usr/local/share/man/' '--enable-recode'
'--enable-odbc' '--enable-syslog'
'--enable-unicode-conversion' '--enable-multibyte'
'--with-openssl' '--with-pam' '--with-bonjour'
'--with-perl' '--with-java'
CC = gcc -no-cpp-precomp
CPPFLAGS =
CFLAGS = -O2 -Wall -Wmissing-prototypes
-Wpointer-arith -Winline -Wdeclaration-after-statement
-Wendif-labels -fno-strict-aliasing
CFLAGS_SL =
LDFLAGS =
LDFLAGS_SL =
LIBS = -lpgport -lpam -lssl -lcrypto -lz -lreadline
-lresolv -ldl -lm
VERSION = PostgreSQL 8.1.0


Thanks in advance!




__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com