Pgcli is a command line interface for Postgres with auto-completion and syntax highlighting. Recently it gave a problem under fedora.
$ pgcli --host pg.example.com --port 1234 --username username --password --dbname pgdb
Traceback (most recent call last):
File "/usr/bin/pgcli", line 11, in <module>
load_entry_point('pgcli==1.7.0', 'console_scripts', 'pgcli')()
File "/usr/lib/python2.7/site-packages/pkg_resources/__init__.py", line 572, in load_entry_point
return get_distribution(dist).load_entry_point(group, name)
File "/usr/lib/python2.7/site-packages/pkg_resources/__init__.py", line 2749, in load_entry_point
return ep.load()
File "/usr/lib/python2.7/site-packages/pkg_resources/__init__.py", line 2402, in load
return self.resolve()
File "/usr/lib/python2.7/site-packages/pkg_resources/__init__.py", line 2408, in resolve
module = __import__(self.module_name, fromlist=['__name__'], level=0)
File "/usr/lib/python2.7/site-packages/pgcli/main.py", line 40, in <module>
from pgspecial.main import (PGSpecial, NO_QUERY)
File "/usr/lib/python2.7/site-packages/pgspecial/__init__.py", line 12, in <module>
from . import iocommands
File "/usr/lib/python2.7/site-packages/pgspecial/iocommands.py", line 9, in <module>
import psycopg2
File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 50, in <module>
from psycopg2._psycopg import ( # noqa
ImportError: /usr/lib64/python2.7/site-packages/psycopg2/.libs/libresolv-2-c4c53def.5.so: symbol __res_maybe_init, version GLIBC_PRIVATE not defined in file libc.so.6 with link time reference
The resolution was to install the latest version directly from git using the pip3 command:
pip3 install git+https://github.com/dbcli/pgcli.git