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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
