3 Node Multi-Master Replication with EDB Postgres Replication Server 7.BETA
Published on Sun, Apr 28, 2019

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 →

Install PL/Java in PostgreSQL 11
Published on Sun, Mar 31, 2019

Refer to the article posted on the community blog Install PL/Java in PostgreSQL 11. –Raghav Continue reading →

A Real Integration: EDB Failover Manager and PgPool for High-Availability
Published on Wed, Nov 7, 2018

Refer to the article I have posted on EDB Postgres Rocks forum on A Real Integration: EDB Failover Manager and PgPool for High-Availability Short video on Youtube https://youtu.be/pgZJiXa3SoY –Raghav Continue reading →

Upgrade Existing EDB Failover Manager 3.1 cluster to EFM 3.2. Explained in 5 Steps
Published on Thu, Oct 11, 2018

Refer to the article I have posted on EDB Postgres Rocks forum on Upgrade Existing EDB Failover Manager 3.1 cluster to EFM 3.2. Explained in 5 Steps –Raghav Continue reading →

Validating JSON data type column in PostgreSQL
Published on Thu, Aug 23, 2018

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 →