Subject: Re: Problem of LD_LIBRARY_PATH
From: Peter Eisentraut <peter_e@gmx.net>
To: Rural Hunter <ruralhunter@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>, pgsql-admin@postgresql.org
Date: Sun, 18 Sep 2011 18:25:58 +0300
In-Reply-To: <4E760310.807@gmail.com>
References: <4E755BCB.6080706@gmail.com>
	<CAOR=d=1cs_Ctu-hEX5a5rmMk2L4X6DAQECFf+SFYZLc0TqQbjA@mail.gmail.com>
	<4E759637.1060600@gmail.com>
	<1316354298.12186.0.camel@vanquo.pezone.net>
	<4E760310.807@gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 8bit
Message-ID: <1316359559.12186.14.camel@vanquo.pezone.net>
Mime-Version: 1.0

On sön, 2011-09-18 at 22:41 +0800, Rural Hunter wrote:
> I didn't install anything else there:

(for a very small value of "anything else")

It looks like you have some version of libncurses in there, which is
prone to interfere with the operating system installation.

I suppose you got this installation from some third-party installer.  So
you might want to check their precise installation instructions, or
report a bug if they don't work.  I think setting LD_LIBRARY_PATH should
not actually be necessary.

Alternatively, install the official Ubuntu package.


> postgres@backup:~$ ls -l /opt/PostgreSQL/9.1/lib/
> Total 9804
> -rwxr-xr-- 1 root daemon 1366272 2011-09-09 13:45 libcrypto.so.6
> -rw-r--r-- 1 root daemon  149938 2011-09-09 13:44 libecpg.a
> -rw-r--r-- 1 root daemon   18852 2011-09-09 13:44 libecpg_compat.a
> -rwxr-xr-x 1 root daemon   23327 2011-09-09 14:03 libecpg_compat.so
> -rwxr-xr-x 1 root daemon   23327 2011-09-09 14:03 libecpg_compat.so.3
> -rwxr-xr-x 1 root daemon   23327 2011-09-09 14:03 libecpg_compat.so.3.3
> -rwxr-xr-x 1 root daemon   87003 2011-09-09 14:03 libecpg.so
> -rwxr-xr-x 1 root daemon   87003 2011-09-09 14:03 libecpg.so.6
> -rwxr-xr-x 1 root daemon   87003 2011-09-09 14:03 libecpg.so.6.3
> -rwxr-xr-- 1 root daemon  192738 2011-09-09 13:45 libedit.so
> lrwxrwxrwx 1 root root        17 2011-09-13 13:47 libjpeg.so -> 
> libjpeg.so.62.0.0
> lrwxrwxrwx 1 root root        17 2011-09-13 13:47 libjpeg.so.62 -> 
> libjpeg.so.62.0.0
> -rwxr-xr-- 1 root daemon  138936 2011-09-09 13:45 libjpeg.so.62.0.0
> -rwxr-xr-- 1 root daemon   59040 2011-09-09 13:45 liblber-2.3.so.0
> -rwxr-xr-- 1 root daemon  241360 2011-09-09 13:45 libldap-2.3.so.0
> -rwxr-xr-- 1 root daemon  260568 2011-09-09 13:45 libldap_r-2.3.so.0
> lrwxrwxrwx 1 root root        15 2011-09-13 13:47 libncurses.so -> 
> libncurses.so.5
> lrwxrwxrwx 1 root root        17 2011-09-13 13:47 libncurses.so.5 -> 
> libncurses.so.5.5
> -rwxr-xr-- 1 root daemon  380336 2011-09-09 13:45 libncurses.so.5.5
> -rw-r--r-- 1 root daemon   60292 2011-09-09 13:43 libpgport.a
> -rw-r--r-- 1 root daemon  101184 2011-09-09 13:44 libpgtypes.a
> -rwxr-xr-x 1 root daemon   68966 2011-09-09 14:03 libpgtypes.so
> -rwxr-xr-x 1 root daemon   68966 2011-09-09 14:03 libpgtypes.so.3
> -rwxr-xr-x 1 root daemon   68966 2011-09-09 14:03 libpgtypes.so.3.2
> lrwxrwxrwx 1 root root        18 2011-09-13 13:47 libpng12.so -> 
> libpng12.so.0.10.0
> lrwxrwxrwx 1 root root        18 2011-09-13 13:47 libpng12.so.0 -> 
> libpng12.so.0.10.0
> -rwxr-xr-- 1 root daemon  149520 2011-09-09 13:45 libpng12.so.0.10.0
> -rw-r--r-- 1 root daemon  286182 2011-09-09 13:44 libpq.a
> -rwxr-xr-x 1 root daemon  189815 2011-09-09 14:03 libpq.so
> -rwxr-xr-x 1 root daemon  189815 2011-09-09 14:03 libpq.so.5
> -rwxr-xr-x 1 root daemon  189815 2011-09-09 14:03 libpq.so.5.4
> -rwxr-xr-- 1 root daemon  105464 2011-09-09 13:45 libsasl2.so.2
> -rwxr-xr-- 1 root daemon  315032 2011-09-09 13:45 libssl.so.6
> lrwxrwxrwx 1 root root        13 2011-09-13 13:47 libtermcap.so.2 -> 
> libncurses.so
> lrwxrwxrwx 1 root root        18 2011-09-13 13:47 libuuid.so -> 
> libuuid.so.16.0.22
> lrwxrwxrwx 1 root root        14 2011-09-13 13:47 libuuid.so.1 -> 
> libuuid.so.1.2
> -rwxr-xr-- 1 root daemon   17728 2011-09-09 13:45 libuuid.so.1.2
> lrwxrwxrwx 1 root root        18 2011-09-13 13:47 libuuid.so.16 -> 
> libuuid.so.16.0.22
> -rw-r--r-- 1 root daemon   51937 2011-09-09 13:45 libuuid.so.16.0.22
> -rwxr-xr-- 1 root daemon 4157970 2011-09-09 13:45 libxml2.so.2
> -rwxr-xr-- 1 root daemon  822303 2011-09-09 14:03 libxslt.so.1
> drwxr-xr-x 4 root daemon    4096 2011-08-25 11:20 postgresql
> 
> 于2011年9月18日 21:58:17,Peter Eisentraut写到:
> > On sön, 2011-09-18 at 14:56 +0800, Rural Hunter wrote:
> >> This is my env:
> >> postgres@backup:~$ env
> >> MANPATH=:/opt/PostgreSQL/9.1/share/man
> >> SHELL=/bin/bash
> >> TERM=linux
> >> USER=postgres
> >> LD_LIBRARY_PATH=/opt/PostgreSQL/9.1/lib/
> >> PGPORT=3500
> >> LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35
 :
> *.x
> >> wd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:
> >> PGUSER=postgres
> >> PGDATABASE=postgres
> >> MAIL=/var/mail/postgres
> >> PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games:/opt/PostgreSQL/9.1/bin
> >> PWD=/home/postgres
> >> LANG=zh_CN.UTF-8
> >> SHLVL=1
> >> HOME=/home/postgres
> >> LANGUAGE=zh_CN:zh
> >> LOGNAME=postgres
> >> PGDATA=/raid/PostgreSQL/data
> >> LESSOPEN=| /usr/bin/lesspipe %s
> >> LESSCLOSE=/usr/bin/lesspipe %s %s
> >> _=/usr/bin/env
> >>
> >> To make top/vi work, I just need to unset LD_LIBRARY_PATH.
> >
> > What else do you have installed in /opt/PostgreSQL/9.1/lib/?  Can you
> > show a directory listing?
> >
> >
> >
> 
> 
>