PostgreSQL 15 introduces a new feature that allows specifying column lists in publications, to restrict the amount of data replicated. Let's see what are the advantages of this feature and how to use it.
Together, Fujitsu and IBM are helping clients build a modern environment that is designed to improve business agility and reduce overall costs by leveraging the next generation of IBM LinuxONE’s highly secured and sustainable platform. Read more here.
Fujitsu has worked with PostgreSQL community to make some improvements to the communication of logical replication in PostgreSQL 15. Let me show you some details.
The planet has been warming at a steady pace and it's projected to keep doing so. While technology has played a part in this situation, it can become part of the solution.
Fujitsu has worked with the PostgreSQL community to add a new feature that filters rows for logical replication. This allows users to create customized logical replication solutions that replicate row data only when it matches a specified filter expression.
In this blog post I conclude my discussion on the new mechanisms available in PostgreSQL to handle logical replication conflicts by explaining how to use the ALTER SUBSCRIPTION SKIP command.
Logical replication is widely used as an easy and flexible way to replicate data. And now PostgreSQL makes it even easier by providing some mechanisms to handle replication conflicts. Let me show you how.
The concept of data portability is relevant not only as part of the regulatory framework governing customer data privacy - it is also important for organizations moving data across applications and hybrid cloud. Let me show you how.
We are pleased to announce that Fujitsu Enterprise Postgres is now available on IBM Power®, the platform that makes it easier to adopt the hybrid cloud and modernize your applications.
The upcoming PostgreSQL 15 introduces a new feature added by the Fujitsu OSS team in collaboration with the PostgreSQL open source community that allows supporting of two-phase commits in logical replication using publications/subscriptions. Let's take a look at how to use it.
The global average cost of data breach in 2021 was over $4.2M†, surging 10% from last year. As data becomes ever more valuable, organizations must fend off cyber-attacks which keep increasing in number and sophistication.
In this post I would like to discuss the new feature added to the upcoming PostgreSQL 15 by the Fujitsu OSS team in collaboration with the PostgreSQL open source community, to enable logical replication of tables in a schema.
In this blog post I will explain the new system view pg_stat_replication_slots introduced in PostgreSQL, and how you can use it to obtain information on logical replication in your system.