PostgreSql: codec "utf8" cannot decode byte 0xe9 at position 42: invalid continuation byte

Question

I recently installed PostgreSql and I am trying to create a new database. Unfortunately, I had an error creating the database:

"'utf8' codec cannot decode byte 0xe9 at position 42: invalid continuation byte"

What is the problem? thanks

Answer 1

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

host all all all md5 

Answer 2

I had a similar error when upgrading from 4.5 to 4.7, the solution was to restart the pgAdmin server.

My mistake: Error: utf-8 codec cannot decode byte 0xe9 at position 0: invalid continue byte

Answer 3

This is a conflict between local languages. PgAdmin is in English, but perhaps in the conf file the lc_messages variable is French, Spanish or something else. Try this

 lc_messages = 'en_US' 

Answer 4

I tried all the solutions above. No one worked.

The solution for me was to install American ENGLISH as my language on my windows 10. Then I repeated the installation in that language.

It works now and I do not use American English as my Windows xD language