PostgreSQL database
Connect to PostgreSQL
Connecting SMAQ to a PostgreSQL server involves several steps, including configuring access permissions, setting up the host, port, username, and password, and constructing a connection string. Here's a brief tutorial on how to do this:
Step 1: Click `Add Source` on home page
Step 2: Select Database Type
Next, select your database type. In this case, we are using Postgres.
Step 3: Click on Continue
Click on the "Continue" button to proceed.
Step 4: Fill in Connection Details
Now, you need to enter your database information. Not sure how to get that? Follow one of our provider guides to walk you through it.
Google Cloud Platform
Amazon Web Services
Microsoft Azure
Step 5: Allow SMAQ to access your PostgreSQL server
Before you can connect to a PostgreSQL server, you need to ensure that SMAQ can access it. This typically involves configuring your server's firewall rules and PostgreSQL's authentication settings.
Firewall Rules: Open the port that PostgreSQL is running on (default is 5432) in your server's firewall to allow incoming connections.
Authentication: Configure PostgreSQL to allow connections from remote hosts if needed. Add the following IP address to the allowed host:
Step 6: Test Connection
Click on the "Test Connection" button. If you have entered all the information correctly, you will see a successful connection message.
Step 7: Complete and add the data source
Finally, click on the "Connect" button.
Congratulations! You have successfully connected to a Postgres database using SMAQ.
Last updated