Identify your version
To identify the version of the Amazon PostgreSQL RDS integration you're using:
- Sign into your Stitch account.
- On the Stitch Dashboard, click the Amazon PostgreSQL RDS integration you want to check.
- Click the Extraction Logs tab:
- If you see a list of extraction logs, the integration's version is v1.0.
- If you see No logs available for this integration yet., the integration's version is v15-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 Amazon PostgreSQL RDS integration, including release and deprecation dates.
- Changelog - Details about updates to Stitch's Amazon 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 Amazon PostgreSQL RDS integration, has been released. Highlights include:
|
Amazon PostgreSQL RDS version features
In this section:
Amazon PostgreSQL RDS supported features
Amazon PostgreSQL RDS version 1.0 (latest) |
Amazon PostgreSQL RDS version 15-10-2015 |
|
CONNECTION METHODS | ||
SSH Connections | Supported | Supported |
SSL Connections | Supported | Supported |
REPLICATION SETTINGS | ||
Anchor Scheduling | Supported | Unsupported |
Advanced 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 |
Data types
In the table below are the data types Amazon PostgreSQL RDS integrations support and the Stitch data type it will map to, depending on the version of the integration being used:
- indicates that the data type is supported. Following the icon is the Stitch data type it will map to.
- indicates that the data type is supported, but there is additional information you should know. Hover over the icon to view a tooltip with the information.
- indicates that the data type isn't applicable to the integration. This is usually because the integration doesn't use that particular data type.
- indicates that the data type isn't supported. In Stitch, columns with unsupported data types will have Unavailable in the Type column of the Tables to Replicate tab.
Refer to the Data typing guide for more info about how Stitch identifies and types data when it's loaded into your destination.
Amazon PostgreSQL RDS version 1.0 (latest) |
Amazon PostgreSQL RDS version 15-10-2015 |
|
ARRAY | ARRAY | STRING |
BIGINT | INTEGER | INTEGER |
BIT | BOOLEAN | BOOLEAN |
CHAR | STRING | STRING |
CIDR | STRING | UNSUPPORTED |
CITEXT | STRING | UNSUPPORTED |
DATE | STRING , formatted as DATE-TIME | STRING , formatted as DATE-TIME |
DECIMAL | NUMBER | NUMBER |
DOUBLE | NUMBER | NUMBER |
FLOAT | NUMBER | NUMBER |
HSTORE | OBJECT | STRING |
INET | STRING | STRING |
INTEGER | INTEGER | INTEGER |
IP | STRING | UNSUPPORTED |
JSON | ARRAY | STRING |
JSONB | ARRAY | STRING |
LONGNVARCHAR | STRING | STRING |
LONGVARCHAR | STRING | STRING |
MACADDR | STRING | UNSUPPORTED |
MONEY | STRING | UNSUPPORTED |
NCHAR | STRING | STRING |
NUMERIC | NUMBER | NUMBER |
NVARCHAR | STRING | STRING |
REAL | NUMBER | NUMBER |
SMALLINT | INTEGER | INTEGER |
TIME | STRING , formatted as DATE-TIME | STRING , formatted as DATE-TIME |
TIMESTAMP | STRING , formatted as DATE-TIME | STRING , formatted as DATE-TIME |
TINYINT | INTEGER | INTEGER |
UUID | STRING | STRING |
VARCHAR | 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.