RazorSQL PostgreSQL Connection

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

How to Connect PostgreSQL to RazorSQL

1. Open up your RazorSQL program.
2. Go to File → New Tab (No Connection).
3. Select Click to Connect to Database.
4. Under Database Type, select PostgreSQL and click Continue.

5. Enter a Profile Name for your PostgreSQL connection.
6. Under Connection Type in the RazorSQL Connection Window, select JDBC (PostgreSQL Native Driver).
7. Under Login and Password, enter the Username and Password provided on the cluster details page of your PostgreSQL Deployment on ScaleGrid console.
8. Under Host or IP Address you can enter the hostname of the deployment provided on your ScaleGrid PostgreSQL connection string.
9. Enter port number (default is 5432) and the name of the database you’re trying to connect under Port and Database Name.

🚧

Non SSL-Enabled Deployments

If your PostgreSQL deployment is not SSL enabled, skip to step 14.

10. Download your SSL certificate from the Get SSL CA Cert on your PostgreSQL cluster details page.
11. Select Configure under Conn. Properties.
12. Enter the path of the SSL cert in sslrootcert and select true for ssl.
13. Click Save to finalize your SSL configurations.

14. Review your information, and Connect.

👍

Your PostgreSQL deployment is now connected to your RazorSQL GUI!

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