[postgres@localhost ~]$ /opt/PostgreSQL/9.0/bin/psql -p 5432
psql.bin (9.0.5)
Type "help" for help.
postgres=# \l
*** glibc detected *** /opt/PostgreSQL/9.0/bin/psql.bin: realloc(): invalid next size: 0x000000000214c1e0 ***
======= Backtrace: =========
/lib64/libc.so.6[0x3116478158]
/lib64/libc.so.6[0x311647c441]
/lib64/libc.so.6(realloc+0x12e)[0x311647d2ce]
/opt/PostgreSQL/9.0/bin/../lib/libpq.so.5(enlargePQExpBuffer+0x66)[0x1271f6]
/opt/PostgreSQL/9.0/bin/../lib/libpq.so.5(appendPQExpBuffer+0xdb)[0x1273fb]
/opt/PostgreSQL/9.0/bin/psql.bin[0x417fe5]
/opt/PostgreSQL/9.0/bin/psql.bin[0x405e17]
/opt/PostgreSQL/9.0/bin/psql.bin[0x40db88]
/opt/PostgreSQL/9.0/bin/psql.bin[0x40fb2e]
/lib64/libc.so.6(__libc_start_main+0xfa)[0x311641e32a]
/opt/PostgreSQL/9.0/bin/psql.bin[0x403a69]
======= Memory map: ========
00110000-00133000 r-xp 00000000 fd:00 3311343 /opt/PostgreSQL/9.0/lib/libpq.so.5
00133000-00332000 ---p 00023000 fd:00 3311343 /opt/PostgreSQL/9.0/lib/libpq.so.5
00332000-00335000 rw-p 00022000 fd:00 3311343 /opt/PostgreSQL/9.0/lib/libpq.so.5
00400000-00456000 r-xp 00000000 fd:00 3309756 /opt/PostgreSQL/9.0/bin/psql.bin
00655000-00656000 rw-p 00055000 fd:00 3309756 /opt/PostgreSQL/9.0/bin/psql.bin
00656000-00657000 rw-p 00656000 00:00 0
00657000-0068f000 r-xp 00000000 fd:00 3311349 /opt/PostgreSQL/9.0/lib/libxslt.so.1
0068f000-0088e000 ---p 00038000 fd:00 3311349 /opt/PostgreSQL/9.0/lib/libxslt.so.1
0088e000-00890000 rw-p 00037000 fd:00 3311349 /opt/PostgreSQL/9.0/lib/libxslt.so.1
00890000-009c8000 r-xp 00000000 fd:00 3311348 /opt/PostgreSQL/9.0/lib/libxml2.so.2
009c8000-00bc7000 ---p 00138000 fd:00 3311348 /opt/PostgreSQL/9.0/lib/libxml2.so.2
00bc7000-00bd1000 rw-p 00137000 fd:00 3311348 /opt/PostgreSQL/9.0/lib/libxml2.so.2
00bd1000-00bd2000 rw-p 00bd1000 00:00 0
00bd2000-00bfa000 r-xp 00000000 fd:00 3311332 /opt/PostgreSQL/9.0/lib/libedit.so
00bfa000-00df9000 ---p 00028000 fd:00 3311332 /opt/PostgreSQL/9.0/lib/libedit.so
00df9000-00dfc000 rw-p 00027000 fd:00 3311332 /opt/PostgreSQL/9.0/lib/libedit.so
00dfc000-00e07000 r-xp 00000000 fd:00 1179676 /lib64/libnss_files-2.8.so
00e07000-01006000 ---p 0000b000 fd:00 1179676 /lib64/libnss_files-2.8.so
01006000-01007000 r--p 0000a000 fd:00 1179676 /lib64/libnss_files-2.8.so
01007000-01008000 rw-p 0000b000 fd:00 1179676 /lib64/libnss_files-2.8.so
02136000-02157000 rw-p 02136000 00:00 0 [heap]
02874000-0288a000 r-xp 00000000 fd:00 1180000 /lib64/libgcc_s-4.3.0-20080428.so.1
0288a000-02a89000 ---p 00016000 fd:00 1180000 /lib64/libgcc_s-4.3.0-20080428.so.1
02a89000-02a8a000 rw-p 00015000 fd:00 1180000 /lib64/libgcc_s-4.3.0-20080428.so.1
3115200000-311521d000 r-xp 00000000 fd:00 1179965 /lib64/ld-2.8.so
311541c000-311541d000 r--p 0001c000 fd:00 1179965 /lib64/ld-2.8.so
311541d000-311541e000 rw-p 0001d000 fd:00 1179965 /lib64/ld-2.8.so
3116400000-3116562000 r-xp 00000000 fd:00 1179966 /lib64/libc-2.8.so
3116562000-3116762000 ---p 00162000 fd:00 1179966 /lib64/libc-2.8.so
3116762000-3116766000 r--p 00162000 fd:00 1179966 /lib64/libc-2.8.so
3116766000-3116767000 rw-p 00166000 fd:00 1179966 /lib64/libc-2.8.so
3116767000-311676c000 rw-p 3116767000 00:00 0
3116800000-3116884000 r-xp 00000000 fd:00 1179970 /lib64/libm-2.8.so
3116884000-3116a83000 ---p 00084000 fd:00 1179970 /lib64/libm-2.8.so
3116a83000-3116a84000 r--p 00083000 fd:00 1179970 /lib64/libm-2.8.so
3116a84000-3116a85000 rw-p 00084000 fd:00 1179970 /lib64/libm-2.8.so
3116c00000-3116c02000 r-xp 00000000 fd:00 1179969 /lib64/libdl-2.8.so
3116c02000-3116e02000 ---p 00002000 fd:00 1179969 /lib64/libdl-2.8.so
3116e02000-3116e03000 r--p 00002000 fd:00 1179969 /lib64/libdl-2.8.so
3116e03000-3116e04000 rw-p 00003000 fd:00 1179969 /lib64/libdl-2.8.so
3117000000-3117016000 r-xp 00000000 fd:00 1179973 /lib64/libpthread-2.8.so
3117016000-3117215000 ---p 00016000 fd:00 1179973 /lib64/libpthread-2.8.so
3117215000-3117216000 r--p 00015000 fd:00 1179973 /lib64/libpthread-2.8.so
3117216000-3117217000 rw-p 00016000 fd:00 1179973 /lib64/libpthread-2.8.so
3117217000-311721b000 rw-p 3117217000 00:00 0
3117400000-311741a000 r-xp 00000000 fd:00 1179974 /lib64/libselinux.so.1
311741a000-3117619000 ---p 0001a000 fd:00 1179974 /lib64/libselinux.so.1
3117619000-311761a000 r--p 00019000 fd:00 1179974 /lib64/libselinux.so.1
311761a000-311761b000 rw-p 0001a000 fd:00 1179974 /lib64/libselinux.so.1
311761b000-311761c000 rw-p 311761b000 00:00 0
3117800000-3117815000 r-xp 00000000 fd:00 1179980 /lib64/libz.so.1.2.3
3117815000-3117a14000 ---p 00015000 fd:00 1179980 /lib64/libz.so.1.2.3
3117a14000-3117a15000 rw-p 00014000 fd:00 1179980 /lib64/libz.so.1.2.3
3120800000-3120811000 r-xp 00000000 fd:00 1179967 /lib64/libresolv-2.8.so
3120811000-3120a11000 ---p 00011000 fd:00 1179967 /lib64/libresolv-2.8.so
3120a11000-3120a12000 r--p 00011000 fd:00 1179967 /lib64/libresolv-2.8.so
3120a12000-3120a13000 rw-p 00012000 fd:00 1179967 /lib64/libresolv-2.8.so
3120a13000-3120a15000 rw-p 3120a13000 00:00 0
3120c00000-3120c17000 r-xp 00000000 fd:00 1180005 /lib64/libaudit.so.0.0.0
3120c17000-3120e17000 ---p 00017000 fd:00 1180005 /lib64/libaudit.so.0.0.0
3120e17000-3120e18000 r--p 00017000 fd:00 1180005 /lib64/libaudit.so.0.0.0
3120e18000-3120e19000 rw-p 00018000 fd:00 1180005 /lib64/libaudit.so.0.0.0
3121000000-3121002000 r-xp 00000000 fd:00 1179985 /lib64/libcom_err.so.2.1
3121002000-3121201000 ---p 00002000 fd:00 1179985 /lib64/libcom_err.so.2.1
3121201000-3121202000 rw-p 00001000 fd:00 1179985 /lib64/libcom_err.so.2.1
3121400000-312140b000 r-xp 00000000 fd:00 1180006 /lib64/libpam.so.0.81.12
312140b000-312160b000 ---p 0000b000 fd:00 1180006 /lib64/libpam.so.0.81.12
312160b000-312160c000 rw-p 0000b000 fd:00 1180006 /lib64/libpam.so.0.81.12
3122400000-3122409000 r-xp 00000000 fd:00 1179971 /lib64/libcrypt-2.8.so
3122409000-3122608000 ---p 00009000 fd:00 1179971 /lib64/libcrypt-2.8.so
3122608000-3122609000 r--p 00008000 fd:00 1179971 /lib64/libcrypt-2.8.so
3122609000-312260a000 rw-p 00009000 fd:00 1179971 /lib64/libcrypt-2.8.so
312260a000-3122638000 rw-p 312260a000 00:00 0
3123800000-312382e000 r-xp 00000000 fd:00 5316643 /usr/lib64/libgssapi_krb5.so.2.2
312382e000-3123a2d000 ---p 0002e000 fd:00 5316643 /usr/lib64/libgssapi_krb5.so.2.2
3123a2d000-3123a2f000 rw-p 0002d000 fd:00 5316643 /usr/lib64/libgssapi_krb5.so.2.2
3123c00000-3123c02000 r-xp 00000000 fd:00 1179984 /lib64/libkeyutils-1.2.so
3123c02000-3123e01000 ---p 00002000 fd:00 1179984 /lib64/libkeyutils-1.2.so
3123e01000-3123e02000 rw-p 00001000 fd:00 1179984 /lib64/libkeyutils-1.2.so
3124000000-3124008000 r-xp 00000000 fd:00 5316640 /usr/lib64/libkrb5support.so.0.1
3124008000-3124207000 ---p 00008000 fd:00 5316640 /usr/lib64/libkrb5support.so.0.1
3124207000-3124208000 rw-p 00007000 fd:00 5316640 /usr/lib64/libkrb5support.so.0.1
3124400000-3124424000 r-xp 00000000 fd:00 5316641 /usr/lib64/libk5crypto.so.3.1
3124424000-3124623000 ---p 00024000 fd:00 5316641 /usr/lib64/libk5crypto.so.3.1
3124623000-3124625000 rw-p 00023000 fd:00 5316641 /usr/lib64/libk5crypto.so.3.1
3124800000-312489f000 r-xp 00000000 fd:00 5316642 /usr/lib64/libkrb5.so.3.3
312489f000-3124a9e000 ---p 0009f000 fd:00 5316642 /usr/lib64/libkrb5.so.3.3
3124a9e000-3124aa2000 rw-p 0009e000 fd:00 5316642 /usr/lib64/libkrb5.so.3.3
3498200000-349824e000 r-xp 00000000 fd:00 3311334 /opt/PostgreSQL/9.0/lib/libncurses.so.5.5
349824e000-349844e000 ---p 0004e000 fd:00 3311334 /opt/PostgreSQL/9.0/lib/libncurses.so.5.5
349844e000-349845c000 rw-p 0004e000 fd:00 3311334 /opt/PostgreSQL/9.0/lib/libncurses.so.5.5
349845c000-349845d000 rw-p 349845c000 00:00 0
3f74800000-3f7492d000 r-xp 00000000 fd:00 3311323 /opt/PostgreSQL/9.0/lib/libcrypto.so.6
3f7492d000-3f74b2c000 ---p 0012d000 fd:00 3311323 /opt/PostgreSQL/9.0/lib/libcrypto.so.6
3f74b2c000-3f74b4d000 rw-p 0012c000 fd:00 3311323 /opt/PostgreSQL/9.0/lib/libcrypto.so.6
3f74b4d000-3f74b51000 rw-p 3f74b4d000 00:00 0
3f74c00000-3f74c46000 r-xp /opt/PostgreSQL/9.0/bin/psql: line 21: 19271 Aborted "$PG_BIN_PATH/psql.bin" "$@"
[postgres@localhost ~]$ exit
logout
[root@localhost Download]# which psql
/usr/bin/which: no psql in (/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)
[root@localhost Download]# /opt/PostgreSQL/9.0/bin/psql -U postgres -d postgres
Password for user postgres:
psql.bin (9.0.5)
Type "help" for help.
postgres=# \dt
No relations found.
postgres=# \q
[root@localhost Download]# yum install libedit*
Loaded plugins: refresh-packagekit
fedora | 2.4 kB 00:00
updates | 2.6 kB 00:00
Setting up Install Process
Parsing package install arguments
Package libedit-2.10-4.20070831cvs.fc9.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package libedit-devel.x86_64 0:2.10-4.20070831cvs.fc9 set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================
Package Arch Version Repository Size
=============================================================================
Installing:
libedit-devel x86_64 2.10-4.20070831cvs.fc9 fedora 25 k
Transaction Summary
=============================================================================
Install 1 Package(s)
Update 0 Package(s)
Remove 0 Package(s)
Total download size: 25 k
Is this ok [y/N]: y
Downloading Packages:
(1/1): libedit-devel-2.10-4.20070831cvs.fc9.x86_64.rpm | 25 kB 00:00
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing: libedit-devel ######################### [1/1]
Installed: libedit-devel.x86_64 0:2.10-4.20070831cvs.fc9
Complete!
[root@localhost Download]# yum install libreadline*
Loaded plugins: refresh-packagekit
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package libreadline-java.x86_64 0:0.8.0-20.fc9 set to be updated
---> Package libreadline-java-javadoc.x86_64 0:0.8.0-20.fc9 set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================
Package Arch Version Repository Size
=============================================================================
Installing:
libreadline-java x86_64 0.8.0-20.fc9 fedora 50 k
libreadline-java-javadoc x86_64 0.8.0-20.fc9 fedora 20 k
Transaction Summary
=============================================================================
Install 2 Package(s)
Update 0 Package(s)
Remove 0 Package(s)
Total download size: 70 k
Is this ok [y/N]: y
Downloading Packages:
(1/2): libreadline-java-javadoc-0.8.0-20.fc9.x86_64.rpm | 20 kB 00:00
(2/2): libreadline-java-0.8.0-20.fc9.x86_64.rpm | 50 kB 00:00
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing: libreadline-java ######################### [1/2]
Installing: libreadline-java-javadoc ######################### [2/2]
Installed: libreadline-java.x86_64 0:0.8.0-20.fc9 libreadline-java-javadoc.x86_64 0:0.8.0-20.fc9
Complete!
[root@localhost Download]# clear
[root@localhost Download]# cd /opt/PostgreSQL/9.0/lib/
[root@localhost lib]# ls -lrth
total 9.0M
-rw-r--r-- 1 postgres postgres 50K 2011-09-23 11:15 libpgport.a
-rw-r--r-- 1 postgres postgres 255K 2011-09-23 11:15 libpq.a
-rw-r--r-- 1 postgres postgres 99K 2011-09-23 11:15 libpgtypes.a
-rw-r--r-- 1 postgres postgres 19K 2011-09-23 11:15 libecpg_compat.a
-rw-r--r-- 1 postgres postgres 147K 2011-09-23 11:15 libecpg.a
-rwxr-xr-- 1 postgres postgres 372K 2011-09-23 11:17 libncurses.so.5.5
-rw-r--r-- 1 postgres postgres 51K 2011-09-23 11:17 libuuid.so.16.0.22
-rwxr-xr-- 1 postgres postgres 18K 2011-09-23 11:17 libuuid.so.1.2
-rwxr-xr-- 1 postgres postgres 147K 2011-09-23 11:17 libpng12.so.0.10.0
-rwxr-xr-- 1 postgres postgres 136K 2011-09-23 11:17 libjpeg.so.62.0.0
-rwxr-xr-- 1 postgres postgres 308K 2011-09-23 11:17 libssl.so.6
-rwxr-xr-- 1 postgres postgres 1.4M 2011-09-23 11:17 libcrypto.so.6
-rwxr-xr-- 1 postgres postgres 189K 2011-09-23 11:17 libedit.so
-rwxr-xr-- 1 postgres postgres 4.0M 2011-09-23 11:17 libxml2.so.2
-rwxr-xr-- 1 postgres postgres 804K 2011-09-23 11:38 libxslt.so.1
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so.5.3
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so.5
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so.3.1
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so.3
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so.6.2
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so.6
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so.3.2
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so.3
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so
drwxr-xr-x 4 postgres postgres 4.0K 2011-10-13 08:21 postgresql
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libuuid.so.16 -> libuuid.so.16.0.22
lrwxrwxrwx 1 postgres postgres 14 2011-10-13 08:21 libuuid.so.1 -> libuuid.so.1.2
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libuuid.so -> libuuid.so.16.0.22
lrwxrwxrwx 1 postgres postgres 13 2011-10-13 08:21 libtermcap.so.2 -> libncurses.so
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libpng12.so.0 -> libpng12.so.0.10.0
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libpng12.so -> libpng12.so.0.10.0
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libncurses.so.5 -> libncurses.so.5.5
lrwxrwxrwx 1 postgres postgres 15 2011-10-13 08:21 libncurses.so -> libncurses.so.5
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libjpeg.so.62 -> libjpeg.so.62.0.0
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libjpeg.so -> libjpeg.so.62.0.0
[root@localhost lib]# ls libedit.so
libedit.so
[root@localhost lib]# find / -name libedit* 2>/dev/null
/opt/PostgreSQL/9.0/lib/libedit.so
/usr/lib64/libedit.so
[root@localhost lib]# ls -lrth /usr/lib64/libedit.so
lrwxrwxrwx 1 root root 17 2011-10-13 09:00 /usr/lib64/libedit.so -> libedit.so.0.0.26
[root@localhost lib]# mv libedit.so libedit.so.bak
[root@localhost lib]# ln -s /usr/lib64/libedit.so libedit.so
[root@localhost lib]# ls -lrth
total 9.0M
-rw-r--r-- 1 postgres postgres 50K 2011-09-23 11:15 libpgport.a
-rw-r--r-- 1 postgres postgres 255K 2011-09-23 11:15 libpq.a
-rw-r--r-- 1 postgres postgres 99K 2011-09-23 11:15 libpgtypes.a
-rw-r--r-- 1 postgres postgres 19K 2011-09-23 11:15 libecpg_compat.a
-rw-r--r-- 1 postgres postgres 147K 2011-09-23 11:15 libecpg.a
-rwxr-xr-- 1 postgres postgres 372K 2011-09-23 11:17 libncurses.so.5.5
-rw-r--r-- 1 postgres postgres 51K 2011-09-23 11:17 libuuid.so.16.0.22
-rwxr-xr-- 1 postgres postgres 18K 2011-09-23 11:17 libuuid.so.1.2
-rwxr-xr-- 1 postgres postgres 147K 2011-09-23 11:17 libpng12.so.0.10.0
-rwxr-xr-- 1 postgres postgres 136K 2011-09-23 11:17 libjpeg.so.62.0.0
-rwxr-xr-- 1 postgres postgres 308K 2011-09-23 11:17 libssl.so.6
-rwxr-xr-- 1 postgres postgres 1.4M 2011-09-23 11:17 libcrypto.so.6
-rwxr-xr-- 1 postgres postgres 189K 2011-09-23 11:17 libedit.so.bak
-rwxr-xr-- 1 postgres postgres 4.0M 2011-09-23 11:17 libxml2.so.2
-rwxr-xr-- 1 postgres postgres 804K 2011-09-23 11:38 libxslt.so.1
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so.5.3
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so.5
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so.3.1
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so.3
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so.6.2
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so.6
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so.3.2
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so.3
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so
drwxr-xr-x 4 postgres postgres 4.0K 2011-10-13 08:21 postgresql
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libuuid.so.16 -> libuuid.so.16.0.22
lrwxrwxrwx 1 postgres postgres 14 2011-10-13 08:21 libuuid.so.1 -> libuuid.so.1.2
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libuuid.so -> libuuid.so.16.0.22
lrwxrwxrwx 1 postgres postgres 13 2011-10-13 08:21 libtermcap.so.2 -> libncurses.so
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libpng12.so.0 -> libpng12.so.0.10.0
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libpng12.so -> libpng12.so.0.10.0
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libncurses.so.5 -> libncurses.so.5.5
lrwxrwxrwx 1 postgres postgres 15 2011-10-13 08:21 libncurses.so -> libncurses.so.5
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libjpeg.so.62 -> libjpeg.so.62.0.0
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libjpeg.so -> libjpeg.so.62.0.0
lrwxrwxrwx 1 root root 21 2011-10-13 09:02 libedit.so -> /usr/lib64/libedit.so
[root@localhost lib]# chown -R postgres:postgres libedit.so
[root@localhost lib]# ls -lrth
total 9.0M
-rw-r--r-- 1 postgres postgres 50K 2011-09-23 11:15 libpgport.a
-rw-r--r-- 1 postgres postgres 255K 2011-09-23 11:15 libpq.a
-rw-r--r-- 1 postgres postgres 99K 2011-09-23 11:15 libpgtypes.a
-rw-r--r-- 1 postgres postgres 19K 2011-09-23 11:15 libecpg_compat.a
-rw-r--r-- 1 postgres postgres 147K 2011-09-23 11:15 libecpg.a
-rwxr-xr-- 1 postgres postgres 372K 2011-09-23 11:17 libncurses.so.5.5
-rw-r--r-- 1 postgres postgres 51K 2011-09-23 11:17 libuuid.so.16.0.22
-rwxr-xr-- 1 postgres postgres 18K 2011-09-23 11:17 libuuid.so.1.2
-rwxr-xr-- 1 postgres postgres 147K 2011-09-23 11:17 libpng12.so.0.10.0
-rwxr-xr-- 1 postgres postgres 136K 2011-09-23 11:17 libjpeg.so.62.0.0
-rwxr-xr-- 1 postgres postgres 308K 2011-09-23 11:17 libssl.so.6
-rwxr-xr-- 1 postgres postgres 1.4M 2011-09-23 11:17 libcrypto.so.6
-rwxr-xr-- 1 postgres postgres 189K 2011-09-23 11:17 libedit.so.bak
-rwxr-xr-- 1 postgres postgres 4.0M 2011-09-23 11:17 libxml2.so.2
-rwxr-xr-- 1 postgres postgres 804K 2011-09-23 11:38 libxslt.so.1
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so.5.3
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so.5
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so.3.1
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so.3
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so.6.2
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so.6
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so.3.2
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so.3
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so
drwxr-xr-x 4 postgres postgres 4.0K 2011-10-13 08:21 postgresql
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libuuid.so.16 -> libuuid.so.16.0.22
lrwxrwxrwx 1 postgres postgres 14 2011-10-13 08:21 libuuid.so.1 -> libuuid.so.1.2
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libuuid.so -> libuuid.so.16.0.22
lrwxrwxrwx 1 postgres postgres 13 2011-10-13 08:21 libtermcap.so.2 -> libncurses.so
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libpng12.so.0 -> libpng12.so.0.10.0
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libpng12.so -> libpng12.so.0.10.0
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libncurses.so.5 -> libncurses.so.5.5
lrwxrwxrwx 1 postgres postgres 15 2011-10-13 08:21 libncurses.so -> libncurses.so.5
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libjpeg.so.62 -> libjpeg.so.62.0.0
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libjpeg.so -> libjpeg.so.62.0.0
lrwxrwxrwx 1 postgres postgres 21 2011-10-13 09:02 libedit.so -> /usr/lib64/libedit.so
[root@localhost lib]# clear
[root@localhost lib]# sudo su - postgres
[postgres@localhost ~]$ psql
-bash: psql: command not found
[postgres@localhost ~]$ pwd
/home/postgres
[postgres@localhost ~]$ cd /opt/PostgreSQL/9.0/bin/
[postgres@localhost bin]$ ./psql
psql.bin (9.0.5)
Type "help" for help.
postgres=# \dt
No relations found.
postgres=# \dt
No relations found.
postgres=# \q
[postgres@localhost bin]$
psql.bin (9.0.5)
Type "help" for help.
postgres=# \l
*** glibc detected *** /opt/PostgreSQL/9.0/bin/psql.bin: realloc(): invalid next size: 0x000000000214c1e0 ***
======= Backtrace: =========
/lib64/libc.so.6[0x3116478158]
/lib64/libc.so.6[0x311647c441]
/lib64/libc.so.6(realloc+0x12e)[0x311647d2ce]
/opt/PostgreSQL/9.0/bin/../lib/libpq.so.5(enlargePQExpBuffer+0x66)[0x1271f6]
/opt/PostgreSQL/9.0/bin/../lib/libpq.so.5(appendPQExpBuffer+0xdb)[0x1273fb]
/opt/PostgreSQL/9.0/bin/psql.bin[0x417fe5]
/opt/PostgreSQL/9.0/bin/psql.bin[0x405e17]
/opt/PostgreSQL/9.0/bin/psql.bin[0x40db88]
/opt/PostgreSQL/9.0/bin/psql.bin[0x40fb2e]
/lib64/libc.so.6(__libc_start_main+0xfa)[0x311641e32a]
/opt/PostgreSQL/9.0/bin/psql.bin[0x403a69]
======= Memory map: ========
00110000-00133000 r-xp 00000000 fd:00 3311343 /opt/PostgreSQL/9.0/lib/libpq.so.5
00133000-00332000 ---p 00023000 fd:00 3311343 /opt/PostgreSQL/9.0/lib/libpq.so.5
00332000-00335000 rw-p 00022000 fd:00 3311343 /opt/PostgreSQL/9.0/lib/libpq.so.5
00400000-00456000 r-xp 00000000 fd:00 3309756 /opt/PostgreSQL/9.0/bin/psql.bin
00655000-00656000 rw-p 00055000 fd:00 3309756 /opt/PostgreSQL/9.0/bin/psql.bin
00656000-00657000 rw-p 00656000 00:00 0
00657000-0068f000 r-xp 00000000 fd:00 3311349 /opt/PostgreSQL/9.0/lib/libxslt.so.1
0068f000-0088e000 ---p 00038000 fd:00 3311349 /opt/PostgreSQL/9.0/lib/libxslt.so.1
0088e000-00890000 rw-p 00037000 fd:00 3311349 /opt/PostgreSQL/9.0/lib/libxslt.so.1
00890000-009c8000 r-xp 00000000 fd:00 3311348 /opt/PostgreSQL/9.0/lib/libxml2.so.2
009c8000-00bc7000 ---p 00138000 fd:00 3311348 /opt/PostgreSQL/9.0/lib/libxml2.so.2
00bc7000-00bd1000 rw-p 00137000 fd:00 3311348 /opt/PostgreSQL/9.0/lib/libxml2.so.2
00bd1000-00bd2000 rw-p 00bd1000 00:00 0
00bd2000-00bfa000 r-xp 00000000 fd:00 3311332 /opt/PostgreSQL/9.0/lib/libedit.so
00bfa000-00df9000 ---p 00028000 fd:00 3311332 /opt/PostgreSQL/9.0/lib/libedit.so
00df9000-00dfc000 rw-p 00027000 fd:00 3311332 /opt/PostgreSQL/9.0/lib/libedit.so
00dfc000-00e07000 r-xp 00000000 fd:00 1179676 /lib64/libnss_files-2.8.so
00e07000-01006000 ---p 0000b000 fd:00 1179676 /lib64/libnss_files-2.8.so
01006000-01007000 r--p 0000a000 fd:00 1179676 /lib64/libnss_files-2.8.so
01007000-01008000 rw-p 0000b000 fd:00 1179676 /lib64/libnss_files-2.8.so
02136000-02157000 rw-p 02136000 00:00 0 [heap]
02874000-0288a000 r-xp 00000000 fd:00 1180000 /lib64/libgcc_s-4.3.0-20080428.so.1
0288a000-02a89000 ---p 00016000 fd:00 1180000 /lib64/libgcc_s-4.3.0-20080428.so.1
02a89000-02a8a000 rw-p 00015000 fd:00 1180000 /lib64/libgcc_s-4.3.0-20080428.so.1
3115200000-311521d000 r-xp 00000000 fd:00 1179965 /lib64/ld-2.8.so
311541c000-311541d000 r--p 0001c000 fd:00 1179965 /lib64/ld-2.8.so
311541d000-311541e000 rw-p 0001d000 fd:00 1179965 /lib64/ld-2.8.so
3116400000-3116562000 r-xp 00000000 fd:00 1179966 /lib64/libc-2.8.so
3116562000-3116762000 ---p 00162000 fd:00 1179966 /lib64/libc-2.8.so
3116762000-3116766000 r--p 00162000 fd:00 1179966 /lib64/libc-2.8.so
3116766000-3116767000 rw-p 00166000 fd:00 1179966 /lib64/libc-2.8.so
3116767000-311676c000 rw-p 3116767000 00:00 0
3116800000-3116884000 r-xp 00000000 fd:00 1179970 /lib64/libm-2.8.so
3116884000-3116a83000 ---p 00084000 fd:00 1179970 /lib64/libm-2.8.so
3116a83000-3116a84000 r--p 00083000 fd:00 1179970 /lib64/libm-2.8.so
3116a84000-3116a85000 rw-p 00084000 fd:00 1179970 /lib64/libm-2.8.so
3116c00000-3116c02000 r-xp 00000000 fd:00 1179969 /lib64/libdl-2.8.so
3116c02000-3116e02000 ---p 00002000 fd:00 1179969 /lib64/libdl-2.8.so
3116e02000-3116e03000 r--p 00002000 fd:00 1179969 /lib64/libdl-2.8.so
3116e03000-3116e04000 rw-p 00003000 fd:00 1179969 /lib64/libdl-2.8.so
3117000000-3117016000 r-xp 00000000 fd:00 1179973 /lib64/libpthread-2.8.so
3117016000-3117215000 ---p 00016000 fd:00 1179973 /lib64/libpthread-2.8.so
3117215000-3117216000 r--p 00015000 fd:00 1179973 /lib64/libpthread-2.8.so
3117216000-3117217000 rw-p 00016000 fd:00 1179973 /lib64/libpthread-2.8.so
3117217000-311721b000 rw-p 3117217000 00:00 0
3117400000-311741a000 r-xp 00000000 fd:00 1179974 /lib64/libselinux.so.1
311741a000-3117619000 ---p 0001a000 fd:00 1179974 /lib64/libselinux.so.1
3117619000-311761a000 r--p 00019000 fd:00 1179974 /lib64/libselinux.so.1
311761a000-311761b000 rw-p 0001a000 fd:00 1179974 /lib64/libselinux.so.1
311761b000-311761c000 rw-p 311761b000 00:00 0
3117800000-3117815000 r-xp 00000000 fd:00 1179980 /lib64/libz.so.1.2.3
3117815000-3117a14000 ---p 00015000 fd:00 1179980 /lib64/libz.so.1.2.3
3117a14000-3117a15000 rw-p 00014000 fd:00 1179980 /lib64/libz.so.1.2.3
3120800000-3120811000 r-xp 00000000 fd:00 1179967 /lib64/libresolv-2.8.so
3120811000-3120a11000 ---p 00011000 fd:00 1179967 /lib64/libresolv-2.8.so
3120a11000-3120a12000 r--p 00011000 fd:00 1179967 /lib64/libresolv-2.8.so
3120a12000-3120a13000 rw-p 00012000 fd:00 1179967 /lib64/libresolv-2.8.so
3120a13000-3120a15000 rw-p 3120a13000 00:00 0
3120c00000-3120c17000 r-xp 00000000 fd:00 1180005 /lib64/libaudit.so.0.0.0
3120c17000-3120e17000 ---p 00017000 fd:00 1180005 /lib64/libaudit.so.0.0.0
3120e17000-3120e18000 r--p 00017000 fd:00 1180005 /lib64/libaudit.so.0.0.0
3120e18000-3120e19000 rw-p 00018000 fd:00 1180005 /lib64/libaudit.so.0.0.0
3121000000-3121002000 r-xp 00000000 fd:00 1179985 /lib64/libcom_err.so.2.1
3121002000-3121201000 ---p 00002000 fd:00 1179985 /lib64/libcom_err.so.2.1
3121201000-3121202000 rw-p 00001000 fd:00 1179985 /lib64/libcom_err.so.2.1
3121400000-312140b000 r-xp 00000000 fd:00 1180006 /lib64/libpam.so.0.81.12
312140b000-312160b000 ---p 0000b000 fd:00 1180006 /lib64/libpam.so.0.81.12
312160b000-312160c000 rw-p 0000b000 fd:00 1180006 /lib64/libpam.so.0.81.12
3122400000-3122409000 r-xp 00000000 fd:00 1179971 /lib64/libcrypt-2.8.so
3122409000-3122608000 ---p 00009000 fd:00 1179971 /lib64/libcrypt-2.8.so
3122608000-3122609000 r--p 00008000 fd:00 1179971 /lib64/libcrypt-2.8.so
3122609000-312260a000 rw-p 00009000 fd:00 1179971 /lib64/libcrypt-2.8.so
312260a000-3122638000 rw-p 312260a000 00:00 0
3123800000-312382e000 r-xp 00000000 fd:00 5316643 /usr/lib64/libgssapi_krb5.so.2.2
312382e000-3123a2d000 ---p 0002e000 fd:00 5316643 /usr/lib64/libgssapi_krb5.so.2.2
3123a2d000-3123a2f000 rw-p 0002d000 fd:00 5316643 /usr/lib64/libgssapi_krb5.so.2.2
3123c00000-3123c02000 r-xp 00000000 fd:00 1179984 /lib64/libkeyutils-1.2.so
3123c02000-3123e01000 ---p 00002000 fd:00 1179984 /lib64/libkeyutils-1.2.so
3123e01000-3123e02000 rw-p 00001000 fd:00 1179984 /lib64/libkeyutils-1.2.so
3124000000-3124008000 r-xp 00000000 fd:00 5316640 /usr/lib64/libkrb5support.so.0.1
3124008000-3124207000 ---p 00008000 fd:00 5316640 /usr/lib64/libkrb5support.so.0.1
3124207000-3124208000 rw-p 00007000 fd:00 5316640 /usr/lib64/libkrb5support.so.0.1
3124400000-3124424000 r-xp 00000000 fd:00 5316641 /usr/lib64/libk5crypto.so.3.1
3124424000-3124623000 ---p 00024000 fd:00 5316641 /usr/lib64/libk5crypto.so.3.1
3124623000-3124625000 rw-p 00023000 fd:00 5316641 /usr/lib64/libk5crypto.so.3.1
3124800000-312489f000 r-xp 00000000 fd:00 5316642 /usr/lib64/libkrb5.so.3.3
312489f000-3124a9e000 ---p 0009f000 fd:00 5316642 /usr/lib64/libkrb5.so.3.3
3124a9e000-3124aa2000 rw-p 0009e000 fd:00 5316642 /usr/lib64/libkrb5.so.3.3
3498200000-349824e000 r-xp 00000000 fd:00 3311334 /opt/PostgreSQL/9.0/lib/libncurses.so.5.5
349824e000-349844e000 ---p 0004e000 fd:00 3311334 /opt/PostgreSQL/9.0/lib/libncurses.so.5.5
349844e000-349845c000 rw-p 0004e000 fd:00 3311334 /opt/PostgreSQL/9.0/lib/libncurses.so.5.5
349845c000-349845d000 rw-p 349845c000 00:00 0
3f74800000-3f7492d000 r-xp 00000000 fd:00 3311323 /opt/PostgreSQL/9.0/lib/libcrypto.so.6
3f7492d000-3f74b2c000 ---p 0012d000 fd:00 3311323 /opt/PostgreSQL/9.0/lib/libcrypto.so.6
3f74b2c000-3f74b4d000 rw-p 0012c000 fd:00 3311323 /opt/PostgreSQL/9.0/lib/libcrypto.so.6
3f74b4d000-3f74b51000 rw-p 3f74b4d000 00:00 0
3f74c00000-3f74c46000 r-xp /opt/PostgreSQL/9.0/bin/psql: line 21: 19271 Aborted "$PG_BIN_PATH/psql.bin" "$@"
[postgres@localhost ~]$ exit
logout
[root@localhost Download]# which psql
/usr/bin/which: no psql in (/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)
[root@localhost Download]# /opt/PostgreSQL/9.0/bin/psql -U postgres -d postgres
Password for user postgres:
psql.bin (9.0.5)
Type "help" for help.
postgres=# \dt
No relations found.
postgres=# \q
[root@localhost Download]# yum install libedit*
Loaded plugins: refresh-packagekit
fedora | 2.4 kB 00:00
updates | 2.6 kB 00:00
Setting up Install Process
Parsing package install arguments
Package libedit-2.10-4.20070831cvs.fc9.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package libedit-devel.x86_64 0:2.10-4.20070831cvs.fc9 set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================
Package Arch Version Repository Size
=============================================================================
Installing:
libedit-devel x86_64 2.10-4.20070831cvs.fc9 fedora 25 k
Transaction Summary
=============================================================================
Install 1 Package(s)
Update 0 Package(s)
Remove 0 Package(s)
Total download size: 25 k
Is this ok [y/N]: y
Downloading Packages:
(1/1): libedit-devel-2.10-4.20070831cvs.fc9.x86_64.rpm | 25 kB 00:00
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing: libedit-devel ######################### [1/1]
Installed: libedit-devel.x86_64 0:2.10-4.20070831cvs.fc9
Complete!
[root@localhost Download]# yum install libreadline*
Loaded plugins: refresh-packagekit
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package libreadline-java.x86_64 0:0.8.0-20.fc9 set to be updated
---> Package libreadline-java-javadoc.x86_64 0:0.8.0-20.fc9 set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================
Package Arch Version Repository Size
=============================================================================
Installing:
libreadline-java x86_64 0.8.0-20.fc9 fedora 50 k
libreadline-java-javadoc x86_64 0.8.0-20.fc9 fedora 20 k
Transaction Summary
=============================================================================
Install 2 Package(s)
Update 0 Package(s)
Remove 0 Package(s)
Total download size: 70 k
Is this ok [y/N]: y
Downloading Packages:
(1/2): libreadline-java-javadoc-0.8.0-20.fc9.x86_64.rpm | 20 kB 00:00
(2/2): libreadline-java-0.8.0-20.fc9.x86_64.rpm | 50 kB 00:00
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing: libreadline-java ######################### [1/2]
Installing: libreadline-java-javadoc ######################### [2/2]
Installed: libreadline-java.x86_64 0:0.8.0-20.fc9 libreadline-java-javadoc.x86_64 0:0.8.0-20.fc9
Complete!
[root@localhost Download]# clear
[root@localhost Download]# cd /opt/PostgreSQL/9.0/lib/
[root@localhost lib]# ls -lrth
total 9.0M
-rw-r--r-- 1 postgres postgres 50K 2011-09-23 11:15 libpgport.a
-rw-r--r-- 1 postgres postgres 255K 2011-09-23 11:15 libpq.a
-rw-r--r-- 1 postgres postgres 99K 2011-09-23 11:15 libpgtypes.a
-rw-r--r-- 1 postgres postgres 19K 2011-09-23 11:15 libecpg_compat.a
-rw-r--r-- 1 postgres postgres 147K 2011-09-23 11:15 libecpg.a
-rwxr-xr-- 1 postgres postgres 372K 2011-09-23 11:17 libncurses.so.5.5
-rw-r--r-- 1 postgres postgres 51K 2011-09-23 11:17 libuuid.so.16.0.22
-rwxr-xr-- 1 postgres postgres 18K 2011-09-23 11:17 libuuid.so.1.2
-rwxr-xr-- 1 postgres postgres 147K 2011-09-23 11:17 libpng12.so.0.10.0
-rwxr-xr-- 1 postgres postgres 136K 2011-09-23 11:17 libjpeg.so.62.0.0
-rwxr-xr-- 1 postgres postgres 308K 2011-09-23 11:17 libssl.so.6
-rwxr-xr-- 1 postgres postgres 1.4M 2011-09-23 11:17 libcrypto.so.6
-rwxr-xr-- 1 postgres postgres 189K 2011-09-23 11:17 libedit.so
-rwxr-xr-- 1 postgres postgres 4.0M 2011-09-23 11:17 libxml2.so.2
-rwxr-xr-- 1 postgres postgres 804K 2011-09-23 11:38 libxslt.so.1
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so.5.3
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so.5
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so.3.1
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so.3
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so.6.2
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so.6
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so.3.2
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so.3
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so
drwxr-xr-x 4 postgres postgres 4.0K 2011-10-13 08:21 postgresql
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libuuid.so.16 -> libuuid.so.16.0.22
lrwxrwxrwx 1 postgres postgres 14 2011-10-13 08:21 libuuid.so.1 -> libuuid.so.1.2
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libuuid.so -> libuuid.so.16.0.22
lrwxrwxrwx 1 postgres postgres 13 2011-10-13 08:21 libtermcap.so.2 -> libncurses.so
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libpng12.so.0 -> libpng12.so.0.10.0
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libpng12.so -> libpng12.so.0.10.0
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libncurses.so.5 -> libncurses.so.5.5
lrwxrwxrwx 1 postgres postgres 15 2011-10-13 08:21 libncurses.so -> libncurses.so.5
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libjpeg.so.62 -> libjpeg.so.62.0.0
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libjpeg.so -> libjpeg.so.62.0.0
[root@localhost lib]# ls libedit.so
libedit.so
[root@localhost lib]# find / -name libedit* 2>/dev/null
/opt/PostgreSQL/9.0/lib/libedit.so
/usr/lib64/libedit.so
[root@localhost lib]# ls -lrth /usr/lib64/libedit.so
lrwxrwxrwx 1 root root 17 2011-10-13 09:00 /usr/lib64/libedit.so -> libedit.so.0.0.26
[root@localhost lib]# mv libedit.so libedit.so.bak
[root@localhost lib]# ln -s /usr/lib64/libedit.so libedit.so
[root@localhost lib]# ls -lrth
total 9.0M
-rw-r--r-- 1 postgres postgres 50K 2011-09-23 11:15 libpgport.a
-rw-r--r-- 1 postgres postgres 255K 2011-09-23 11:15 libpq.a
-rw-r--r-- 1 postgres postgres 99K 2011-09-23 11:15 libpgtypes.a
-rw-r--r-- 1 postgres postgres 19K 2011-09-23 11:15 libecpg_compat.a
-rw-r--r-- 1 postgres postgres 147K 2011-09-23 11:15 libecpg.a
-rwxr-xr-- 1 postgres postgres 372K 2011-09-23 11:17 libncurses.so.5.5
-rw-r--r-- 1 postgres postgres 51K 2011-09-23 11:17 libuuid.so.16.0.22
-rwxr-xr-- 1 postgres postgres 18K 2011-09-23 11:17 libuuid.so.1.2
-rwxr-xr-- 1 postgres postgres 147K 2011-09-23 11:17 libpng12.so.0.10.0
-rwxr-xr-- 1 postgres postgres 136K 2011-09-23 11:17 libjpeg.so.62.0.0
-rwxr-xr-- 1 postgres postgres 308K 2011-09-23 11:17 libssl.so.6
-rwxr-xr-- 1 postgres postgres 1.4M 2011-09-23 11:17 libcrypto.so.6
-rwxr-xr-- 1 postgres postgres 189K 2011-09-23 11:17 libedit.so.bak
-rwxr-xr-- 1 postgres postgres 4.0M 2011-09-23 11:17 libxml2.so.2
-rwxr-xr-- 1 postgres postgres 804K 2011-09-23 11:38 libxslt.so.1
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so.5.3
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so.5
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so.3.1
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so.3
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so.6.2
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so.6
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so.3.2
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so.3
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so
drwxr-xr-x 4 postgres postgres 4.0K 2011-10-13 08:21 postgresql
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libuuid.so.16 -> libuuid.so.16.0.22
lrwxrwxrwx 1 postgres postgres 14 2011-10-13 08:21 libuuid.so.1 -> libuuid.so.1.2
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libuuid.so -> libuuid.so.16.0.22
lrwxrwxrwx 1 postgres postgres 13 2011-10-13 08:21 libtermcap.so.2 -> libncurses.so
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libpng12.so.0 -> libpng12.so.0.10.0
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libpng12.so -> libpng12.so.0.10.0
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libncurses.so.5 -> libncurses.so.5.5
lrwxrwxrwx 1 postgres postgres 15 2011-10-13 08:21 libncurses.so -> libncurses.so.5
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libjpeg.so.62 -> libjpeg.so.62.0.0
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libjpeg.so -> libjpeg.so.62.0.0
lrwxrwxrwx 1 root root 21 2011-10-13 09:02 libedit.so -> /usr/lib64/libedit.so
[root@localhost lib]# chown -R postgres:postgres libedit.so
[root@localhost lib]# ls -lrth
total 9.0M
-rw-r--r-- 1 postgres postgres 50K 2011-09-23 11:15 libpgport.a
-rw-r--r-- 1 postgres postgres 255K 2011-09-23 11:15 libpq.a
-rw-r--r-- 1 postgres postgres 99K 2011-09-23 11:15 libpgtypes.a
-rw-r--r-- 1 postgres postgres 19K 2011-09-23 11:15 libecpg_compat.a
-rw-r--r-- 1 postgres postgres 147K 2011-09-23 11:15 libecpg.a
-rwxr-xr-- 1 postgres postgres 372K 2011-09-23 11:17 libncurses.so.5.5
-rw-r--r-- 1 postgres postgres 51K 2011-09-23 11:17 libuuid.so.16.0.22
-rwxr-xr-- 1 postgres postgres 18K 2011-09-23 11:17 libuuid.so.1.2
-rwxr-xr-- 1 postgres postgres 147K 2011-09-23 11:17 libpng12.so.0.10.0
-rwxr-xr-- 1 postgres postgres 136K 2011-09-23 11:17 libjpeg.so.62.0.0
-rwxr-xr-- 1 postgres postgres 308K 2011-09-23 11:17 libssl.so.6
-rwxr-xr-- 1 postgres postgres 1.4M 2011-09-23 11:17 libcrypto.so.6
-rwxr-xr-- 1 postgres postgres 189K 2011-09-23 11:17 libedit.so.bak
-rwxr-xr-- 1 postgres postgres 4.0M 2011-09-23 11:17 libxml2.so.2
-rwxr-xr-- 1 postgres postgres 804K 2011-09-23 11:38 libxslt.so.1
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so.5.3
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so.5
-rwxr-xr-x 1 postgres postgres 171K 2011-09-23 11:38 libpq.so
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so.3.1
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so.3
-rwxr-xr-x 1 postgres postgres 68K 2011-09-23 11:38 libpgtypes.so
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so.6.2
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so.6
-rwxr-xr-x 1 postgres postgres 85K 2011-09-23 11:38 libecpg.so
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so.3.2
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so.3
-rwxr-xr-x 1 postgres postgres 23K 2011-09-23 11:38 libecpg_compat.so
drwxr-xr-x 4 postgres postgres 4.0K 2011-10-13 08:21 postgresql
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libuuid.so.16 -> libuuid.so.16.0.22
lrwxrwxrwx 1 postgres postgres 14 2011-10-13 08:21 libuuid.so.1 -> libuuid.so.1.2
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libuuid.so -> libuuid.so.16.0.22
lrwxrwxrwx 1 postgres postgres 13 2011-10-13 08:21 libtermcap.so.2 -> libncurses.so
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libpng12.so.0 -> libpng12.so.0.10.0
lrwxrwxrwx 1 postgres postgres 18 2011-10-13 08:21 libpng12.so -> libpng12.so.0.10.0
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libncurses.so.5 -> libncurses.so.5.5
lrwxrwxrwx 1 postgres postgres 15 2011-10-13 08:21 libncurses.so -> libncurses.so.5
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libjpeg.so.62 -> libjpeg.so.62.0.0
lrwxrwxrwx 1 postgres postgres 17 2011-10-13 08:21 libjpeg.so -> libjpeg.so.62.0.0
lrwxrwxrwx 1 postgres postgres 21 2011-10-13 09:02 libedit.so -> /usr/lib64/libedit.so
[root@localhost lib]# clear
[root@localhost lib]# sudo su - postgres
[postgres@localhost ~]$ psql
-bash: psql: command not found
[postgres@localhost ~]$ pwd
/home/postgres
[postgres@localhost ~]$ cd /opt/PostgreSQL/9.0/bin/
[postgres@localhost bin]$ ./psql
psql.bin (9.0.5)
Type "help" for help.
postgres=# \dt
No relations found.
postgres=# \dt
No relations found.
postgres=# \q
[postgres@localhost bin]$
No comments:
Post a Comment