PostgreSQL Driver: 42.5.0
PostgreSQL Server: Stackgres Operated Server (v14.1) in a k8s Cluster connected via wireguard VPN
Though we can connect to the Database(s) and the first `select` is working, every other fails with either "connection failed" or "connection was established but closed as invalid" (depending on the DataGrip Version).
No other client (pgadmin or any VSCode Plugin) faces this issue, neither our applications have problems. So I assume there's some misconfiguration on the DataGrip side.
With a little effort we at least managed to workaround this issue. When running a "Diagnostic Refresh" and set Trx to "Repeatable Read" it works reliably until the next restart of the DataGrip IDE.
We would very much appreciate if every query runs through out of the box without any clickwork when starting up the IDE. Maybe there's a setting we missed to configure.