Blog Posts by

Best of Both Worlds: Integrating Pgpool with EDB Postgres Failover Manager
January 23, 2018
EDB Postgres Failover Manager (EFM) is a high availability module from EnterpriseDB (EDB) that monitors the health of Postgres clusters and verifies...
Transitioning Synchronous Standby to Asynchronous in EDB Postgres
May 04, 2017
In the world of solution architecture, where we as solution architects are developing configurations to meet specific customer needs, we often...
Monitoring Amazon PostgreSQL RDS with PEM version 6.0
February 10, 2017
The EDB Postgres ™ Enterprise Manager is an enterprise management tool designed to tune, manage, and monitor a large number of Postgres deployments...
Data Replication from Oracle Logical Standby to EDB Postgres
January 20, 2017
At EnterpriseDB ® (EDB ™ ), we are sometimes presented with individual customer use cases or requests that call for the development of innovative...
The pg_rewind Improvements in PostgreSQL 9.6
January 11, 2017
The pg_rewind tool was first introduced in PostgreSQL 9.5. This is best used in a situation when a standby becomes a master, then the old master can...
Partition Pruning in EDB Postgres 9.5
December 22, 2016
One of my colleagues who was recently working with a customer has presented a customer case. According to him, the customer has a partitioned table...
User Tip: Postgres Plus 9.4 and Global Temporary Tables
October 21, 2015
EnterpriseDB (EDB) customers who moved/migrated their database from Oracle to EDB’s Postgres Plus Advanced Server (PPAS) frequently ask for Global...
Postgres and Transparent Data Encryption (TDE)
August 13, 2015
Security has always been a great concern of Enterprises. Especially, if you have crucial information stored in the database, you would always prefer...
Dynamic RLS implementation in PPAS 9.3
December 10, 2014
In the course of my work at EnterpriseDB, migrating Oracle databases to EnterpriseDB’s Postgres Plus Advanced Server is a common task. However, now...
Compiling PLV8 with Postgres Plus Advanced Server
December 03, 2014
PLV8 is a programming language that lets users write stored procedures and triggers in JavaScript and store them in their Postgres database. This...
Meet BART – A New Tool for Backup And Recovery Management
November 18, 2014
EnterpriseDB recently launched a new tool for backup and recovery – named simply EDB Backup and Recovery Tool, or BART . This tool makes the DBA’s...
Switchover/Switchback in PostgreSQL 9.3
June 30, 2014
PostgreSQL 9.3 has two key software updates making switchover/switchback easier in High Availability configurations. First, let’s address the...
Monitoring approach for Streaming Replication with Hot Standby in PostgreSQL 9.3.
May 21, 2014
The people using PostgreSQL and the Streaming Replication feature seem to ask many of the same questions: 1. How best to monitor Streaming...
Write Operation: MongoDB Vs PostgreSQL 9.3 (JSON)
May 15, 2014
PostgreSQL 9.3 has lot of new improvement like the addition of new operators for JSON data type in postgreSQL, that prompted me to explore its...
List user privileges in PostgreSQL/PPAS 11
July 29, 2012
PostgreSQL has some useful functions which can be used to know about the privilege of a user on a particular Database object. Those functions are...
Monitor CPU and MEMORY percentage used by each process in PostgreSQL/PPAS 9.1
July 23, 2012
PostgreSQL has pg_stat_activity view which can be use to get the session details. This view gives following information: 1. datid: database OID 2...

Top Authors

Bruce Momjian is a co-founder of the PostgreSQL Global Development Group, and has worked on Po...

Robert is Chief Architect, Database Server, employed at EnterpriseDB as well as a PostgreSQL C...

Before joining EnterpriseDB, Marc spent almost 4 years at Polycom, the leading maker of video ...

Ken Rugg is EDB's Chief Product and Strategy Officer and is charged with leading the company's...