Please note that our Postgres destination is currently in open beta. The information in this article is subject to change.
To complete the setup, you need to enter the Postgres-RDS instance information into Stitch. This is done in the Destination Settings page in Stitch, which you can access by clicking the User menu (your icon) > Destination Settings.
Locating Your Postgres-RDS Details
The majority of this info can be found on the Database Details page in the AWS Console. You can access this page by:
- Navigating to the RDS Dashboard.
- Selecting the Postgres instance.
- Clicking the Instance Actions menu and selecting See Details.
In this page, you’ll need to locate these fields:
- Database (DB) Name
- Username: You’ll only use the username in this field if you’re using the master user to connect Stitch.
Below is a screen cap of this page with the fields highlighted:
Entering the Connection Details into Stitch
- If you’re not already, sign into your Stitch account using another tab or window.
- Click the User menu (your icon) > Destination Settings.
- Click the PostgreSQL icon.
- In the PostgreSQL Destination Settings page, fill in the following fields:
Click Update PostgreSQL Settings.
- Host: Paste the address from the Endpoint field in the AWS Database Details page. Don’t include the port number, which is appended to the end of the endpoint - this will cause errors.
For example, if you used the default port, you’d remove the following from the address: :5432
- Port: Enter the port used by the Postgres-RDS instance.
- Database: Enter the name of the Postgres-RDS database. This is the database name found in the DB Name field in the AWS Database Details page.
- Username: This can be the master username (the user you created when you launched the instance) or the name of the Stitch user from step 4 of this tutorial. In the screen cap above, the master username is highlighted.
- Password: Enter the password associated with the user you entered in the Username field.
Stitch will perform a connection test to the Postgres-RDS database; if successful, a Success! message will display at the top of the screen. Note that this test may take a few minutes to complete.
Troubleshooting Connection Errors
If you receive an error message, we recommend checking out our troubleshooting resources - especially this Troubleshooting Postgres Destination Errors doc - before reaching out to support.
We’ve found that, the majority of the time, these resources can be resolve the most common issues without our assistance.
Learning About Stitch & Postgres
Now that your Postgres destination is up and running, we recommend learning about how Stitch will load and store your data in your data warehouse.
The Postgres Destination Overview doc is a good jumping-off point for learning about how Stitch handles nested data structures, certain data types, and more.