Identify your version

To identify the version of the Amazon PostgreSQL RDS integration you're using:

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard, click the Amazon PostgreSQL RDS integration you want to check.
  3. 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 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:

  • Additional data type support
  • Support for logical replication
  • Support for Extraction Logs, Loading Reports, and Anchor Scheduling

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

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.