Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id C38B1B5DBCE for ; Sun, 18 Sep 2011 03:57:14 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 19656-07 for ; Sun, 18 Sep 2011 06:57:08 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from mail-iy0-f174.google.com (mail-iy0-f174.google.com [209.85.210.174]) by mail.postgresql.org (Postfix) with ESMTP id 4C997B5DBC8 for ; Sun, 18 Sep 2011 03:57:08 -0300 (ADT) Received: by iaqq3 with SMTP id q3so3973240iaq.19 for ; Sat, 17 Sep 2011 23:57:07 -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=EkGHLkQftG9dmMtjU3epFD6ZHqYRMAFZxaeZ/AwFZdQ=; b=PP2j88r5JMHuORJdv7eIXW30FkHndSJXypecHK7P6L4dfiyPTUWx7BN1m2uQUbrnSx CauVCZU9kD7FmaPYzWPuPr63HOpRGx2YKSqJ1BaT2rj1QAVWD8dIOXgPQJ+N872PNTvO x3KhYt2IclU/2SUvGhMy4XCtNc5QPYZymVqpk= Received: by 10.68.34.34 with SMTP id w2mr2226043pbi.174.1316329027499; Sat, 17 Sep 2011 23:57:07 -0700 (PDT) Received: from [192.168.11.3] ([114.85.128.121]) by mx.google.com with ESMTPS id 4sm52784961pbk.5.2011.09.17.23.56.59 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 17 Sep 2011 23:57:06 -0700 (PDT) Message-ID: <4E759637.1060600@gmail.com> Date: Sun, 18 Sep 2011 14:56:55 +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: Scott Marlowe CC: pgsql-admin@postgresql.org Subject: Re: Problem of LD_LIBRARY_PATH References: <4E755BCB.6080706@gmail.com> In-Reply-To: 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/117 X-Sequence-Number: 38354 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? >