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 →
Refer to the article posted on the community blog Install PL/Java in PostgreSQL 11. –Raghav Continue reading →
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 →
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 →
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 →