PostgreSQL 18 Upgrades for AI-Era Workloads and Operations
Today, we're asking PostgreSQL to do more and more, like handling both transactions and analytics, powering huge SaaS platforms, managing event data, and even dipping into AI-related tasks like vector search. This intense pressure highlights...
Multi-tenant, multi-cloud logical and bi-directional replication deep dive
Before we dive deep into the fascinating world of PostgreSQL Logical and Bi-Directional Replication (BDR), let's take a quick moment to look at multi-tenancy and multi-cloud strategies. Setting the stage for today’s cloud operating model,...
How to Migrate Cloud PostgreSQL to On-Prem with Minimal Downtime
In the last decade, cloud adoption has accelerated as organizations looked to scale quickly, reduce upfront capital investment, and leverage managed services. However, in recent years, a growing number of companies are choosing to migrate...
How ClusterControl Saved Christmas – Part 3
The Real-Time Workshop Welcome to the 3rd of a 6 part holiday series called, How ClusterControl Saved Christmas! If you missed part one, start here: Part 1 Inside Santa’s Streaming Architecture for Naughty & Nice...
Automating Backups and Disaster Recovery in PostgreSQL at Scale: pgBackRest vs. Barman
The importance of Disaster Recovery (DR) strategies, especially for your core RDBMs workloads, cannot be overstated in today’s always on world. That’s why it’s important to have a well designed strategy to ensure that data...
Query observability and performance tuning with pg_stat_monitor and pg_stat_statements
With the rapid evolution of database technologies and the constant demand for quick solutions, being able to understand the internal state of a system is crucial to achieving success. Observability tools give you a comprehensive view...
Best practices for securing PostgreSQL in hybrid environments
PostgreSQL adoption keeps accelerating, especially across hybrid architectures that span on-premises, private, and public clouds. But with that growth comes risk. Hybrid setups introduce new attack surfaces — from inconsistent firewall rules and multiple IAM...
Migration and upgrades: achieving near zero-downtime in PostgreSQL
Migrating or upgrading a PostgreSQL database carries significant risk, particularly for organizations with strict uptime requirements. Whether the objective is a major version upgrade, hardware relocation, or a shift between cloud environments, maintaining uninterrupted service...
PostgreSQL Bi-Directional Logical Replication — A Deep Dive
PostgreSQL offers a robust, open-source, reliable, and flexible database system allowing businesses to scale their data operations effectively. PostgreSQL continues to improve to meet the needs of modern applications. One of its recent improvements is...
Clustercontrol adds PostgreSQL Bi-Directional Logical Replication and Valkey Sentinel v8.0 in latest release
Clustercontrol v2.3.1 is here, packed with powerful new enhancements to simplify database management and ensure high availability across databases. This release introduces PostgreSQL Bi-Directional Logical Replication and expands support for Valkey Sentinel v8.0, an open-source...
Improving LLM Fidelity with Retrieval Augmented Generation using pgvector
Large language models (LLMs) have taken the world by storm, wowing us with their ability to generate remarkably human-like text. But for all their prowess, these AI marvels still face major roadblocks – especially when...
What’s new in PG15
PostgreSQL releases major versions relatively often, about once a year. This is because the PostgreSQL Global Development Group (PGDG) is committed to providing new features and improvements to the database on a regular basis. Of...