NOTE: Certain information in this article may be missing or out of date. We are in the process of updating the content.
Overview
Manage and analyze all your data quickly and reliably with a connection to your PostgreSQL database.
How to Connect
Before you get started you will need to obtain your PostgreSQL host, port, database name and login information. Additionally, you will need to whitelist these IP addresses before connecting your account.
Here are the steps to connect your PostgreSQL database to Grow:
- Click on the Data tab at the top left of the global navigation. Then click on "Connections" in the Data Library section.
- Click on the blue "Connect" button and search for PostgreSQL.
- Click on the PostgreSQL logo.
- A pop up window will appear. If it doesn’t check your pop up blocker and allow pop ups from Grow. We promise to not abuse this privilege.
- Type in a Connection Nickname, this can be anything and will be what shows up in the auth menu when you build future metrics from this connection.
- Type in the Host, Port, Database Name, Username and Password.
- If you are wanting to connect via SSH please read the FAQ section for further instruction.
- Click Submit.
And that's it! You are good to go.
Endpoints
PostgreSQL doesn’t have set reports through which to pull data. The endpoints are the tables inside your database, to see a list of your tables you can select the blue View Table Structure button below the query box.
FAQs + Tips and Tricks
Why is my connection returning a ETIMEOUT error?
This usually means that the IP addresses are not yet whitelisted, or the host, port, database name, or login creds are incorrect. Double check and try again.
Why is my query taking a while to load?
If you know that your query is going to return a large amount of data we recommend trying to limit the time range and filter the data as much as possible by using a summary query.
How can I make sure my data is secure?
We have several items in place to keep your data safe. Check out our security article to see what steps you can take to keep control of your data.
How can I connect my database with an SSH Tunnel?
Once you have plugged in the connection information, before selecting Submit check the SSH Tunnel box. You will need to provide the SSH Host, SSH Port, SSH Username and Password. You can also use a keyfile instead of a password if you would like. Select Use SSH Key File and then upload your keyfile. If you are not able to or don't want to directly connect to your database directly, you can first connect to a server that has SSH access to your server, and Grow will then connect to your database through that server. If your database is on your SSH server, your database Host would be 'localhost', and your SSHHost would be the server hostname.