PostgreSQL emulates nested transactions with savepoints. A savepoint records a position within an open transaction; it allows selective rolllback without aborting the outer transaction. Key commands: SAVEPOINT name: create a rollback marker ROLLBACK TO [SAVEPOINT] name: undo all work after that mar...
PostgreSQL logical replication offfers a straightforward path to uni-directional streaming. With careful design, it can also underpin multi-primary (multi-master) deployments by addressing two core challenges: Concurrency conflicts when multiple nodes modify the same row Replication loops that endle...
Subscriber-side visibility Table-level progress: pg_subscription_rel Table synchronization state for each subscription is exposed through pg_subscription_rel. Joining with pg_subscription and pg_class makes the output easier to read. SELECT s.subname, c.relname AS table_name, r.srsubstate, r.srsubls...
SonarQube 8.3 supports Oracle, SQL Server, and PostgreSQL. For a lightweight, license-free option suitable for isolated environments, PostgreSQL is a practical choice. The following steps outline an offline setup on a RHEL 7 system. Download RPMs for Offline Install Visit https://www.postgresql.org/...
This document provides a comprehensive guide to implementing high availability and load balancing for PostgreSQL databases using pgpool-II in a cluster setup. The content covers installation, configurasion, failover strategies, and cluster validation. Overview of pgpoool-II pgpool-II acts as a middl...