# PostgreSQL Integration Changelog

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

Stay up-to-date by subscribing to our [RSS feed](https://help.qlik.com/en-US/stitch/changelog/feed.xml).

JUL 8, 2021 **NEW FEATURE**

### PostgreSQL (v2) update: Google CloudSQL PostgreSQL now available!

A new version (v2) of our Google CloudSQL PostgreSQL integration is now available!

Along with all of the new features in v2 of the PostgreSQL integration (which this integration is based on), we’ve also added support for:

* SSL connections
* Log-based Incremental Replication

Learn more in our [Google CloudSQL PostgreSQL integration documentation](https://www.stitchdata.com/en-US/stitch/integrations/databases/google-cloudsql-postgresql).

**Tags:** [NEW FEATURE](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#new-feature) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

JUN 2, 2021 **NEW FEATURE**

### PostgreSQL (v2) update: Leaving beta!

A new version (v) of our integration has left beta and is now generally available!

This version (v) of Stitch’s 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 integration, this version boasts increased performance and overall reduced replication time.

Notable improvements and changes in this version also include:

* **Expanded data type support**. This version supports additional data types. Refer to the [data types documentation](https://help.qlik.com/en-US/stitch/en-US/stitch#data-types) 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](https://www.stitchdata.com/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures).
* **Improved handling of schema changes in tables using Log-based Incremental Replication.** Adding and removing columns in these tables will no longer cause extraction errors. **Note**: This limitation still applies to [version 1](https://www.stitchdata.com/en-US/stitch/replication/replication-methods/log-based-incremental#limitation--structural-changes).

**Note**: The following features aren’t fully supported, but are being worked on:

* **Arrays of `DECIMAL`, `NUMERIC`, and `TIMESTAMP(TZ)` data types**
* \*\*Support for other flavors of \*\*. We’re in the process of testing this version of our integration with other flavors of , including Heroku, Google CloudSQL, Amazon Aurora, and Amazon RDS.

To get a look at how this version compares to the previous version of , refer to the [version comparison documentation](https://help.qlik.com/en-US/stitch/integrations/connection-cloning#supported-features).

**Tags:** [NEW FEATURE](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#new-feature) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

APR 19, 2021 **REMOVED**

[TAP-HP-POSTGRES #73](https://github.com/stitchdata/tap-hp-postgres/pull/73)

### PostgreSQL (HP) (v2) integration: Removed support for Composite, Range and OID types

We’ve removed support for Composite Types, Range Types and Object Identifier Types from our integration.

**Tags:** [REMOVED](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#removed) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

MAR 30, 2021 **IMPROVEMENT**

[DOCS #624](https://github.com/stitchdata/docs/pull/624)

### PostgreSQL (v2) update: Key-based Incremental Replication now available!

The v version of our 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:** [IMPROVEMENT](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#improvement) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

MAR 24, 2021 **NEW FEATURE**

[DOCS #620](https://github.com/stitchdata/docs/pull/620)

### 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:

* [Facebook Ads](https://help.qlik.com/en-US/stitch/integrations/saas/facebook-ads/changelog)

* [Google Analytics](https://help.qlik.com/en-US/stitch/integrations/saas/google-analytics/changelog)

* [MongoDB](https://help.qlik.com/en-US/stitch/integrations/databases/mongodb/changelog)

* [MySQL](https://help.qlik.com/en-US/stitch/integrations/databases/mysql/changelog)

* [PostgreSQL](https://help.qlik.com/en-US/stitch/integrations/databases/postgresql/changelog)

* [Salesforce](https://help.qlik.com/en-US/stitch/integrations/saas/salesforce/changelog)

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](https://github.com/stitchdata/docs/issues).

**Tags:** [NEW FEATURE](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#new-feature) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration) [DOCUMENTATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#documentation)

MAR 5, 2021 **BETA**

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

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

This version (v) of Stitch’s 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 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](https://help.qlik.com/en-US/stitch/integrations/databases/postgresql/changelog#data-replication--column-name-transformations) in the docs for more info.
* **Expanded data type support**. This version supports additional data types. Refer to the [data types documentation](https://help.qlik.com/en-US/stitch/integrations/databases/postgresql#data-types) 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](https://help.qlik.com/en-US/stitch/).

**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 , refer to the [version comparison documentation](https://help.qlik.com/en-US/stitch/integrations/databases/postgresql#supported-features).

**Tags:** [BETA](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#beta) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

AUG 20, 2020 **BUG FIX**

[TAP-POSTGRES #101](https://github.com/singer-io/tap-postgres/pull/101)

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

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

**Tags:** [BUG FIX](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#bug-fix) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

FEB 27, 2020 **BUG FIX**

[TAP-POSTGRES #80](https://github.com/singer-io/tap-postgres/pull/80)

### PostgreSQL (v1) integrations: Correctly use SSL connections

We’ve fixed an issue with (v) 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:** [BUG FIX](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#bug-fix) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

JAN 27, 2020 **BUG FIX**

[TAP-POSTGRES #76](https://github.com/singer-io/tap-postgres/pull/76)

### 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 (v) integrations. With this fix, these columns will now correctly display as `UNSUPPORTED` in Stitch.

**Tags:** [BUG FIX](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#bug-fix) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

DEC 1, 2019 **REMOVED**

### PostgreSQL (v15-10-2015) sunset

The v version of our integration has been sunset. As of today, this version of the integration has been removed from Stitch and will no longer function.

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

**Tags:** [REMOVED](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#removed) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

OCT 22, 2019 **BUG FIX**

[TAP-POSTGRES #69](https://github.com/singer-io/tap-postgres/pull/69)

### 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:** [BUG FIX](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#bug-fix) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

SEP 6, 2019 **DEPRECATION**

### PostgreSQL (v15-10-2015) deprecation

The v version of our integration has been deprecated. As of today, this version of the integration is no longer formally supported.

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

**Tags:** [DEPRECATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#deprecation) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

JAN 3, 2019 **IMPROVEMENT**

[TAP-POSTGRES #31](https://github.com/singer-io/tap-postgres/pull/31)

### PostgreSQL (v1) integrations: BIGINT array support

(v) integrations now support arrays of `BIGINT`s.

**Tags:** [IMPROVEMENT](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#improvement) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

SEP 19, 2018 **BUG FIX**

[TAP-POSTGRES #23](https://github.com/singer-io/tap-postgres/pull/23)

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

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

**Tags:** [BUG FIX](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#bug-fix) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

SEP 19, 2018 **BUG FIX**

[TAP-POSTGRES #23](https://github.com/singer-io/tap-postgres/pull/23)

### 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:** [BUG FIX](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#bug-fix) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

AUG 28, 2018 **NEW FEATURE**

[TAP-POSTGRES #19](https://github.com/singer-io/tap-postgres/pull/19)

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

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

![The include schema names in destination table names setting in Stitch](https://help.qlik.com/en-US/stitch/images/changelog/include-postgres-schema-names-destination-tables.png)The include schema names in destination table names setting in StitchThe 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:** [NEW FEATURE](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#new-feature) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

AUG 21, 2018 **IMPROVEMENT**

[TAP-POSTGRES #18](https://github.com/singer-io/tap-postgres/pull/18)

### PostgreSQL (v1) integrations: Expanded replication slot support

Stitch now supports Log-based Incremental Replication across multiple databases in a single 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:** [IMPROVEMENT](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#improvement) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

AUG 3, 2018 **IMPROVEMENT**

[TAP-POSTGRES #15](https://github.com/singer-io/tap-postgres/pull/15)

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

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

**Tags:** [IMPROVEMENT](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#improvement) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

AUG 1, 2018 **NEW FEATURE**

### PostgreSQL integration: New version (v1)

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

We’ve worked hard to ensure this new integration is the best way to extract data from to your Stitch destination. The new integration, based on the [Singer standard](https://www.singer.io/), includes many new features such as:

* [Logical replication support](https://www.stitchdata.com/en-US/stitch/replication/replication-methods/log-based-incremental), which allows you to replicate data from database binary logs, including hard deletes, without the use of a Replication Key
* User-facing [Extraction Logs](https://www.stitchdata.com/en-US/stitch/replication/extractions/integration-extraction-logs)
* [Table and field selection](https://www.stitchdata.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate)
* [Enhanced scheduling options](https://www.stitchdata.com/en-US/stitch/replication/replication-scheduling)
* [Run and stop Extraction](https://www.stitchdata.com/en-US/stitch/replication/extractions/start-stop-extraction-jobs) on demand functionality
* Availability via the [Stitch Connect API](https://www.stitchdata.com/en-US/stitch/developers/stitch-connect)
* Enhanced schema validation

Get started today by creating a new integration or learn more in the [updated documentation](https://www.stitchdata.com/en-US/stitch/integrations/connection-cloning).

**Tags:** [NEW FEATURE](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#new-feature) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

MAR 22, 2017 **IMPROVEMENT**

### 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](https://www.stitchdata.com/en-US/stitch) AND a [destination](https://www.stitchdata.com/en-US/stitch) - a dual threat!

**Tags:** [IMPROVEMENT](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#improvement) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration) [DESTINATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#destination)

SEP 6, 2016 **NEW FEATURE**

### 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:** [NEW FEATURE](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#new-feature) [REPLICATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#replication) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)

AUG 5, 2016 **IMPROVEMENT**

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

All 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:** [IMPROVEMENT](https://help.qlik.com/en-US/stitch/changelog/archives/entry-types#improvement) [INTEGRATION](https://help.qlik.com/en-US/stitch/changelog/archives/entry-categories#integration)