Can not create a new database by using pgadmin4

2019-07-27 12:58发布

问题:

I was trying to create a new database on pgadmin4 on my Ubuntu computer, but I got two errors.

The first one: "Error saving properties";

The second one: "Error retrieving the information - INTERNAL SERVER ERROR".

I have been looking for an answer and I found nothing but tutorials to create without error. I am starting to learn SQL and need to get it working as soon as possible to carry on my course.

------------OS------------

PostgreSQL 10

pgAdmin 4

Ubuntu 16.04 LTS 64-bit

回答1:

You should clear Encoding field in Definitions tab, when you click save button it still show error popup but the database will be created.
It seem pgAdmin 4 have a bug in its psycopg2 lib. I just wrote a question for that:
Error when create database from pgadmin4