3 Node Multi-Master Replication with EDB Postgres Replication Server 7.BETA

Please Note: The steps described in this article today(04/28/2019) refers to EDB Postgres Replication Server 7.x BETA. Expect some of the steps may change in GA or future releases. Recommended to refer to latest documentation here Watch steps-covering video: https://www.youtube.com/watch?v=NPSgtzrU7VU Most of us know EnterpriseDB has a software package for cross database Multi-Master Replication(MMR) or Single-Master Replication(SMR) servers that supports an asynchronous replication system to replicate data to EDB Postgres Advanced Server(EPAS) and PostgreSQL.

Continue reading →

Validating JSON data type column in PostgreSQL

In this post, we see how to validate the JSON/JSONB data type column in PostgreSQL 10. Most of the basic JSON/JSONB validation has been taken care in core of PostgreSQL itself, however you may have a requirement to validate the JSON format elements data types while inserting. For such requirements, you need to write a Pl/PgSQL function to validate the JSON data when accepting it in JSON/JSONB column in a CHECK constraint.

Continue reading →