ERROR: column "backend_type" does not exist LINE 16: backend_type, ^

 Error:

I am running PgAdmin4 on macOS and I am trying to connect to a Postgres database (v9.6). When attempting connection, this message is displayed :

ERROR: column "backend_type" does not exist LINE 16: backend_type, ^

Solution:

pgAdmin do not support PostgreSQL 9.6. From here Version history Postgres 9.6 is almost 2 years past EOL. From here pgAdmin 8.3 Release notes Supported Database Servers PostgreSQL: 12, 13, 14, 15, and 16. backend_type is a column in the system view pg_stat_activity and does not show until Postgres 10. Use the psql client shipped with Postgres.

Postgres Version details