Skip site navigation (1) Skip section navigation (2)

Re: Error while loading shared libraries

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: yulytenorio(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Error while loading shared libraries
Date: 2008-07-26 15:22:49
Message-ID: 488B4149.8000706@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-bugs
yulytenorio(at)gmail(dot)com wrote:
> Hello,
> I have installed postgresql, version 8.3.3.

Some information you left out would be useful, such as:

- Operating system
- Version of operating system
- How you obtained and installed PostgreSQL (from where, how you built
it if you built it yourself, etc)
- ... and anything else that seems relevant.

> and when I run: su -l postgres
> -c "/usr/local/pgsql/bin/createuser  -d -a nobody", I get this error:
> 
> sh-2.05b# su -l postgres  -c "/usr/local/pgsql/bin/createuser  -d -a nobody"
> /usr/local/pgsql/bin/createuser: error while loading shared libraries:
> libz.so.1: cannot open shared object file: No such file or directory
> 
> However, this library is there..:
> sh-2.05b# su -l postgres  -c "echo $LD_LIBRARY_PATH"
> /lib:/usr/lib:/opt/IBM-ME-2.2.2/jre/bin:/usr/local/pgsql/lib

Hmm... if you're on Linux (at least, any faintly sensible Linux flavour)
you shouldn't need /lib or /usr/lib in LD_LIBRARY_PATH, as they're
configured to be searched by default in /etc/ld.so.conf .

> So I was wondering if you guys could help me! I do not know what is wrong
> :-(
> Is createuser not looking at LD_LIBRARY_PATH for its libraries?

In this case it shouldn't have to.

The error you're encountering does indeed seem rather odd, though.

What's the output of:

  su -l postgres  -c "ldd /usr/local/pgsql/bin/createuser"

?

If you're on a glibc system (essentially all Linux, at least) try using
LD_DEBUG to trace the linker's operation, too, and see if that tells you
anything useful:

  LD_DEBUG="libs,files" su -l postgres "<your-command-here>"

See this page for a simple summary:

  http://www.wlug.org.nz/LD_DEBUG

It looks like it's similar on Solaris, too:

  http://docsun.cites.uiuc.edu/sun_docs/C/solaris_9/SUNWdev/LLM/p18.html

--
Craig Ringer

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2008-07-26 17:30:43
Subject: Re: BUG #4324: Default value for a column is not returned in select when column has not been explicitly set
Previous:From: Pavel StehuleDate: 2008-07-26 11:09:18
Subject: Re: BUG #4324: Default value for a column is not returned in select when column has not been explicitly set

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group