Thread: createdb problem

I just instaled the version 7.0.3 on a FreeBSD.

i made :

./configure
gmake
gmake install
adduser postgres
su -postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data

and the postmaster started with no problems,but:

when i tryied  :
/usr/local/pgsql/bin createdb test

I got an error:

/usr/libexec/ld-elf.so.1: Shared object "libpq.so.2" not found

What to do?

Thanks
  Eduardo

This should probably be an faq (if it isn't already). PostgreSQL is not finding the libraries. If you add the following
lineto your environment, it should go away: 

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/pgsql/lib

(or in csh):

setenv LD_LIBRARY_PATH $LD_LIBRARY_PATH:/usr/local/pgsql/lib

HTH

Jacques Williams

On Tue, Nov 21, 2000 at 11:45:55AM -0200, Eduardo wrote:
> I just instaled the version 7.0.3 on a FreeBSD.
>
> i made :
>
> ./configure
> gmake
> gmake install
> adduser postgres
> su -postgres
> /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
> /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
>
> and the postmaster started with no problems,but:
>
> when i tryied  :
> /usr/local/pgsql/bin createdb test
>
> I got an error:
>
> /usr/libexec/ld-elf.so.1: Shared object "libpq.so.2" not found
>
> What to do?
>
> Thanks
>   Eduardo

Eduardo <eduardo@complex.com.br> writes:
> I just instaled the version 7.0.3 on a FreeBSD.
> when i tryied  :
> /usr/local/pgsql/bin createdb test
> /usr/libexec/ld-elf.so.1: Shared object "libpq.so.2" not found

You need to run ldconfig, or set LD_LIBRARY_PATH, or local equivalent
of either of these actions (not sure what FreeBSD calls 'em), to tell
the system there are shared libraries in /usr/local/pgsql/lib.  See
step 8 in the installation procedure
http://www.postgresql.org/users-lounge/docs/7.0/postgres/install17165.htm

            regards, tom lane