POSTGRESQL: 'utf8' codec can't decode byte 0xfc in position 36: invalid start byte

pgadmin-4
Question3r picture Question3r · Apr 19, 2018 · Viewed 7.2k times · Source

I just downloaded and installed PostgreSQL from here

https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

I wanted to create my first server but I get this error

'utf8' codec can't decode byte 0xfc in position 36: invalid start byte

error

My pg service is running automatically

service

What am I missing?

Answer

C.Serge picture C.Serge · Jun 5, 2018

Same thing here (postgresql 9.6 on windows) when I tried to using query tool. It's happend after I changed postgres user password using pgadmin 4. I simply restarted the postgresql service, started pgadmin 4 and then it asked for the new password. After typed it, no more error message.

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
PgAdmin4 unable to query or view data

I have a very basic PostgreSql table. Despite the simple table schema, I cannot query it via PgAdmin4. The View Data option is unresponsive; Query Tool option becomes unresponsive after a few attempts in opening and closing the panel. When …

Read More