I've been using PostgreSQL 10 and 12 on Windows successfully with DBeaver in the past. Now I've set up a new development machine and installed the current PostgreSQL 13.0.1 and the current DBeaver 7.2.4 on Windows 10.2004. When connecting to the local Postgres server, I got the message that a connection wasn't possible in the Postgres 10 style and I should check the hb_pga.conf entries.
I went to my hb_pga.conf file and changed all of the shiny new
scram-sha-256 entries back to the old
md5 and restarted the database server.
But DBeaver won't connect. Is this a problem with the latest DBeaver or Postgres or what? Has anybody managed to get these two to talk to each other with the latest versions?
Unfortunately DBeaver seems to be based on Java and is limited to JDBC which doesn't seem to be maintained anymore so it can't use the current Postgres authentication scheme. I've looked for multi-DBMS alternatives to DBeaver but couldn't find any that looks convincing. Same old problem, good GUI database clients are very expensive, the free ones are often of poor quality. I hoped DBeaver was a good solution.