Identify your version

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

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

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

Version features

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: ARRAY data 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

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.