PostgreSQL DBA

Installation pglogical

Architecture Overview

pglogical is a PostgreSQL extension that provides logical replication with more features than built-in logical replication — including DDL replication, conflict handling, and row/column filtering.

Quick Decision Guide

Replication in PostgreSQL ensures data is copied from one server (primary) to one or more servers (replicas/standbys). Here's a comprehensive guide covering the main approaches.

A comprehensive collection of practical PostgreSQL how-to guides covering database management, optimization, troubleshooting, and best practices. These guides are derived from real-world scenarios and provide actionable solutions to common PostgreSQL challenges.