SSL settings not respected after postgres update

[scottgigante]

I'm having issues with this extension after upgrading from postrges 14 to 15 (homebrew). I can connect to the host, but when attempting to run a query, I get

no pg_hba.conf entry for host "10.*.*.*", user "****", database "****", no encryption

despite the fact that connecting to the same db with psql or a different postgresql vscode extension works fine.

I have uninstalled, deleted the files for, and reinstalled the extension, but I notice my connections config persists -- is there a secret config file somewhere for this extension I can delete to see if that's causing the problem?

[mswehli]

Same happening to me with postgresql v14 hosted on Azure. The first connection to the server works, however additional connections don't. It appears to ignore the use SSL option on all but the first connection you open.

[desdae]

I ran into this issue too. I can get the database list, but nothing further works, just getting no encryption message.