Identify your version
To identify the version of the PostgreSQL RDS integration you're using:
- Sign into your Stitch account.
- On the Stitch Dashboard, click the PostgreSQL RDS you want to check.
- Click the Extraction Logs tab:
- If you see a list of extraction logs, the integration's version is 1.0.
- If you see No logs available for this integration yet., the integration's version is 15-10-2015.
-
version 1.0 (latest)
Setup | Replication -
version 15-10-2015
Setup | Replication
Version history
In this section:
- Overview - All versions for Stitch's PostgreSQL RDS integration, including release and deprecation dates.
- Changelog - Details about updates to Stitch's PostgreSQL RDS integration, including new/deprecated versions, schema changes, new data availability, etc.
| Version | Release date | Deprecation date |
| version 1.0 (latest) | July 31, 2018 | n/a |
| version 15-10-2015 | October 15, 2015 | To be determined |
| Date | Version | Release notes |
| July 31, 2018 | 1.0 |
New integration version (1.0) Version 1.0 of Singer's PostgreSQL tap, which backs Stitch's PostgreSQL RDS integration, has been released. Highlights include:
|
Version features
Important: Log-based Replication requirements
On August 6, 2018, we discovered some limitations with PostgreSQL RDS Log-based Replication. Currently, Log-based Replication requires:
-
PostgreSQL databases running PostgreSQL versions 9.4.x-9.9.x. If your database is running PostgreSQL 10 or greater, Log-based Replication will not work. Some of the functions Stitch uses to replicate data were renamed in PostgreSQL 10.
We are working on adding support for logical replication - which is what Stitch uses to perform Log-based Replication - to the integration. In the meantime, use Key-based Incremental Replication.
-
A connection to the master instance. Log-based replication will only work on master instances due to a feature gap in PostgreSQL 10. Based on their forums, PostgreSQL is working on adding support for using logical replication on a read replica to a future version.
Until this feature is released, you can connect Stitch to the master instance and use Log-based Replication, or connect to a read replica and use Key-based Incremental Replication.
In this section:
PostgreSQL RDS supported features
|
PostgreSQL RDS version 1.0 (latest) |
PostgreSQL RDS version 15-10-2015 |
|
| Anchor scheduling | Supported | Unsupported |
| Extraction logs | Supported | Unsupported |
| Loading reports | Supported | Supported |
| Table selection | Supported | Supported |
| Column selection | Supported | Supported |
| SSH connections | Supported | Supported |
| SSL connections | Supported | Supported |
| Log-based replication | Supported | Unsupported |
| View replication | Supported | Supported |
PostgreSQL RDS supported data types
PostgreSQL RDS integrations support the data types in the table below, in addition to the common data types.
In the table are the data types and how they'll be stored in your destination, depending on the version of the integration being used:
-
marks supported data types. Following the icon is how Stitch will store the data type in the destination. For example:
ARRAYdata types will be stored as strings. - marks unsupported data types. In Stitch, columns with unsupported data types will have Unavailable in the Type column of the Tables to Replicate tab.
|
PostgreSQL RDS version 1.0 (latest) |
PostgreSQL RDS version 15-10-2015 |
|
| COMMON DATA TYPES | Supported | Supported |
| ARRAY | STRING | STRING |
| CIDR | STRING | Unsupported |
| CITEXT | STRING | Unsupported |
| HSTORE | Nested maps | STRING |
| INET | STRING | Unsupported |
| IP | STRING | Unsupported |
| JSON | STRING | STRING |
| JSONB | STRING | STRING |
| MACADDR | STRING | Unsupported |
| MONEY | STRING | Unsupported |
| UUID | STRING | STRING |
| Related | Troubleshooting |
Questions? Feedback?
Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.