bgw_replstatus

Overview

PGDG 1st Party Extension: bgw_replstatus : Small PostgreSQL background worker to report whether a node is a replication master or standby

Information

• Extension ID: 6340
• Extension Name: bgw_replstatus
• Package Name: bgw_replstatus
• Category: STAT
• License: PostgreSQL
• Website: https://github.com/mhagander/bgw_replstatus
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 1.0.7
• Postgres Support: 17,16,15,14,13
• Need Load: Explicit Loading Required
• Need DDL: Dd not need CREATE EXTENSION DDL
• Relocatable: Unknown
• Trusted: Untrusted, Require Superuser to Create
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PGDG
• RPM Name: bgw_replstatus_$v*
• RPM Ver : 1.0.6
• RPM Deps: N/A
• DEB Repo: PGDG
• DEB Name: postgresql-$v-bgw-replstatus
• DEB Ver : 1.0.7
• DEB Deps: N/A

Availability

Installation

Install bgw_replstatus via the pig CLI tool:

pig ext install bgw_replstatus

Install bgw_replstatus via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["bgw_replstatus"]}' # -l <cls>

Install bgw_replstatus RPM from YUM repo directly:

dnf install bgw_replstatus_17*;
dnf install bgw_replstatus_16*;
dnf install bgw_replstatus_15*;
dnf install bgw_replstatus_14*;
dnf install bgw_replstatus_13*;

Install bgw_replstatus DEB from APT repo directly:

apt install postgresql-17-bgw-replstatus;
apt install postgresql-16-bgw-replstatus;
apt install postgresql-15-bgw-replstatus;
apt install postgresql-14-bgw-replstatus;
apt install postgresql-13-bgw-replstatus;

Extension bgw_replstatus has to be loaded via shared_preload_libraries

shared_preload_libraries = 'bgw_replstatus'; # add to pg cluster config

Extension %s does not need CREATE EXTENSION command