PostgreSQL Release Notes

June 2022 (v 3.3.1)

Panoply now supports SSL connection to Postgres databases. You can enable SSL connection and use certificates to protect the connection based on your needs.

January 2022 (v 3.3.0)

Collecting data using logical replication is now available. In order to use logical replication in your data source you need to:

• Have logical replication enabled on your Postgres server:
  • Server version 10 and higher
  • Set wal_level to logical.
  • Create a publication on specific tables or all tables.
    CREATE PUBLICATION panoply_publication FOR TABLE table1, table2 WITH (publish = 'insert, update'); or CREATE PUBLICATION panoply_publication FOR ALL TABLES WITH (publish = 'insert, update');
  • Set the desired tables to have the replica identity set to FULL: ALTER TABLE table1 REPLICA IDENTITY FULL;
  • Create a Panoply dedicated replication slot.
    SELECT pg_create_logical_replication_slot('panoply_replication_slot', 'pgoutput');
  • Make sure that the connected user in the Panoply data source has replication permissions: ALTER USER replication_user REPLICATION;
• Enable logical replication in the advanced options
• Select the desired publication name.
• Select the desired replication slot name.

Once the logical replication is enabled in Panoply, only tables that are part of the selected publication will be available for selection.

October 2020

Panoply has refreshed the PostgreSQL data source and is opening it up to public beta. As a part of this refresh, a number of bug fixes were also addressed.  For detailed PostgresSQL information, see PostgreSQL Documentation.

Panoply will migrate all instances of PostgreSQL in your data warehouse. For more information about this migration, see Supplemental Release Notes for PostgreSQL.