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
Log-based Replication for PostgreSQL RDS-based databases requires:
-
PostgreSQL databases running PostgreSQL versions 9.4.x or greater. Earlier versions of PostgreSQL do not include logical replication functionality, which is required for Log-based 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 |
|
| CONNECTION METHODS | ||
| SSH Connections | Supported | Supported |
| SSL Connections | Supported | Supported |
| REPLICATION SETTINGS | ||
| Anchor Scheduling | Supported | Unsupported |
| Table-level Reset | Supported | Supported |
| Configurable Replication Methods | Supported | Supported |
| REPLICATION METHODS | ||
| Log-based Replication | Supported | Unsupported |
| Key-based Replication | Supported | Supported |
| Full Table Replication | Supported | Supported |
| DATA SELECTION | ||
| Table Selection | Supported | Supported |
| Column Selection | Supported | Supported |
| View Replication | Supported | Supported |
| TRANSPARENCY | ||
| Extraction Logs | Supported | Unsupported |
| Loading Reports | 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.