pg-osc: Zero downtime schema changes in PostgreSQL
Summary: pg-osc is an easy command-line tool for making zero downtime schema changes and backfills in PostgreSQL.
PostgreSQL External Projects: Table of Contents
The PostgreSQL community has a number of external projects that are separate from the core project, and provide more rich capabilities for the PostgreSQL database.
pg_squeeze: Shrinks tables better than VACUUM
Summary: pg_squeeze is an PostgreSQL extension that automatically fixes table bloat without extensive table locking.
PG Collector: SQL script for PostgreSQL health inspection
Summary: PG Collector for PostgreSQL is a sql script that gathers valuable database information, and presents it in a consolidated HTML file which provides a convenient way to view and navigate between different sections of the report.
parquet_s3_fdw: PostgreSQL Foreign Data Wrapper for Parquet S3
Summary: The parquet_s3_fdw extension is a Foreign Data Wrapper (FDW) for accessing Parquet file on local file system and Amazon S3.
pg_auto_failover: PostgreSQL automated failover and high availability
Summary: The pg_auto_failover is a PostgreSQL extension and service for automated failover and high availability.
wal2json: JSON output plugin for changeset extraction
Summary: wal2json is a JSON output plugin for changeset extraction in PostgreSQL.
Metrics in Linux monitoring with Prometheus
Summary: This article contains details about the metrics collected by the node_exporter.
Metrics in PostgreSQL monitoring with Prometheus
Summary: This article contains details about the metrics collected by the postgres_exporter.
repmgr: Overview
Summary: This chapter provides a high-level overview of repmgr’s components and functionality.