Product and documentation updates about the PostgreSQL integration from the team at Stitch.

Stay up-to-date by subscribing to our RSS feed.


  • PostgreSQL (v2) integrations: Key-based Incremental Replication now available!

    The v2 version of our PostgreSQL integration, which is currently in open beta, now supports Key-based Incremental Replication. All of Stitch’s supported Replication Methods are now available for this version - go try it out!

    Tags:

  • New feature: Integration changelogs

    Introducing: Integration changelogs!

    Check out the history of our integrations and stay in the loop on updates with dedicated changelogs for these integrations:

    We’ll add changelogs for other popular integrations and destinations in the weeks to come. If there’s a specific integration you’d like to see us work on, let us know by creating an issue in the Stitch Docs GitHub repo.

    Tags:

  • PostgreSQL integration: New version (v2) now in beta

    A new version (v2) of our PostgreSQL integration is now in beta!

    This version (v2) of Stitch’s PostgreSQL integration optimizes replication by utilizing Avro schemas to write and validate data, thereby reducing the amount of time spent on data extraction and preparation. Compared to previous versions of the PostgreSQL integration, this version boasts increased performance and overall reduced replication time.

    Notable improvements and changes in this version also include:

    • New column (field) naming rules. Avro has specific rules that dictate how columns can be named. As a result, column names will be canonicalized to adhere to Avro rules and persisted to your destination using the Avro-friendly name. Refer to the Column name transformations section in the PostgreSQL docs for more info.
    • Expanded data type support. This version supports additional PostgreSQL data types. Refer to the PostgreSQL data types documentation for more info.
    • Improved handling of JSON, JSONB, and HSTORE data types. In previous versions, these data types were treated as strings. This version will send them to your destination as JSON objects, which may result in de-nesting.

    Note: The following features aren’t currently supported, but will be before the integration leaves beta:

    • Key-based Incremental Replication
    • ARRAY data type

    To get a look at how this version compares to the previous version of PostgreSQL, refer to the PostgreSQL version comparison documentation.

    Tags:

  • PostgreSQL (v1) integrations: Include partitioned tables in discovery

    Previously, partitioned tables weren’t being detected during Discovery for PostgreSQL (v1) integrations. This has been corrected.

    Tags:

  • PostgreSQL (v1) integrations: Correctly use SSL connections

    We’ve fixed an issue with PostgreSQL (v1) integrations where SSL connections weren’t being used, even if the SSL option was checked in Stitch. If checked, Stitch will now correctly use and enforce SSL when connecting to the database.

    Tags:

  • PostgreSQL (v1) integrations: Correctly display BYTEA data as unsupported

    Previously, Stitch would display columns typed as BYTEA as available for selection, despite this data type currently being unsupported for PostgreSQL (v1) integrations. With this fix, these columns will now correctly display as UNSUPPORTED in Stitch.

    Tags:

  • PostgreSQL (v15-10-2015) sunset

    The v15-10-2015 version of our PostgreSQL integration has been sunset. As of today, this version of the PostgreSQL integration has been removed from Stitch and will no longer function.

    Migrate to the latest version of PostgreSQL (v1) today to continue replicating data.

    Tags:

  • PostgreSQL (v1) integrations: Correctly type BIGINT[] data for Log-based Incremental Replication

    Previously, Log-based Incremental Replication was incorrectly typing data types of INT8[] as STRING during data type conversion. This has been corrected.

    Tags:

  • PostgreSQL (v15-10-2015) deprecation

    The v15-10-2015 version of our PostgreSQL integration has been deprecated. As of today, this version of the PostgreSQL integration is no longer formally supported.

    While connections using v15-10-2015 will continue to run, this version will be sunset in the future. Migrate to the latest version of PostgreSQL (v1) today to prevent possible disruptions.

    Tags:

  • PostgreSQL (v1) integrations: BIGINT array support

    PostgreSQL (v1) integrations now support arrays of BIGINTs.

    Tags:

  • PostgreSQL (v1) integrations: Fix selected-by-default behavior

    We’ve fixed an issue with PostgreSQL (v1) integrations where columns marked as selected-by-default will now be replicated unless explicitly deselected.

    Tags:

  • PostgreSQL (v1) integrations: Primary Key discovery

    Previously, Primary Keys weren’t detected during Discovery if other indices or unique constraints existed on the column. This has been corrected.

    Tags:

  • PostgreSQL (v1) integrations: Include schema name in destination table names

    We’ve added a new setting to PostgreSQL (v1) integrations:

    The include schema names in destination table names setting in Stitch

    When checked, Stitch will include schema names from the source database in the destination table name when the table is created. For example: <source_schema_name>__<table_name>

    Stitch loads all selected replicated tables to a single schema, preserving only the table name. If two tables canonicalize to the same name - even if they’re in different source databases or schemas - name collision errors can arise. Checking this setting can prevent these issues.

    Note: This setting can not be changed after the integration is saved. Additionally, this setting may create table names that exceed your destination’s limits.

    Tags:

  • PostgreSQL (v1) integrations: Expanded replication slot support

    Stitch now supports Log-based Incremental Replication across multiple databases in a single PostgreSQL cluster. Previously, Stitch supported one replication slot per integration and required it to be named stitch. Now, Stitch will look for the replication slot you define before falling back to stitch.

    Tags:

  • PostgreSQL (v1) integrations: PG 10 now supported for Logical Replication

    Stitch now supports PostgreSQL 10 when using Log-based Incremental Replication. Previously, Stitch supported PostgreSQL 9.4.x - 9.9.x.

    Tags:

  • PostgreSQL integration: New version (v1)

    A new version (v1) of our PostgreSQL integration is now available!

    We’ve worked hard to ensure this new integration is the best way to extract data from PostgreSQL to your Stitch destination. The new integration, based on the Singer standard, includes many new features such as:

    Get started today by creating a new PostgreSQL integration or learn more in the updated documentation.

    Tags:

  • Google Cloud SQL PostgreSQL Support

    We’re excited to report that Stitch supports the recently announced PostgreSQL flavor of the the Google CloudSQL service. It’s available as both an input integration AND a destination - a dual threat!

    Tags:

  • Reset Replication Keys for database integrations

    Need to completely re-replicate all incrementally replicated tables in a database integration? Now you can(!) via the Integration Settings page on any MySQL, PostgreSQL, Microsoft SQL Server, or MongoDB integration. Take care though - the re-replicated rows count towards your monthly caps.

    Tags:

  • PostgreSQL (v15-10-2015) integrations: ARRAY and JSONB data type support

    All PostgreSQL fields of type JSONB and ARRAY may now be tracked from the Integrations page. These fields will be converted to strings in Amazon Redshift.

    Tags: