PostgreSql: 'utf8' codec can't decode byte 0xe9 in position 42: invalid continuation byte

postgresql pgadmin-4
narcisse picture narcisse · Aug 26, 2017 · Viewed 14.4k times · Source

I recently installed PostgreSql and I am trying to create a new database. Unfortunetly I got and error while creating the database:

"'utf8' codec can't decode byte 0xe9 in position 42: invalid continuation byte" enter image description here

What is the problem exactly thank you

Answer

zesage picture zesage · Nov 1, 2017

Try to add the following line at the end of the pg_hba.conf file and then restart the PostgreSQL service:

host    all             all             all                 md5

Related questions

pgadmin4 : postgresql application server could not be contacted.

I have installed PostgreSQL 9.6.2 on my Windows 8.1. But the pgadmin4 is not able to contact the local server. I have tried several solutions suggested here in stackoverflow, tried to uninstall and reinstall PostgreSQL 9.6.2 , tried to modify the config.py, config_…

Read More
FATAL: password authentication failed for user "postgres" (postgresql 11 with pgAdmin 4)

I recently installed Postgresql 11, during the installation, there's no step to put password and username for Postgres. Now in pgAdmin 4, I wanted to connect the database to server and it's asking me to input password, and I haven't put any …

Read More
pgAdmin won't start (eternal loading)

Once upon a time I had a Postgres database that worked with pgAdmin. I have a webservice running on a WildFly server that made connections to the DB and everything worked fine. After a while(a few months) I have …

Read More