pgadmin can't log in after update

Question

Just updated pgadmin4 to version 4.8 and now it won't accept ssh tunnel password into server, I get the following error message:

Failed to decrypt the SSH tunnel password. Error: 'utf-8' codec can't decode byte 0x8c in position 0: invalid start byte

Is there a way around this, I can't restart the database server at this time.

Answer 1

In latest pgAdmin4 version they have increased the security of saved password by implementing master password feature, I think that is causing this issue, meantime you can rename pgadmin4.db to pgadmin4.db_OLD and restart pgAdmin4.

Note: You have to add the all the servers again.

---------- UPDATE ----------

It has been fixed now https://redmine.postgresql.org/issues/4320 and will be in 4.9.

You can try nightly builds though https://postgresql.org/ftp/pgadmin/pgadmin4/snapshots

Answer 2

This also happened for me moving from 4.8.2 for Ubuntu 18.10 to 4.8.2 for Ubuntu 19.04 (different installs). I was able to resolve this by restarting the postgres server with sudo systemctl restart postgresql