Extensions
pglogical_ticker

pglogical_ticker

pglogical_ticker : Have an accurate view on pglogical replication delay

Overview

ID Extension Package Version Category License Language
9510
pglogical_ticker
pglogical_ticker
 1.4.1
ETL
PostgreSQL
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--sLd--
No
Yes
Yes
Yes
no
no
Relationships
Schemas pglogical_ticker
Requires
pglogical
See Also
pglogical_origin
pgl_ddl_deploy
pg_failover_slots
pgactive
wal2json
decoderbufs
repmgr
decoder_raw

require a patch on el, pg18 break on el

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 1.4.1
18
17
16
15
14
 pglogical_ticker pglogical
RPM
PIGSTY
 1.4.1
18
17
16
15
14
 pglogical_ticker_$v pglogical_$v
DEB
PGDG
 1.4.1
18
17
16
15
14
 postgresql-$v-pglogical-ticker postgresql-$v-pglogical
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
el8.aarch64
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
el9.x86_64
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
el9.aarch64
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
el10.x86_64
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
el10.aarch64
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
PIGSTY 1.4.1
d12.x86_64
PIGSTY 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
d12.aarch64
PIGSTY 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
d13.x86_64
PIGSTY 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
d13.aarch64
PIGSTY 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
u22.x86_64
PIGSTY 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
u22.aarch64
PIGSTY 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
u24.x86_64
PIGSTY 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
u24.aarch64
PIGSTY 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
Package Version OS ORG SIZE File URL
pglogical_ticker_18 1.4.1 el8.x86_64 pigsty 17.6 KiB pglogical_ticker_18-1.4.1-2PIGSTY.el8.x86_64.rpm
pglogical_ticker_18 1.4.1 el8.aarch64 pigsty 17.7 KiB pglogical_ticker_18-1.4.1-2PIGSTY.el8.aarch64.rpm
pglogical_ticker_18 1.4.1 el9.x86_64 pigsty 17.6 KiB pglogical_ticker_18-1.4.1-2PIGSTY.el9.x86_64.rpm
pglogical_ticker_18 1.4.1 el9.aarch64 pigsty 17.6 KiB pglogical_ticker_18-1.4.1-2PIGSTY.el9.aarch64.rpm
pglogical_ticker_18 1.4.1 el10.x86_64 pigsty 17.6 KiB pglogical_ticker_18-1.4.1-2PIGSTY.el10.x86_64.rpm
pglogical_ticker_18 1.4.1 el10.aarch64 pigsty 17.8 KiB pglogical_ticker_18-1.4.1-2PIGSTY.el10.aarch64.rpm
postgresql-18-pglogical-ticker 1.4.1 d12.x86_64 pigsty 19.1 KiB postgresql-18-pglogical-ticker_1.4.1-2PIGSTY~bookworm_amd64.deb
postgresql-18-pglogical-ticker 1.4.1 d12.aarch64 pigsty 19.1 KiB postgresql-18-pglogical-ticker_1.4.1-2PIGSTY~bookworm_arm64.deb
postgresql-18-pglogical-ticker 1.4.1 d13.x86_64 pigsty 19.1 KiB postgresql-18-pglogical-ticker_1.4.1-2PIGSTY~trixie_amd64.deb
postgresql-18-pglogical-ticker 1.4.1 d13.aarch64 pigsty 19.2 KiB postgresql-18-pglogical-ticker_1.4.1-2PIGSTY~trixie_arm64.deb
postgresql-18-pglogical-ticker 1.4.1 u22.x86_64 pigsty 19.9 KiB postgresql-18-pglogical-ticker_1.4.1-2PIGSTY~jammy_amd64.deb
postgresql-18-pglogical-ticker 1.4.1 u22.aarch64 pigsty 19.7 KiB postgresql-18-pglogical-ticker_1.4.1-2PIGSTY~jammy_arm64.deb
postgresql-18-pglogical-ticker 1.4.1 u24.x86_64 pigsty 19.9 KiB postgresql-18-pglogical-ticker_1.4.1-2PIGSTY~noble_amd64.deb
postgresql-18-pglogical-ticker 1.4.1 u24.aarch64 pigsty 20.0 KiB postgresql-18-pglogical-ticker_1.4.1-2PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pglogical_ticker_17 1.4.1 el8.x86_64 pigsty 17.5 KiB pglogical_ticker_17-1.4.1-1PIGSTY.el8.x86_64.rpm
pglogical_ticker_17 1.4.1 el8.aarch64 pigsty 17.7 KiB pglogical_ticker_17-1.4.1-1PIGSTY.el8.aarch64.rpm
pglogical_ticker_17 1.4.1 el9.x86_64 pigsty 17.5 KiB pglogical_ticker_17-1.4.1-1PIGSTY.el9.x86_64.rpm
pglogical_ticker_17 1.4.1 el9.aarch64 pigsty 17.5 KiB pglogical_ticker_17-1.4.1-1PIGSTY.el9.aarch64.rpm
pglogical_ticker_17 1.4.1 el10.x86_64 pigsty 17.5 KiB pglogical_ticker_17-1.4.1-1PIGSTY.el10.x86_64.rpm
pglogical_ticker_17 1.4.1 el10.aarch64 pigsty 17.6 KiB pglogical_ticker_17-1.4.1-1PIGSTY.el10.aarch64.rpm
postgresql-17-pglogical-ticker 1.4.1 d12.x86_64 pgdg 20.9 KiB postgresql-17-pglogical-ticker_1.4.1-8.pgdg120+1_amd64.deb
postgresql-17-pglogical-ticker 1.4.1 d12.aarch64 pgdg 20.6 KiB postgresql-17-pglogical-ticker_1.4.1-8.pgdg120+1_arm64.deb
postgresql-17-pglogical-ticker 1.4.1 d13.x86_64 pgdg 20.8 KiB postgresql-17-pglogical-ticker_1.4.1-8.pgdg130+2_amd64.deb
postgresql-17-pglogical-ticker 1.4.1 d13.x86_64 pigsty 19.1 KiB postgresql-17-pglogical-ticker_1.4.1-2PIGSTY~trixie_amd64.deb
postgresql-17-pglogical-ticker 1.4.1 d13.aarch64 pgdg 20.7 KiB postgresql-17-pglogical-ticker_1.4.1-8.pgdg130+2_arm64.deb
postgresql-17-pglogical-ticker 1.4.1 d13.aarch64 pigsty 19.1 KiB postgresql-17-pglogical-ticker_1.4.1-2PIGSTY~trixie_arm64.deb
postgresql-17-pglogical-ticker 1.4.1 u22.x86_64 pgdg 20.9 KiB postgresql-17-pglogical-ticker_1.4.1-8.pgdg22.04+1_amd64.deb
postgresql-17-pglogical-ticker 1.4.1 u22.aarch64 pgdg 20.6 KiB postgresql-17-pglogical-ticker_1.4.1-8.pgdg22.04+1_arm64.deb
postgresql-17-pglogical-ticker 1.4.1 u24.x86_64 pgdg 20.4 KiB postgresql-17-pglogical-ticker_1.4.1-8.pgdg24.04+1_amd64.deb
postgresql-17-pglogical-ticker 1.4.1 u24.x86_64 pigsty 19.9 KiB postgresql-17-pglogical-ticker_1.4.1-2PIGSTY~noble_amd64.deb
postgresql-17-pglogical-ticker 1.4.1 u24.aarch64 pgdg 20.0 KiB postgresql-17-pglogical-ticker_1.4.1-8.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pglogical_ticker_16 1.4.1 el8.x86_64 pigsty 17.5 KiB pglogical_ticker_16-1.4.1-1PIGSTY.el8.x86_64.rpm
pglogical_ticker_16 1.4.1 el8.aarch64 pigsty 17.7 KiB pglogical_ticker_16-1.4.1-1PIGSTY.el8.aarch64.rpm
pglogical_ticker_16 1.4.1 el9.x86_64 pigsty 17.5 KiB pglogical_ticker_16-1.4.1-1PIGSTY.el9.x86_64.rpm
pglogical_ticker_16 1.4.1 el9.aarch64 pigsty 17.5 KiB pglogical_ticker_16-1.4.1-1PIGSTY.el9.aarch64.rpm
pglogical_ticker_16 1.4.1 el10.x86_64 pigsty 17.5 KiB pglogical_ticker_16-1.4.1-1PIGSTY.el10.x86_64.rpm
pglogical_ticker_16 1.4.1 el10.aarch64 pigsty 17.6 KiB pglogical_ticker_16-1.4.1-1PIGSTY.el10.aarch64.rpm
postgresql-16-pglogical-ticker 1.4.1 d12.x86_64 pgdg 20.8 KiB postgresql-16-pglogical-ticker_1.4.1-8.pgdg120+1_amd64.deb
postgresql-16-pglogical-ticker 1.4.1 d12.aarch64 pgdg 20.7 KiB postgresql-16-pglogical-ticker_1.4.1-8.pgdg120+1_arm64.deb
postgresql-16-pglogical-ticker 1.4.1 d13.x86_64 pgdg 20.8 KiB postgresql-16-pglogical-ticker_1.4.1-8.pgdg130+2_amd64.deb
postgresql-16-pglogical-ticker 1.4.1 d13.x86_64 pigsty 19.0 KiB postgresql-16-pglogical-ticker_1.4.1-2PIGSTY~trixie_amd64.deb
postgresql-16-pglogical-ticker 1.4.1 d13.aarch64 pgdg 20.7 KiB postgresql-16-pglogical-ticker_1.4.1-8.pgdg130+2_arm64.deb
postgresql-16-pglogical-ticker 1.4.1 d13.aarch64 pigsty 19.1 KiB postgresql-16-pglogical-ticker_1.4.1-2PIGSTY~trixie_arm64.deb
postgresql-16-pglogical-ticker 1.4.1 u22.x86_64 pgdg 20.9 KiB postgresql-16-pglogical-ticker_1.4.1-8.pgdg22.04+1_amd64.deb
postgresql-16-pglogical-ticker 1.4.1 u22.aarch64 pgdg 20.6 KiB postgresql-16-pglogical-ticker_1.4.1-8.pgdg22.04+1_arm64.deb
postgresql-16-pglogical-ticker 1.4.1 u24.x86_64 pgdg 20.4 KiB postgresql-16-pglogical-ticker_1.4.1-8.pgdg24.04+1_amd64.deb
postgresql-16-pglogical-ticker 1.4.1 u24.x86_64 pigsty 19.9 KiB postgresql-16-pglogical-ticker_1.4.1-2PIGSTY~noble_amd64.deb
postgresql-16-pglogical-ticker 1.4.1 u24.aarch64 pgdg 20.0 KiB postgresql-16-pglogical-ticker_1.4.1-8.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pglogical_ticker_15 1.4.1 el8.x86_64 pigsty 17.5 KiB pglogical_ticker_15-1.4.1-1PIGSTY.el8.x86_64.rpm
pglogical_ticker_15 1.4.1 el8.aarch64 pigsty 17.7 KiB pglogical_ticker_15-1.4.1-1PIGSTY.el8.aarch64.rpm
pglogical_ticker_15 1.4.1 el9.x86_64 pigsty 17.5 KiB pglogical_ticker_15-1.4.1-1PIGSTY.el9.x86_64.rpm
pglogical_ticker_15 1.4.1 el9.aarch64 pigsty 17.5 KiB pglogical_ticker_15-1.4.1-1PIGSTY.el9.aarch64.rpm
pglogical_ticker_15 1.4.1 el10.x86_64 pigsty 17.5 KiB pglogical_ticker_15-1.4.1-1PIGSTY.el10.x86_64.rpm
pglogical_ticker_15 1.4.1 el10.aarch64 pigsty 17.6 KiB pglogical_ticker_15-1.4.1-1PIGSTY.el10.aarch64.rpm
postgresql-15-pglogical-ticker 1.4.1 d12.x86_64 pgdg 20.8 KiB postgresql-15-pglogical-ticker_1.4.1-8.pgdg120+1_amd64.deb
postgresql-15-pglogical-ticker 1.4.1 d12.aarch64 pgdg 20.6 KiB postgresql-15-pglogical-ticker_1.4.1-8.pgdg120+1_arm64.deb
postgresql-15-pglogical-ticker 1.4.1 d13.x86_64 pgdg 20.8 KiB postgresql-15-pglogical-ticker_1.4.1-8.pgdg130+2_amd64.deb
postgresql-15-pglogical-ticker 1.4.1 d13.x86_64 pigsty 19.1 KiB postgresql-15-pglogical-ticker_1.4.1-2PIGSTY~trixie_amd64.deb
postgresql-15-pglogical-ticker 1.4.1 d13.aarch64 pgdg 20.7 KiB postgresql-15-pglogical-ticker_1.4.1-8.pgdg130+2_arm64.deb
postgresql-15-pglogical-ticker 1.4.1 d13.aarch64 pigsty 19.2 KiB postgresql-15-pglogical-ticker_1.4.1-2PIGSTY~trixie_arm64.deb
postgresql-15-pglogical-ticker 1.4.1 u22.x86_64 pgdg 20.9 KiB postgresql-15-pglogical-ticker_1.4.1-8.pgdg22.04+1_amd64.deb
postgresql-15-pglogical-ticker 1.4.1 u22.aarch64 pgdg 20.6 KiB postgresql-15-pglogical-ticker_1.4.1-8.pgdg22.04+1_arm64.deb
postgresql-15-pglogical-ticker 1.4.1 u24.x86_64 pgdg 20.4 KiB postgresql-15-pglogical-ticker_1.4.1-8.pgdg24.04+1_amd64.deb
postgresql-15-pglogical-ticker 1.4.1 u24.x86_64 pigsty 19.9 KiB postgresql-15-pglogical-ticker_1.4.1-2PIGSTY~noble_amd64.deb
postgresql-15-pglogical-ticker 1.4.1 u24.aarch64 pgdg 20.1 KiB postgresql-15-pglogical-ticker_1.4.1-8.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pglogical_ticker_14 1.4.1 el8.x86_64 pigsty 17.5 KiB pglogical_ticker_14-1.4.1-1PIGSTY.el8.x86_64.rpm
pglogical_ticker_14 1.4.1 el8.aarch64 pigsty 17.7 KiB pglogical_ticker_14-1.4.1-1PIGSTY.el8.aarch64.rpm
pglogical_ticker_14 1.4.1 el9.x86_64 pigsty 17.5 KiB pglogical_ticker_14-1.4.1-1PIGSTY.el9.x86_64.rpm
pglogical_ticker_14 1.4.1 el9.aarch64 pigsty 17.5 KiB pglogical_ticker_14-1.4.1-1PIGSTY.el9.aarch64.rpm
pglogical_ticker_14 1.4.1 el10.x86_64 pigsty 17.5 KiB pglogical_ticker_14-1.4.1-1PIGSTY.el10.x86_64.rpm
pglogical_ticker_14 1.4.1 el10.aarch64 pigsty 17.6 KiB pglogical_ticker_14-1.4.1-1PIGSTY.el10.aarch64.rpm
postgresql-14-pglogical-ticker 1.4.1 d12.x86_64 pgdg 20.8 KiB postgresql-14-pglogical-ticker_1.4.1-8.pgdg120+1_amd64.deb
postgresql-14-pglogical-ticker 1.4.1 d12.aarch64 pgdg 20.6 KiB postgresql-14-pglogical-ticker_1.4.1-8.pgdg120+1_arm64.deb
postgresql-14-pglogical-ticker 1.4.1 d13.x86_64 pgdg 20.8 KiB postgresql-14-pglogical-ticker_1.4.1-8.pgdg130+2_amd64.deb
postgresql-14-pglogical-ticker 1.4.1 d13.x86_64 pigsty 19.0 KiB postgresql-14-pglogical-ticker_1.4.1-2PIGSTY~trixie_amd64.deb
postgresql-14-pglogical-ticker 1.4.1 d13.aarch64 pgdg 20.7 KiB postgresql-14-pglogical-ticker_1.4.1-8.pgdg130+2_arm64.deb
postgresql-14-pglogical-ticker 1.4.1 d13.aarch64 pigsty 19.1 KiB postgresql-14-pglogical-ticker_1.4.1-2PIGSTY~trixie_arm64.deb
postgresql-14-pglogical-ticker 1.4.1 u22.x86_64 pgdg 20.8 KiB postgresql-14-pglogical-ticker_1.4.1-8.pgdg22.04+1_amd64.deb
postgresql-14-pglogical-ticker 1.4.1 u22.aarch64 pgdg 20.6 KiB postgresql-14-pglogical-ticker_1.4.1-8.pgdg22.04+1_arm64.deb
postgresql-14-pglogical-ticker 1.4.1 u24.x86_64 pgdg 20.4 KiB postgresql-14-pglogical-ticker_1.4.1-8.pgdg24.04+1_amd64.deb
postgresql-14-pglogical-ticker 1.4.1 u24.x86_64 pigsty 19.9 KiB postgresql-14-pglogical-ticker_1.4.1-2PIGSTY~noble_amd64.deb
postgresql-14-pglogical-ticker 1.4.1 u24.aarch64 pgdg 20.0 KiB postgresql-14-pglogical-ticker_1.4.1-8.pgdg24.04+1_arm64.deb

Source

Repository
github.com/enova/pglogical_ticker
 Source Tarball
pglogical_ticker-1.4.1.tar.gz
 
pig build pkg pglogical_ticker;		# build rpm/deb

Install

Make sure PGDG repo available:

pig repo add pgdg -u    # add pgdg repo and update cache

Install this extension with pig:

pig install pglogical_ticker;		# install via package name, for the active PG version

pig install pglogical_ticker -v 18;   # install for PG 18
pig install pglogical_ticker -v 17;   # install for PG 17
pig install pglogical_ticker -v 16;   # install for PG 16
pig install pglogical_ticker -v 15;   # install for PG 15
pig install pglogical_ticker -v 14;   # install for PG 14

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'pglogical, pglogical_ticker';

Create this extension with:

CREATE EXTENSION pglogical_ticker CASCADE; -- requires pglogical
Last updated on
pglogical_originpgl_ddl_deploy