bgw_replstatus

Small PostgreSQL background worker to report whether a node is a replication master or standby

Overview

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

Information

Metadata

  • Latest Version: 1.0.6
  • 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.6
  • DEB Deps: N/A

Packages

OS Arch PG17 PG16 PG15 PG14 PG13
el8 x86_64 bgw_replstatus_17
PGDG 1.0.6
bgw_replstatus_16
PGDG 1.0.6
bgw_replstatus_15
PGDG 1.0.6
bgw_replstatus_14
PGDG 1.0.6
bgw_replstatus_13
PGDG 1.0.6
el8 aarch64 bgw_replstatus_17
PGDG 1.0.6
bgw_replstatus_16
PGDG 1.0.6
bgw_replstatus_15
PGDG 1.0.6
bgw_replstatus_14
PGDG 1.0.6
bgw_replstatus_13
PGDG 1.0.6
el9 x86_64 bgw_replstatus_17
PGDG 1.0.6
bgw_replstatus_16
PGDG 1.0.6
bgw_replstatus_15
PGDG 1.0.6
bgw_replstatus_14
PGDG 1.0.6
bgw_replstatus_13
PGDG 1.0.6
el9 aarch64 bgw_replstatus_17
PGDG 1.0.6
bgw_replstatus_16
PGDG 1.0.6
bgw_replstatus_15
PGDG 1.0.6
bgw_replstatus_14
PGDG 1.0.6
bgw_replstatus_13
PGDG 1.0.6
d12 x86_64 postgresql-17-bgw-replstatus
PGDG 1.0.7
postgresql-16-bgw-replstatus
PGDG 1.0.7
postgresql-15-bgw-replstatus
PGDG 1.0.7
postgresql-14-bgw-replstatus
PGDG 1.0.7
postgresql-13-bgw-replstatus
PGDG 1.0.7
d12 aarch64 postgresql-17-bgw-replstatus
PGDG 1.0.7
postgresql-16-bgw-replstatus
PGDG 1.0.7
postgresql-15-bgw-replstatus
PGDG 1.0.7
postgresql-14-bgw-replstatus
PGDG 1.0.7
postgresql-13-bgw-replstatus
PGDG 1.0.7
u22 x86_64 postgresql-17-bgw-replstatus
PGDG 1.0.7
postgresql-16-bgw-replstatus
PGDG 1.0.7
postgresql-15-bgw-replstatus
PGDG 1.0.7
postgresql-14-bgw-replstatus
PGDG 1.0.7
postgresql-13-bgw-replstatus
PGDG 1.0.7
u22 aarch64 postgresql-17-bgw-replstatus
PGDG 1.0.7
postgresql-16-bgw-replstatus
PGDG 1.0.7
postgresql-15-bgw-replstatus
PGDG 1.0.7
postgresql-14-bgw-replstatus
PGDG 1.0.7
postgresql-13-bgw-replstatus
PGDG 1.0.7
u24 x86_64 postgresql-17-bgw-replstatus
PGDG 1.0.7
postgresql-16-bgw-replstatus
PGDG 1.0.7
postgresql-15-bgw-replstatus
PGDG 1.0.7
postgresql-14-bgw-replstatus
PGDG 1.0.7
postgresql-13-bgw-replstatus
PGDG 1.0.7
u24 aarch64 postgresql-17-bgw-replstatus
PGDG 1.0.7
postgresql-16-bgw-replstatus
PGDG 1.0.7
postgresql-15-bgw-replstatus
PGDG 1.0.7
postgresql-14-bgw-replstatus
PGDG 1.0.7
postgresql-13-bgw-replstatus
PGDG 1.0.7

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 added to shared_preload_libraries

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

Extension %s does not need CREATE EXTENSION command





Last modified 2025-02-17: add extension part (cfa504b)