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 →

Configure Streaming Replication in PostgreSQL 10
Published on Sun, Jul 22, 2018

In this post, we configure Streaming Replication between One Master and 2 Standbys(Standby 1/Standby 2). Replication will be 1:1 but not cascading. Below are my setup details OS - RedHat Enterprise Linux 7.x Master IP - Standby 1 IP - Standby 2 IP - Installation Today www.postgresql.org distributes binaries in different formats contributed by many companies. For this setup, am going to use YUM method of installation as shown in the main website link here. Continue reading →

Upgrading an Existing EDB Failover Manager Cluster 3.0 to new EFM 3.1
Published on Tue, Jun 19, 2018

As you all know, EDB Failover Manager(EFM) provides the high availability insfrastructure for EDB Postgres clusters. Failover Manager monitors the members of a Postgres cluster, identifies and verifies database failures quickly and reliably, and if needed promotes a standby node to become the cluster master and issues alerts. Every release of EFM has new features and functionalities and to take benefit of it you may need to upgrade your existing cluster to new version. Continue reading →

Compiling plpgsql_check extension with EDB Postgres 9.6
Published on Tue, Apr 10, 2018

plpgsql_check extension helps developers to validate all embeded SQL and SQL statements inside plpgsql function. Its one of the useful extensions particularly when working with plpgsql development. For more details refer to plpgsql_check documentation. By default, plpgsql_check extension not enabled in community PostgreSQL or commercial EDB Postgres. You need compile the extension with your flavor database. Community PostgreSQL compilation is easy and documented in the above reference link, however below steps help you to compile with commercial EDB Postgres database. Continue reading →