Error When Create Database From Pgadmin4

When I create database from pgadmin 4, it always show error popup: Error saving properties. My computer info: Linux Mint 18.3 pgAdmin 4 2.1 from https://wiki.postgresql.org/wiki/

Solution 1:

Commenting out two lines in python code resolves the issue:

sudo sed -i '2078,2079 s/^[^#]/#/' 
/usr/share/pgadmin4/web/pgadmin/utils/driver/psycopg2/__init__.py

The lines are:

ifhasattr(adapted, 'encoding'):
       adapted.encoding = 'utf8'

Solution 2:

Probably you need psycopg > 2.6.2. See https://github.com/psycopg/psycopg2/issues/331

Solution 3:

Install the python-psycopg2 complement, in ubuntu:

sudo apt-get install python-psycopg2

That Works for me !

Regards !