Problem running pgcli fixed by installing from git using pip

Pgcli is a command line interface for Postgres with auto-completion and syntax highlighting. Recently it gave a problem under fedora.

$ pgcli --host --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/", line 572, in load_entry_point
 return get_distribution(dist).load_entry_point(group, name)
 File "/usr/lib/python2.7/site-packages/pkg_resources/", line 2749, in load_entry_point
 return ep.load()
 File "/usr/lib/python2.7/site-packages/pkg_resources/", line 2402, in load
 return self.resolve()
 File "/usr/lib/python2.7/site-packages/pkg_resources/", line 2408, in resolve
 module = __import__(self.module_name, fromlist=['__name__'], level=0)
 File "/usr/lib/python2.7/site-packages/pgcli/", line 40, in <module>
 from pgspecial.main import (PGSpecial, NO_QUERY)
 File "/usr/lib/python2.7/site-packages/pgspecial/", line 12, in <module>
 from . import iocommands
 File "/usr/lib/python2.7/site-packages/pgspecial/", line 9, in <module>
 import psycopg2
 File "/usr/lib64/python2.7/site-packages/psycopg2/", line 50, in <module>
 from psycopg2._psycopg import ( # noqa
ImportError: /usr/lib64/python2.7/site-packages/psycopg2/.libs/ symbol __res_maybe_init, version GLIBC_PRIVATE not defined in file with link time reference

The resolution was to install the latest version directly from git using the pip3 command:

pip3 install git+



This entry was posted in General. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *