TablePlus PostgreSQL Connection

Easily connect your PostgreSQL hosting deployments at ScaleGrid to your TablePlus GUI tool to optimize your database management.

How to Connect PostgreSQL to TablePlus

1. Open up your TablePlus tool.
2. Click the Create New Connection dropdown menu, and select PostgreSQL:

3. Enter a Name for your new PostgreSQL connection.
4. Under Host, enter the hostname of the deployment provided on your ScaleGrid PostgreSQL connection string.
5. Under User and Password, enter the Username and Password provided on the ScaleGrid console under the Credentials section of your PostgreSQL cluster details page.
6. Enter port number (default is 5432) and the name of the database you’re trying to connect under Port and Database.

🚧

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 on your ScaleGrid PostgreSQL cluster details page.
8. Under SSL mode, select VERIFY-CA.
9. Click the SSL CA... button, and select your downloaded certificate file.

10. When you’re done, click the Test button at the bottom, and if it shows “connection is ok”, select Connect.

👍

Your PostgreSQL deployment is now connected to your TablePlus GUI!

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