References: <4E755BCB.6080706@gmail.com>
	<CAOR=d=1cs_Ctu-hEX5a5rmMk2L4X6DAQECFf+SFYZLc0TqQbjA@mail.gmail.com>
	<4E759637.1060600@gmail.com>
	<CAOR=d=00gtCSmZbspTuneTQcjdbvSZkFZwVe4vtAQADWZdRkbw@mail.gmail.com>
From: Richard Shaw <richard@aggress.net>
In-Reply-To: 
 <CAOR=d=00gtCSmZbspTuneTQcjdbvSZkFZwVe4vtAQADWZdRkbw@mail.gmail.com>
Mime-Version: 1.0 (iPhone Mail 8L1)
Date: Sun, 18 Sep 2011 11:09:25 +0200
Message-ID: <-3767666986360044590@unknownmsgid>
Subject: Re: Problem of LD_LIBRARY_PATH
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Rural Hunter <ruralhunter@gmail.com>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: quoted-printable

Tried adding the path to ldconfig rather than redefining ld_library_path?

On 18 Sep 2011, at 09:03, Scott Marlowe <scott.marlowe@gmail.com> wrote:

> Wow, you got me.
>
> On Sun, Sep 18, 2011 at 12:56 AM, Rural Hunter <ruralhunter@gmail.com> wr=
ote:
>> 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:d=
o=3D01;35:bd=3D40;33;01:cd=3D40;33;01:or=3D40;31;01:su=3D37;41:sg=3D30;43:c=
a=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:*.tlz=3D0=
1;31:*.txz=3D01;31:*.zip=3D01;31:*.z=3D01;31:*.Z=3D01;31:*.dz=3D01;31:*.gz=
=3D01;31:*.lz=3D01;31:*.xz=3D01;31:*.bz2=3D01;31:*.bz=3D01;31:*.tbz=3D01;31=
:*.tbz2=3D01;31:*.tz=3D01;31:*.deb=3D01;31:*.rpm=3D01;31:*.jar=3D01;31:*.ra=
r=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=3D01;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=3D=
01;35:*.pcx=3D01;35:*.mov=3D01;35:*.mpg=3D01;35:*.mpeg=3D01;35:*.m2v=3D01;3=
5:*.mkv=3D01;35:*.ogm=3D01;35:*.mp4=3D01;35:*.m4v=3D01;35:*.mp4v=3D01;35:*.=
vob=3D01;35:*.qt=3D01;35:*.nuv=3D01;35:*.wmv=3D01;35:*.asf=3D01;35:*.rm=3D0=
1;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:*.anx=
=3D01;35:*.ogv=3D01;35:*.ogx=3D01;35:*.aac=3D00;36:*.au=3D00;36:*.flac=3D00=
;36:*.mid=3D00;36:*.midi=3D00;36:*.mka=3D00;36:*.mp3=3D00;36:*.mpc=3D00;36:=
*.ogg=3D00;36:*.ra=3D00;36:*.wav=3D00;36:*.axa=3D00;36:*.oga=3D00;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/Pos=
tgreSQL/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.
>>
>> =D3=DA2011=C4=EA9=D4=C218=C8=D5 13:31:45,Scott Marlowe=D0=B4=B5=BD:
>>>
>>> 2011/9/17 Rural Hunter<ruralhunter@gmail.com>:
>>>>
>>>> I installed pgsql 9.1 on Ubuntu server(10.10). Now I have a problem wi=
th
>>>> the
>>>> required env variable LD_LIBRARY_PATH. If I do not set this, I can not
>>>> use
>>>> some pg tools such as pg_dump, createuser...etc. If I set this variabl=
e,
>>>> my
>>>> term gets warning "unknown terminal type" for some linux commands such=
 as
>>>> top/vi so that I can not use them normally:
>>>> postgres@backup:~$ top
>>>> 'linux': unknown terminal type.
>>>
>>> How exactly are you setting it?
>>>
>>
>>
>>
>
>
>
> --
> To understand recursion, one must first understand recursion.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin