Logical replication in PostgreSQL is a publish-subscribe model, where a subscriber node can subscribe to a publisher and receive logical changes from the publisher in real time
PostgreSQL 13 is here, and as always EDB is proud to be among the many global contributors who made this happen. This year there’s not one headline-grabbing feature, but rather...
Many organizations today are constantly looking for new ways to give their offerings a competitive edge. Bringing new features to a saturated market means you have to stand up to...
This article offers tips and shortcuts for performing useful tasks in Postgres. Whole-row references Comparing a selection of columns Hardcoded tables Custom config parameters Booleans can stand alone Convert column...
In this talk from Postgres Vision 2020, Abhinav Sagar, Senior Database Consultant, and Premnath Jangam, Senior Database Administrator, from CSG International discuss the various methodologies, procedures, and techniques involved in...
“We need to attain ZERO downtime and high performance in our application,” I was told during a conversation with a manager of a line of business during a conference last...
The team at Enterprise DB is pleased to announce the release of its new system_stats extension for Postgres and EDB Postgres Advanced Server. What is system_stats extension? The system_stats extension...
A PostgreSQL Database Failure and a Failover A customer reached out to the Support team on a random Tuesday, some months ago. They had experienced a failure of their primary...
This blog is part of a series of blogs on best practices for high availability. In previous blogs, we discussed What Does High Availability Really Mean, Patching Minor Version in...