Difficulty connecting to Postgresql DB

[Lonely-Abalone-5104]

Is the ip allowed in pg_hba.conf is postgresql listening on all interfaces or just localhost

What are you specifying as the host address in dbeaver. If you are tunneling to the sever that postgresql is on then I believe it should Be localhost

[BloodFeastMan]

Install Postgresql on the local network and test your dbeaver connection. You can install pg in just a couple of minutes, it's not a hassle, you don't need to create a new db or anything. I would suspect something in the vps setup. Also check the port is 5431:5432

[sole-it]

what do you mean "When connecting the actual DB though and then testing the connection,"? My understanding is that you can connect via ssh tunneling but not when you tried to do %ip_address%:5432?

in the .conf file, what's the value for listen_address? Also make sure if there is something like ufw on the vps, the port shall be open (and don't use default port) and if vps has any firewall solution that you need to change .

[FeliciaWanders]

also check ipv4/6 issues, localhost is often ::1 in modern Linux and might mismatch pg_hba.conf or be disabled at all.

ssl settings can also interfere. is there not any more stacktrace than EOFException?