Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 7199FB5DBF2 for ; Sun, 18 Sep 2011 07:24:50 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 94513-06 for ; Sun, 18 Sep 2011 10:24:43 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from mail-pz0-f42.google.com (mail-pz0-f42.google.com [209.85.210.42]) by mail.postgresql.org (Postfix) with ESMTP id 41380B5DBC5 for ; Sun, 18 Sep 2011 07:24:43 -0300 (ADT) Received: by pzk1 with SMTP id 1so7553368pzk.1 for ; Sun, 18 Sep 2011 03:24:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; bh=luNuJMORn4A+wCvvZ2/mugzccs2dTA6aDpcFawj3zQc=; b=kLXEzDs4tFeSSH3GTpsAkqPZLfKGhM/XvGckHxpyqeJ1G3zUhPjotyzVNm88nqg82z fRmldRpcWEodVLDRmLYu0vFVIZ0VgVR9q+n802jAJ6lWsX8aOwjKh5nd2USN+uCJVySw P0JsNO7TIQJvNCjqF1pGAAjTF1gXWdFFLSjIc= Received: by 10.68.47.167 with SMTP id e7mr2455724pbn.286.1316341482252; Sun, 18 Sep 2011 03:24:42 -0700 (PDT) Received: from [192.168.11.3] ([114.85.128.121]) by mx.google.com with ESMTPS id h5sm54524974pbq.11.2011.09.18.03.24.35 (version=TLSv1/SSLv3 cipher=OTHER); Sun, 18 Sep 2011 03:24:40 -0700 (PDT) Message-ID: <4E75C6D5.1090308@gmail.com> Date: Sun, 18 Sep 2011 18:24:21 +0800 From: Rural Hunter User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2 MIME-Version: 1.0 To: Richard Shaw CC: "pgsql-admin@postgresql.org" , Scott Marlowe Subject: Re: Problem of LD_LIBRARY_PATH References: <4E755BCB.6080706@gmail.com> <4E759637.1060600@gmail.com> <-3767666986360044590@unknownmsgid> In-Reply-To: <-3767666986360044590@unknownmsgid> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001 X-Spam-Level: X-Archive-Number: 201109/123 X-Sequence-Number: 38360 yes, tried that too and same thing happened. 于2011年9月18日 17:09:25,Richard Shaw写到: > Tried adding the path to ldconfig rather than redefining ld_library_path? > > On 18 Sep 2011, at 09:03, Scott Marlowe wrote: > >> Wow, you got me. >> >> On Sun, Sep 18, 2011 at 12:56 AM, 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. >>> >>> 于2011年9月18日 13:31:45,Scott Marlowe写到: >>>> >>>> 2011/9/17 Rural Hunter: >>>>> >>>>> I installed pgsql 9.1 on Ubuntu server(10.10). Now I have a problem with >>>>> 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 variable, >>>>> 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 >