Can't connect to a PostgreSQL 15.4 DB using HeidiSQL 12.9.0.6999

bgaydos's profile image bgaydos posted 3 weeks ago in Creating a connection Permalink

I can connect to a PostgreSQL 15.4 database using pgAdmin, but a fresh download and install of HeidiSQL will not connect using the same parameters. Does anybody know if an older release of HeidiSQL will likely be more compatible? I do not have access to any of the server-side logs. TIA.

ansgar's profile image ansgar posted 3 weeks ago Permalink

Last release v12.9 had the wrong SSL libraries used by libpq-15 and libpq-17. Please update to the just released v12.10.

bgaydos's profile image bgaydos posted 3 weeks ago Permalink

I upgraded to v12.10 but that didn't help. I'd like to share the explicit details of the error dialog but the attached redacted version will have to do. Again, I have long been connecting to this same database using pgAdmin.

1 attachment(s):
  • pp20250122_110234
ansgar's profile image ansgar posted 3 weeks ago Permalink

That's an SSL related error. See issue #2067

I think you need to set up SSL correctly in the server, but I'm not sure.

Perhaps you can leave some deeper info there, as I don't know much about PostgreSQL's SSL configuration.

bgaydos's profile image bgaydos posted 3 weeks ago Permalink

@ansgar, please see the redacted attached screenshot for the two settings on the SSL tab which made the difference for me; I am now connected! Thanks for the help and clues.

Bob

1 attachment(s):
  • HeidiSQL_solution_redacted

Please login to leave a reply, or register at first.