Message-ID: <4E76A252.5090801@gmail.com>
Date: Mon, 19 Sep 2011 10:00:50 +0800
From: Rural Hunter <ruralhunter@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1;
	rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2
MIME-Version: 1.0
To: Peter Eisentraut <peter_e@gmx.net>
CC: Scott Marlowe <scott.marlowe@gmail.com>, pgsql-admin@postgresql.org
Subject: Re: Problem of LD_LIBRARY_PATH
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>
	<1316359559.12186.14.camel@vanquo.pezone.net>
In-Reply-To: <1316359559.12186.14.camel@vanquo.pezone.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable

Well, I installed pg by the official one-click graphic=20
installer(http://www.enterprisedb.com/products/pgdownload.do). But ahh,=20
when I tried to get an error message if I don't set LD_LIBRARY_PATH, I=20
found it's now working without this variable. The variable was added=20
into my env for 9.1rc. If I don't add it I got this error:
postgres@backup:~$ createuser
createuser: error while loading shared libraries: liblber-2.3.so.0:=20
cannot open shared object file: No such file or directory

I searched net and found the solution to add LD_LIBRARY_PATH into env.=20
but looks it's not needed any more in the final release. So my problem=20
is resolved. Thank you all.

=E4=BA=8E 2011/9/18 23:25, Peter Eisentraut =E5=86=99=E9=81=93:
> On s=C3=B6n, 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.  S=
o
> you might want to check their precise installation instructions, or
> report a bug if they don't work.  I think setting LD_LIBRARY_PATH shoul=
d
> 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
>>
>> =E4=BA=8E2011=E5=B9=B49=E6=9C=8818=E6=97=A5 21:58:17,Peter Eisentraut=E5=
=86=99=E5=88=B0:
>>> On s=C3=B6n, 2011-09-18 at 14:56 +0800, Rural Hunter wrote:
>>>> This is my env:
>>>> postgres@backup:~$ env
>>>> MANPATH=3D:/opt/PostgreSQL/9.1/share/man
>>>> SHELL=3D/bin/bash
>>>> TERM=3Dlinux
>>>> USER=3Dpostgres
>>>> LD_LIBRARY_PATH=3D/opt/PostgreSQL/9.1/lib/
>>>> PGPORT=3D3500
>>>> LS_COLORS=3Drs=3D0:di=3D01;34:ln=3D01;36:mh=3D00:pi=3D40;33:so=3D01;=
35:do=3D01;35:bd=3D40;33;01:cd=3D40;33;01:or=3D40;31;01:su=3D37;41:sg=3D3=
0;43:ca=3D30;41:tw=3D30;42:ow=3D34;42:st=3D37;44:ex=3D01;32:*.tar=3D01;31=
:*.tgz=3D01;31:*.arj=3D01;31:*.taz=3D01;31:*.lzh=3D01;31:*.lzma=3D01;31:*=
=2Etlz=3D01;31:*.txz=3D01;31:*.zip=3D01;31:*.z=3D01;31:*.Z=3D01;31:*.dz=3D=
01;31:*.gz=3D01;31:*.lz=3D01;31:*.xz=3D01;31:*.bz2=3D01;31:*.bz=3D01;31:*=
=2Etbz=3D01;31:*.tbz2=3D01;31:*.tz=3D01;31:*.deb=3D01;31:*.rpm=3D01;31:*.=
jar=3D01;31:*.rar=3D01;31:*.ace=3D01;31:*.zoo=3D01;31:*.cpio=3D01;31:*.7z=
=3D01;31:*.rz=3D01;31:*.jpg=3D01;35:*.jpeg=3D01;35:*.gif=3D01;35:*.bmp=3D=
01;35:*.pbm=3D01;35:*.pgm=3D01;35:*.ppm=3D01;35:*.tga=3D01;35:*.xbm=3D01;=
35:*.xpm=3D01;35:*.tif=3D01;35:*.tiff=3D01;35:*.png=3D01;35:*.svg=3D01;35=
:*.svgz=3D01;35:*.mng=3D01;35:*.pcx=3D01;35:*.mov=3D01;35:*.mpg=3D01;35:*=
=2Empeg=3D01;35:*.m2v=3D01;35:*.mkv=3D01;35:*.ogm=3D01;35:*.mp4=3D01;35:*=
=2Em4v=3D01;35:*.mp4v=3D01;35:*.vob=3D01;35:*.qt=3D01;35:*.nuv=3D01;35:*.=
wmv=3D01;35:*.asf=3D01;35:*.rm=3D01;35:*.rmvb=3D01;35:*.flc=3D01;35:*.avi=
=3D01;35:*.fli=3D01;35:*.flv=3D01;35:*.gl=3D01;35:*.dl=3D01;35:*.xcf=3D01=
;35:
>> *.x
>>>> wd=3D01;35:*.yuv=3D01;35:*.cgm=3D01;35:*.emf=3D01;35:*.axv=3D01;35:*=
=2Eanx=3D01;35:*.ogv=3D01;35:*.ogx=3D01;35:*.aac=3D00;36:*.au=3D00;36:*.f=
lac=3D00;36:*.mid=3D00;36:*.midi=3D00;36:*.mka=3D00;36:*.mp3=3D00;36:*.mp=
c=3D00;36:*.ogg=3D00;36:*.ra=3D00;36:*.wav=3D00;36:*.axa=3D00;36:*.oga=3D=
00;36:*.spx=3D00;36:*.xspf=3D00;36:
>>>> PGUSER=3Dpostgres
>>>> PGDATABASE=3Dpostgres
>>>> MAIL=3D/var/mail/postgres
>>>> PATH=3D/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games:/opt=
/PostgreSQL/9.1/bin
>>>> PWD=3D/home/postgres
>>>> LANG=3Dzh_CN.UTF-8
>>>> SHLVL=3D1
>>>> HOME=3D/home/postgres
>>>> LANGUAGE=3Dzh_CN:zh
>>>> LOGNAME=3Dpostgres
>>>> PGDATA=3D/raid/PostgreSQL/data
>>>> LESSOPEN=3D| /usr/bin/lesspipe %s
>>>> LESSCLOSE=3D/usr/bin/lesspipe %s %s
>>>> _=3D/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?
>>>
>>>
>>>
>>
>>
>
>
>