DBeaver PostgreSQL Connection

Easily connect your PostgreSQL hosting deployments at ScaleGrid to your DBeaver database administrator tool to optimize your PostgreSQL management in the cloud.

How to Connect PostgreSQL to DBeaver

1. Open up your DBeaver program.
2. Create a New connection by clicking the New Connection Wizard button in the application toolbar or in the Database Navigator view toolbar:

3. Select PostgreSQL for the type of your database and click Next.

4. Under User and Password, enter the Username and Password provided on the cluster details page of your PostgreSQL Deployment on ScaleGrid console.
5. In the Connection Settings window that opens up, enter the hostname of the deployment found in your ScaleGrid PostgreSQL Connection String under the Host field.
6. Enter port number (default is 5432) and the name of the database you’re trying to connect under Port and Database.

🚧

Note - your user should have appropriate permissions to access the database chosen

🚧

Non SSL Enabled Deployments

If the deployment is not SSL enabled, skip to step 10 below.

7. Download SSL certificate from the Get SSL CA Cert in the cluster details page.
8. Go to the SSL tab in the DBeaver Connection Settings, and select the Use SSL checkbox.
9. Enter the path to your SSL certificate under Root certificate, and select verify-ca under SSL mode.

10. Review your entered information, and select Test Connection. If it shows Connected, select Finish.

👍

Your PostgreSQL deployment is now connected to your DBeaver database administrator tool!

If you have any questions, please reach out to us at [email protected].