PostgreSQL External Projects

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.

Continue reading

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.

Continue reading

pg_squeeze: Shrinks tables better than VACUUM

Summary: pg_squeeze is an PostgreSQL extension that automatically fixes table bloat without extensive table locking.

Continue reading

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.

Continue reading

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.

Continue reading

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.

Continue reading

wal2json: JSON output plugin for changeset extraction

Summary: wal2json is a JSON output plugin for changeset extraction in PostgreSQL.

Continue reading

Metrics in Linux monitoring with Prometheus

Summary: This article contains details about the metrics collected by the node_exporter.

Continue reading

Metrics in PostgreSQL monitoring with Prometheus

Summary: This article contains details about the metrics collected by the postgres_exporter.

Continue reading

repmgr: Overview

Summary: This chapter provides a high-level overview of repmgr’s components and functionality.

Continue reading