<img height="1" width="1" style="display:none;" alt="" src="https://px.ads.linkedin.com/collect/?pid=2826169&amp;fmt=gif">
Start  trial

    Start trial

      The latest PostgreSQL 15 release brings significant improvements to logical replication, which fortifies CREATE/ ALTER PUBLICATION capabilities, and benefits by enhancing security, improving ease of use, and reducing network traffic.

      Fujitsu Enterprise Postgres 15 inherits OSS enhancements in logical replication with publication 'tables in schema' option and filtering of rows and columns of a table.

      Introduction

      Logical replication is a method of replicating logical changes based upon their replica identity. Now in Fujitsu Enterprise Postgres 15, a few important enhancements are introduced in logical replication. Here we introduce three key new features.

      Allow publication of all tables in a schema

      Up to Fujitsu Enterprise Postgres 14, to create a publication for a schema with n tables, you need to specify those n tables manually during CREATE PUBLICATION. Whenever new tables are added to the schema, they must be added to publication explicitly using ALTER PUBLICATION.

      Now in Fujitsu Enterprise Postgres 15, you can add all the tables of a specific schema for logical replication during CREATE PUBLICATION.

      Let’s see how all the tables in a particular schema can be added to the publication, including the new tables created after the publication is created, using Fujitsu Enterprise Postgres 15 CREATE PUBLICATION...TABLES IN SCHEMA option.

       

       

      For more details of this enhancement, visit this article.

      Logical replication of tables in schema in PostgreSQL 15

      Allow publication content to be filtered using a WHERE clause

      Up to Fujitsu Enterprise Postgres 14, it was not possible to filter rows with WHERE clause in the CREATE PUBLICATION. Publishing all rows of a table may have adverse effect on network traffic and sensitive data.

      Now in Fujitsu Enterprise Postgres 15, this limitation is mitigated. You can specify WHERE clause in CREATE/ ALTER PUBLICATION statement. This allows to limit the table’s tuples replicated.

      Let’s see how the rows of a table can be filtered in FEP15 CREATE PUBLICATION based on WHERE clause expression.

       

       

      For more details of this enhancement, visit this article.

      Introducing publication row filters

      Allow publications to be restricted to specific columns

      Up to Fujitsu Enterprise Postgres 14, it is not possible to list specific columns of a table in CREATE/ ALTER PUBLICATION. Publishing all columns of a table may have adverse effect on network traffic and sensitive data.

      Now in Fujitsu Enterprise Postgres 15, this limitation is mitigated. You can specify column lists in CREATE/ ALTER PUBLICATION statement. This allows to replicate only specific columns of a table.

      Let’s see with Fujitsu Enterprise Postgres 15 CREATE PUBLICATION how only selected columns can be published, instead of all the columns of a table.

       

      For more details of this enhancement, visit this article.

      Column lists in logical replication publications - an overview of this useful PostgreSQL feature

      Summary

      To summarize, this post helps to leverage the new features of logical replication, by replicating only relevant data, reducing administrative overhead and protect sensitive data.

      Fujitsu Enterprise Postgres
      is an enhanced distribution of PostgreSQL, 100% compatible and with extended features.
      Compare the list of features.
      Subscribe to be notified of future blog posts
      If you would like to be notified of my next blog posts and other PostgreSQL-related articles, fill the form here.
      We also have a series of technical articles for PostgreSQL enthusiasts of all stripes, with tips and how-to's.

       

      Explore PostgreSQL Insider >

      Topics: PostgreSQL, PostgreSQL community, Logical replication, Demo

      Receive our blog

      Search by topic

      see all >

      Read our latest blogs

      Read our most recent articles regarding all aspects of PostgreSQL and Fujitsu Enterprise Postgres.

      Receive our blog

      Fill the form to receive notifications of future posts

      Search by topic

      see all >