I am working on a project where I have a server running Debian 12 in which is installed Postgresql 16 and another one that runs Windows server 2019. I am trying to access the db installed on linux via dbeaver on the windows machine but I get the following error:

Postgresql : Connection refused. Check that the hostname 
and port are correct and that the postmaster is accepting
TCP/IP connections

Following solutions from other posts I’ve already tried:

• Editing the postgresql.conf file to set listen_addresses = '*'
• Editing the pg_hba.conf file to set host all all all md5
• Checked if the two servers can “see” each other by pinging. And it works. I get response when pinging the windows server from linux and viceversa.

I am a jr data engineer and usually work with the environment ready, it is my first time trying to perform this kind of configuration, so any kind of solution or guidance will be appreciated.

Thanks.