Re: Could you please help to advise this if you can? Thanks. - Mailing list pgadmin-support

On Thu, Apr 11, 2019 at 9:42 AM vanbell <vanbell@126.com> wrote:

Hi Team,

I know this would out of your scope.

May I ask your help if you know any thing of this?

Could you please help to advise for below error if you can?

(I tried to install one pgadmin4 in one virtual env)

Thanks so much.

Yes, it's a change in psycopg2 that's been annoying me for a little while. I'm trying to come up with a good workaround for pgAdmin.

In the meantime, either:

- Run 'pip install psycopg2-binary' in your virtualenv before trying to install pgAdmin, or;

- Install PostgreSQL on the machine, and ensure the pg_config binary is in your path before installing pgAdmin.

The former is likely a lot easier.

 

(Pgadmin4-4.5) [root@oc0274005686 Pgadmin4-4.5]# pip install pgadmin4-4.5-py2.py3-none-any.whl
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Processing ./pgadmin4-4.5-py2.py3-none-any.whl
Collecting python-dateutil>=2.8.0 (from pgadmin4==4.5)
  Using cached https://files.pythonhosted.org/packages/41/17/c62faccbfbd163c7f57f3844689e3a78bae1f403648a6afb1d0866d87fbb/python_dateutil-2.8.0-py2.py3-none-any.whl
Collecting Flask-Paranoid==0.2.0 (from pgadmin4==4.5)
  Using cached https://files.pythonhosted.org/packages/0e/14/359033a218c5403872e11ff7267e6c638c0279067fa932d93653188f4052/Flask_Paranoid-0.2.0-py2.py3-none-any.whl
Collecting blinker==1.4 (from pgadmin4==4.5)
  Using cached https://files.pythonhosted.org/packages/1b/51/e2a9f3b757eb802f61dc1f2b09c8c99f6eb01cf06416c0671253536517b6/blinker-1.4.tar.gz
Collecting pytz==2018.9 (from pgadmin4==4.5)
  Using cached https://files.pythonhosted.org/packages/61/28/1d3920e4d1d50b19bc5d24398a7cd85cc7b9a75a490570d5a30c57622d34/pytz-2018.9-py2.py3-none-any.whl
Collecting Flask-WTF==0.14.2 (from pgadmin4==4.5)
  Using cached https://files.pythonhosted.org/packages/60/3a/58c629472d10539ae5167dc7c1fecfa95dd7d0b7864623931e3776438a24/Flask_WTF-0.14.2-py2.py3-none-any.whl
Collecting Flask-HTMLmin==1.5.0 (from pgadmin4==4.5)
  Using cached https://files.pythonhosted.org/packages/c2/1e/b649bc15774cedd07509e5fd830fbfd7470adc93dffda607dd02262deb29/Flask-HTMLmin-1.5.0.tar.gz
Collecting psycopg2>=2.8 (from pgadmin4==4.5)
  Using cached https://files.pythonhosted.org/packages/52/be/f898e712f5f08131d651a62754fca82a1deb42e4e9889ad01932f770a2be/psycopg2-2.8.1.tar.gz
    Complete output from command python setup.py egg_info:
    running egg_info
    creating pip-egg-info/psycopg2.egg-info
    writing pip-egg-info/psycopg2.egg-info/PKG-INFO
    writing top-level names to pip-egg-info/psycopg2.egg-info/top_level.txt
    writing dependency_links to pip-egg-info/psycopg2.egg-info/dependency_links.txt
    writing manifest file 'pip-egg-info/psycopg2.egg-info/SOURCES.txt'
   
    Error: pg_config executable not found.
   
    pg_config is required to build psycopg2 from source.  Please add the directory
    containing pg_config to the $PATH or specify the full executable path with the
    option:
   
        python setup.py build_ext --pg-config /path/to/pg_config build ...
   
    or with the pg_config option in 'setup.cfg'.
   
    If you prefer to avoid building psycopg2 from source, please install the PyPI
    'psycopg2-binary' package instead.
   
    For further information please check the 'doc/src/install.rst' file (also at
    <http://initd.org/psycopg/docs/install.html>).
   
   
    ----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-install-KTnqtM/psycopg2/

(Pgadmin4-4.5) [root@oc0274005686 Pgadmin4-4.5]# pip install psycopg2-binary
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Requirement already satisfied: psycopg2-binary in /root/.local/share/virtualenvs/Pgadmin4-4.5-uPL5RCS3/lib/python2.7/site-packages (2.8.1)
(Pgadmin4-4.5) [root@oc0274005686 Pgadmin4-4.5]# yum install postgresql-devel*


Package postgresql10-devel-10.7-2PGDG.rhel7.x86_64 already installed and latest version
Package postgresql11-devel-11.2-2PGDG.rhel7.x86_64 already installed and latest version
Nothing to do
(Pgadmin4-4.5) [root@oc0274005686 Pgadmin4-4.5]# yum install postgresql postgresql-devel python-devel
Loaded plugins: downloadkvmonly-background, ibm-check-lotus-updates, ibm-check-upgrade, ibm-check-xorg-updates, ibm-
              : repository, langpacks, post-transaction-actions, refresh-packagekit, versionlock
Package postgresql11-11.2-2PGDG.rhel7.x86_64 already installed and latest version
Package postgresql11-devel-11.2-2PGDG.rhel7.x86_64 already installed and latest version
Nothing to do
(Pgadmin4-4.5) [root@oc0274005686 Pgadmin4-4.5]# pip install psycopg2
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Collecting psycopg2
  Using cached https://files.pythonhosted.org/packages/52/be/f898e712f5f08131d651a62754fca82a1deb42e4e9889ad01932f770a2be/psycopg2-2.8.1.tar.gz
    Complete output from command python setup.py egg_info:
    running egg_info
    creating pip-egg-info/psycopg2.egg-info
    writing pip-egg-info/psycopg2.egg-info/PKG-INFO
    writing top-level names to pip-egg-info/psycopg2.egg-info/top_level.txt
    writing dependency_links to pip-egg-info/psycopg2.egg-info/dependency_links.txt
    writing manifest file 'pip-egg-info/psycopg2.egg-info/SOURCES.txt'
   
    Error: pg_config executable not found.
   
    pg_config is required to build psycopg2 from source.  Please add the directory
    containing pg_config to the $PATH or specify the full executable path with the
    option:
   
        python setup.py build_ext --pg-config /path/to/pg_config build ...
   
    or with the pg_config option in 'setup.cfg'.
   
    If you prefer to avoid building psycopg2 from source, please install the PyPI
    'psycopg2-binary' package instead.
   
    For further information please check the 'doc/src/install.rst' file (also at
    <http://initd.org/psycopg/docs/install.html>).
   
   
    ----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-install-vh_Uxr/psycopg2/
(Pgadmin4-4.5) [root@oc0274005686 Pgadmin4-4.5]#

 

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company