Failed to Establish a Connection between DBeaver and PostgreSQL Databases

Symptoms

When a user tried to use host operation in the bastion host to manage PostgreSQL databases, the connection between DBeaver and PostgreSQL databases was not established.

Possible Causes

The network is inaccessible.

Solution

1. Check whether the network communication is normal.
   • Port for connections between your PC and the bastion host: 15432
   • Port for connections between the bastion host and the managed database: PGSQL database port

2. If the communication is normal, ensure that SSL is enabled for PGSQL and disabled in DBeaver.

   Start the DBeaver client, choose Database > Driver Manager, click Edit, select Connection properties, and add the sslmode property. Set its value to disable.