Thread: Installation-trouble

Installation-trouble

From
"Christoph Lange"
Date:
Dear Postgresql-experts,
 
this is a desperate cry for help to all of you! I am quite a rookie concerning Unix and databases. Despite this fact I have tried to install Postgresql 7.0.3 into my homedirectory (/home/lange) on a Unix platform for a test run. Following the installation guide like a lemming everything had worked quite fine until I tried to create my first table producing this:

uranus% /home/lange/pgsql/local/bin/createdb testdb
    ld.so.1: /home/lange/pgsql/local/bin/psql: fatal: libpq.so: open failed: No such file or directory
    Killed
    createdb: database creation failed

Unfortunately I don't know how to solve this problem, though - I guess - it must be something obvious.
It would be very, very kind if somebody gave some advice to me.
 
Thank you for helping out a clueless rookie.
Christoph Lange
 
PS: Those are all commands (and some results) I have used until now.

uranus% cd /home/lange/pgsql
uranus% gunzip postgresql-7.0.3.tar.gz
uranus% tar -xf postgresql-7.0.3.tar
uranus% cd postgresql-7.0.3/src
uranus% mkdir /home/lange/pgsql/local
uranus% ./configure --prefix=/home/lange/pgsql/local
            Only thing that looked suspicious among all messages:
    configure: warning: TCL/TK support disabled; tcl shell is not in your path
uranus% gmake
    All of PostgreSQL is successfully made. Ready to install
uranus% cd /home/lange/pgsql/postgresql-7.0.3/src/test/regress
uranus% gmake clean
uranus% gmake all
uranus% gmake runcheck
            All tests were ok
uranus% cd /home/lange/pgsql/postgresql-7.0.3/src/
uranus% gmake install
    Thank you for choosing PostgreSQL, the most advanced open source database
    engine.
uranus% mkdir /home/lange/pgsql/local/data
uranus% chown lange /home/lange/pgsql/local/data
uranus% su - lange
    Password:
    Sun Microsystems Inc.   SunOS 5.6       Generic August 1997
uranus% /home/lange/pgsql/local/bin/initdb -D /home/lange/pgsql/local/data
    Success. You can now start the database server using:
            /home/lange/pgsql/local/bin/postmaster -D /home/lange/pgsql/local/data
    or
            /home/lange/pgsql/local/bin/pg_ctl -D /home/lange/pgsql/local/data start
uranus% /home/lange/pgsql/local/bin/postmaster -D /home/lange/pgsql/local/data&
    [1] 11787
uranus% DEBUG:  Data Base System is starting up at Wed Feb 28 15:46:52 2001
    DEBUG:  Data Base System was shut down at Wed Feb 28 15:42:51 2001
    DEBUG:  Data Base System is in production state at Wed Feb 28 15:46:52 2001
uranus% /home/lange/pgsql/local/bin/createdb testdb
    ld.so.1: /home/lange/pgsql/local/bin/psql: fatal: libpq.so: open failed: No such file or directory
    Killed
    createdb: database creation failed

Re: Installation-trouble

From
Stefan Huber
Date:
Hi!

>Dear Postgresql-experts,

Uh, that's what I'm not :)

>uranus% /home/lange/pgsql/local/bin/createdb testdb
>    ld.so.1: /home/lange/pgsql/local/bin/psql: fatal: libpq.so: open failed: No such file or directory

Either you issue (if you're using bash)
$ export LD_LIBRARY_PATH=/home/lange/pgsql/local/lib
(you can put this line into your ~/.bashr)

of (if you have root privileges), you might edit /etc.ld.so.conf and add the line
/home/lange/pgsql/local/lib
to it, then run
$ ldconfig -v
This lists all the libraries, ldconfig finds. The pg_libs should be there.

BTW: This is described in the INSTALL file (Point 8.), too.

Stefan