Extensions
pg_background

pg_background

pg_background : Run SQL queries in the background

Overview

ID Extension Package Version Category License Language
1100
pg_background
pg_background
 1.5
TIME
GPL-3.0
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d-r
No
Yes
No
Yes
yes
no
Relationships
See Also
pg_cron
pg_task
pg_later
pgq
timescaledb
timescaledb_toolkit
timeseries
periods

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
MIXED
 1.5
18
17
16
15
14
13
 pg_background -
RPM
PGDG
 1.5
18
17
16
15
14
13
 pg_background_$v* -
DEB
PIGSTY
 1.5
18
17
16
15
14
13
 postgresql-$v-pg-background -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PGDG 1.5
PGDG 1.3
PGDG 1.3
PGDG 1.3
PGDG 1.3
PGDG 1.3
el8.aarch64
PGDG 1.5
PGDG 1.3
PGDG 1.3
PGDG 1.3
PGDG 1.3
PGDG 1.3
el9.x86_64
PGDG 1.5
PGDG 1.3
PGDG 1.3
PGDG 1.3
PGDG 1.3
PGDG 1.3
el9.aarch64
PGDG 1.5
PGDG 1.3
PGDG 1.3
PGDG 1.3
PGDG 1.3
PGDG 1.3
el10.x86_64
PGDG 1.5
PGDG 1.3
PGDG 1.3
PGDG 1.3
PGDG 1.3
PGDG 1.3
el10.aarch64
PGDG 1.5
PGDG 1.3
PGDG 1.3
PGDG 1.3
PGDG 1.3
PGDG 1.3
d12.x86_64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
d12.aarch64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
d13.x86_64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
d13.aarch64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
u22.x86_64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
u22.aarch64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
u24.x86_64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
u24.aarch64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
Package Version OS ORG SIZE File URL
pg_background_18 1.5 el8.x86_64 pgdg 22.5 KiB pg_background_18-1.5-1PGDG.rhel8.x86_64.rpm
pg_background_18 1.5 el8.aarch64 pgdg 22.0 KiB pg_background_18-1.5-1PGDG.rhel8.aarch64.rpm
pg_background_18 1.5 el9.x86_64 pgdg 22.7 KiB pg_background_18-1.5-1PGDG.rhel9.x86_64.rpm
pg_background_18 1.5 el9.aarch64 pgdg 22.0 KiB pg_background_18-1.5-1PGDG.rhel9.aarch64.rpm
pg_background_18 1.5 el10.x86_64 pgdg 23.1 KiB pg_background_18-1.5-1PGDG.rhel10.x86_64.rpm
pg_background_18 1.5 el10.aarch64 pgdg 22.6 KiB pg_background_18-1.5-1PGDG.rhel10.aarch64.rpm
postgresql-18-pg-background 1.5 d12.x86_64 pigsty 41.0 KiB postgresql-18-pg-background_1.5-1PIGSTY~bookworm_amd64.deb
postgresql-18-pg-background 1.5 d12.aarch64 pigsty 39.8 KiB postgresql-18-pg-background_1.5-1PIGSTY~bookworm_arm64.deb
postgresql-18-pg-background 1.5 d13.x86_64 pigsty 40.9 KiB postgresql-18-pg-background_1.5-1PIGSTY~trixie_amd64.deb
postgresql-18-pg-background 1.5 d13.aarch64 pigsty 39.9 KiB postgresql-18-pg-background_1.5-1PIGSTY~trixie_arm64.deb
postgresql-18-pg-background 1.5 u22.x86_64 pigsty 44.9 KiB postgresql-18-pg-background_1.5-1PIGSTY~jammy_amd64.deb
postgresql-18-pg-background 1.5 u22.aarch64 pigsty 44.0 KiB postgresql-18-pg-background_1.5-1PIGSTY~jammy_arm64.deb
postgresql-18-pg-background 1.5 u24.x86_64 pigsty 42.9 KiB postgresql-18-pg-background_1.5-1PIGSTY~noble_amd64.deb
postgresql-18-pg-background 1.5 u24.aarch64 pigsty 41.9 KiB postgresql-18-pg-background_1.5-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_background_17 1.3 el8.x86_64 pgdg 21.9 KiB pg_background_17-1.3-1PGDG.rhel8.x86_64.rpm
pg_background_17 1.2 el8.x86_64 pgdg 20.1 KiB pg_background_17-1.2-2PGDG.rhel8.x86_64.rpm
pg_background_17 1.3 el8.aarch64 pgdg 21.3 KiB pg_background_17-1.3-1PGDG.rhel8.aarch64.rpm
pg_background_17 1.2 el8.aarch64 pgdg 19.6 KiB pg_background_17-1.2-2PGDG.rhel8.aarch64.rpm
pg_background_17 1.3 el9.x86_64 pgdg 22.3 KiB pg_background_17-1.3-1PGDG.rhel9.x86_64.rpm
pg_background_17 1.2 el9.x86_64 pgdg 20.5 KiB pg_background_17-1.2-2PGDG.rhel9.x86_64.rpm
pg_background_17 1.3 el9.aarch64 pgdg 21.6 KiB pg_background_17-1.3-1PGDG.rhel9.aarch64.rpm
pg_background_17 1.2 el9.aarch64 pgdg 19.9 KiB pg_background_17-1.2-2PGDG.rhel9.aarch64.rpm
pg_background_17 1.3 el10.x86_64 pgdg 22.8 KiB pg_background_17-1.3-3PGDG.rhel10.x86_64.rpm
pg_background_17 1.3 el10.aarch64 pgdg 22.3 KiB pg_background_17-1.3-3PGDG.rhel10.aarch64.rpm
postgresql-17-pg-background 1.5 d12.x86_64 pigsty 41.0 KiB postgresql-17-pg-background_1.5-1PIGSTY~bookworm_amd64.deb
postgresql-17-pg-background 1.5 d12.aarch64 pigsty 39.8 KiB postgresql-17-pg-background_1.5-1PIGSTY~bookworm_arm64.deb
postgresql-17-pg-background 1.5 d13.x86_64 pigsty 40.9 KiB postgresql-17-pg-background_1.5-1PIGSTY~trixie_amd64.deb
postgresql-17-pg-background 1.5 d13.aarch64 pigsty 39.9 KiB postgresql-17-pg-background_1.5-1PIGSTY~trixie_arm64.deb
postgresql-17-pg-background 1.5 u22.x86_64 pigsty 48.8 KiB postgresql-17-pg-background_1.5-1PIGSTY~jammy_amd64.deb
postgresql-17-pg-background 1.5 u22.aarch64 pigsty 48.0 KiB postgresql-17-pg-background_1.5-1PIGSTY~jammy_arm64.deb
postgresql-17-pg-background 1.5 u24.x86_64 pigsty 42.8 KiB postgresql-17-pg-background_1.5-1PIGSTY~noble_amd64.deb
postgresql-17-pg-background 1.5 u24.aarch64 pigsty 41.9 KiB postgresql-17-pg-background_1.5-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_background_16 1.3 el8.x86_64 pgdg 21.9 KiB pg_background_16-1.3-1PGDG.rhel8.x86_64.rpm
pg_background_16 1.2 el8.x86_64 pgdg 19.7 KiB pg_background_16-1.2-1PGDG.rhel8.x86_64.rpm
pg_background_16 1.3 el8.aarch64 pgdg 21.3 KiB pg_background_16-1.3-1PGDG.rhel8.aarch64.rpm
pg_background_16 1.2 el8.aarch64 pgdg 19.2 KiB pg_background_16-1.2-1PGDG.rhel8.aarch64.rpm
pg_background_16 1.3 el9.x86_64 pgdg 22.3 KiB pg_background_16-1.3-1PGDG.rhel9.x86_64.rpm
pg_background_16 1.2 el9.x86_64 pgdg 19.9 KiB pg_background_16-1.2-1PGDG.rhel9.x86_64.rpm
pg_background_16 1.3 el9.aarch64 pgdg 21.6 KiB pg_background_16-1.3-1PGDG.rhel9.aarch64.rpm
pg_background_16 1.2 el9.aarch64 pgdg 19.2 KiB pg_background_16-1.2-1PGDG.rhel9.aarch64.rpm
pg_background_16 1.3 el10.x86_64 pgdg 22.8 KiB pg_background_16-1.3-3PGDG.rhel10.x86_64.rpm
pg_background_16 1.3 el10.aarch64 pgdg 22.4 KiB pg_background_16-1.3-3PGDG.rhel10.aarch64.rpm
postgresql-16-pg-background 1.5 d12.x86_64 pigsty 41.0 KiB postgresql-16-pg-background_1.5-1PIGSTY~bookworm_amd64.deb
postgresql-16-pg-background 1.5 d12.aarch64 pigsty 39.8 KiB postgresql-16-pg-background_1.5-1PIGSTY~bookworm_arm64.deb
postgresql-16-pg-background 1.5 d13.x86_64 pigsty 41.0 KiB postgresql-16-pg-background_1.5-1PIGSTY~trixie_amd64.deb
postgresql-16-pg-background 1.5 d13.aarch64 pigsty 39.8 KiB postgresql-16-pg-background_1.5-1PIGSTY~trixie_arm64.deb
postgresql-16-pg-background 1.5 u22.x86_64 pigsty 48.7 KiB postgresql-16-pg-background_1.5-1PIGSTY~jammy_amd64.deb
postgresql-16-pg-background 1.5 u22.aarch64 pigsty 47.9 KiB postgresql-16-pg-background_1.5-1PIGSTY~jammy_arm64.deb
postgresql-16-pg-background 1.5 u24.x86_64 pigsty 42.8 KiB postgresql-16-pg-background_1.5-1PIGSTY~noble_amd64.deb
postgresql-16-pg-background 1.5 u24.aarch64 pigsty 41.8 KiB postgresql-16-pg-background_1.5-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_background_15 1.3 el8.x86_64 pgdg 21.9 KiB pg_background_15-1.3-1PGDG.rhel8.x86_64.rpm
pg_background_15 1.2 el8.x86_64 pgdg 19.6 KiB pg_background_15-1.2-1PGDG.rhel8.x86_64.rpm
pg_background_15 1.0 el8.x86_64 pgdg 39.3 KiB pg_background_15-1.0-1.rhel8.x86_64.rpm
pg_background_15 1.3 el8.aarch64 pgdg 21.2 KiB pg_background_15-1.3-1PGDG.rhel8.aarch64.rpm
pg_background_15 1.2 el8.aarch64 pgdg 19.2 KiB pg_background_15-1.2-1PGDG.rhel8.aarch64.rpm
pg_background_15 1.0 el8.aarch64 pgdg 38.7 KiB pg_background_15-1.0-1.rhel8.aarch64.rpm
pg_background_15 1.3 el9.x86_64 pgdg 22.2 KiB pg_background_15-1.3-1PGDG.rhel9.x86_64.rpm
pg_background_15 1.2 el9.x86_64 pgdg 19.9 KiB pg_background_15-1.2-1PGDG.rhel9.x86_64.rpm
pg_background_15 1.0 el9.x86_64 pgdg 40.6 KiB pg_background_15-1.0-1.rhel9.x86_64.rpm
pg_background_15 1.3 el9.aarch64 pgdg 21.6 KiB pg_background_15-1.3-1PGDG.rhel9.aarch64.rpm
pg_background_15 1.2 el9.aarch64 pgdg 19.1 KiB pg_background_15-1.2-1PGDG.rhel9.aarch64.rpm
pg_background_15 1.0 el9.aarch64 pgdg 39.7 KiB pg_background_15-1.0-1.rhel9.aarch64.rpm
pg_background_15 1.3 el10.x86_64 pgdg 22.8 KiB pg_background_15-1.3-3PGDG.rhel10.x86_64.rpm
pg_background_15 1.3 el10.aarch64 pgdg 22.3 KiB pg_background_15-1.3-3PGDG.rhel10.aarch64.rpm
postgresql-15-pg-background 1.5 d12.x86_64 pigsty 40.9 KiB postgresql-15-pg-background_1.5-1PIGSTY~bookworm_amd64.deb
postgresql-15-pg-background 1.5 d12.aarch64 pigsty 39.8 KiB postgresql-15-pg-background_1.5-1PIGSTY~bookworm_arm64.deb
postgresql-15-pg-background 1.5 d13.x86_64 pigsty 40.9 KiB postgresql-15-pg-background_1.5-1PIGSTY~trixie_amd64.deb
postgresql-15-pg-background 1.5 d13.aarch64 pigsty 39.8 KiB postgresql-15-pg-background_1.5-1PIGSTY~trixie_arm64.deb
postgresql-15-pg-background 1.5 u22.x86_64 pigsty 48.7 KiB postgresql-15-pg-background_1.5-1PIGSTY~jammy_amd64.deb
postgresql-15-pg-background 1.5 u22.aarch64 pigsty 47.8 KiB postgresql-15-pg-background_1.5-1PIGSTY~jammy_arm64.deb
postgresql-15-pg-background 1.5 u24.x86_64 pigsty 42.8 KiB postgresql-15-pg-background_1.5-1PIGSTY~noble_amd64.deb
postgresql-15-pg-background 1.5 u24.aarch64 pigsty 41.8 KiB postgresql-15-pg-background_1.5-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_background_14 1.3 el8.x86_64 pgdg 21.9 KiB pg_background_14-1.3-1PGDG.rhel8.x86_64.rpm
pg_background_14 1.0 el8.x86_64 pgdg 39.6 KiB pg_background_14-1.0-1.rhel8.x86_64.rpm
pg_background_14 1.3 el8.aarch64 pgdg 21.2 KiB pg_background_14-1.3-1PGDG.rhel8.aarch64.rpm
pg_background_14 1.0 el8.aarch64 pgdg 38.6 KiB pg_background_14-1.0-1.rhel8.aarch64.rpm
pg_background_14 1.3 el9.x86_64 pgdg 22.2 KiB pg_background_14-1.3-1PGDG.rhel9.x86_64.rpm
pg_background_14 1.2 el9.x86_64 pgdg 19.9 KiB pg_background_14-1.2-1PGDG.rhel9.x86_64.rpm
pg_background_14 1.3 el9.aarch64 pgdg 21.6 KiB pg_background_14-1.3-1PGDG.rhel9.aarch64.rpm
pg_background_14 1.0 el9.aarch64 pgdg 39.5 KiB pg_background_14-1.0-1.rhel9.aarch64.rpm
pg_background_14 1.3 el10.x86_64 pgdg 22.8 KiB pg_background_14-1.3-3PGDG.rhel10.x86_64.rpm
pg_background_14 1.3 el10.aarch64 pgdg 22.4 KiB pg_background_14-1.3-3PGDG.rhel10.aarch64.rpm
postgresql-14-pg-background 1.5 d12.x86_64 pigsty 41.0 KiB postgresql-14-pg-background_1.5-1PIGSTY~bookworm_amd64.deb
postgresql-14-pg-background 1.5 d12.aarch64 pigsty 39.7 KiB postgresql-14-pg-background_1.5-1PIGSTY~bookworm_arm64.deb
postgresql-14-pg-background 1.5 d13.x86_64 pigsty 40.9 KiB postgresql-14-pg-background_1.5-1PIGSTY~trixie_amd64.deb
postgresql-14-pg-background 1.5 d13.aarch64 pigsty 39.8 KiB postgresql-14-pg-background_1.5-1PIGSTY~trixie_arm64.deb
postgresql-14-pg-background 1.5 u22.x86_64 pigsty 48.7 KiB postgresql-14-pg-background_1.5-1PIGSTY~jammy_amd64.deb
postgresql-14-pg-background 1.5 u22.aarch64 pigsty 47.8 KiB postgresql-14-pg-background_1.5-1PIGSTY~jammy_arm64.deb
postgresql-14-pg-background 1.5 u24.x86_64 pigsty 42.8 KiB postgresql-14-pg-background_1.5-1PIGSTY~noble_amd64.deb
postgresql-14-pg-background 1.5 u24.aarch64 pigsty 41.8 KiB postgresql-14-pg-background_1.5-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_background_13 1.3 el8.x86_64 pgdg 21.8 KiB pg_background_13-1.3-1PGDG.rhel8.x86_64.rpm
pg_background_13 1.0 el8.x86_64 pgdg 39.1 KiB pg_background_13-1.0-1.rhel8.x86_64.rpm
pg_background_13 1.3 el8.aarch64 pgdg 21.2 KiB pg_background_13-1.3-1PGDG.rhel8.aarch64.rpm
pg_background_13 1.0 el8.aarch64 pgdg 38.4 KiB pg_background_13-1.0-1.rhel8.aarch64.rpm
pg_background_13 1.3 el9.x86_64 pgdg 22.2 KiB pg_background_13-1.3-1PGDG.rhel9.x86_64.rpm
pg_background_13 1.2 el9.x86_64 pgdg 19.9 KiB pg_background_13-1.2-1PGDG.rhel9.x86_64.rpm
pg_background_13 1.3 el9.aarch64 pgdg 21.6 KiB pg_background_13-1.3-1PGDG.rhel9.aarch64.rpm
pg_background_13 1.0 el9.aarch64 pgdg 39.4 KiB pg_background_13-1.0-1.rhel9.aarch64.rpm
pg_background_13 1.3 el10.x86_64 pgdg 22.8 KiB pg_background_13-1.3-3PGDG.rhel10.x86_64.rpm
pg_background_13 1.3 el10.aarch64 pgdg 22.3 KiB pg_background_13-1.3-3PGDG.rhel10.aarch64.rpm
postgresql-13-pg-background 1.5 d12.x86_64 pigsty 40.6 KiB postgresql-13-pg-background_1.5-1PIGSTY~bookworm_amd64.deb
postgresql-13-pg-background 1.5 d12.aarch64 pigsty 39.8 KiB postgresql-13-pg-background_1.5-1PIGSTY~bookworm_arm64.deb
postgresql-13-pg-background 1.5 d13.x86_64 pigsty 40.6 KiB postgresql-13-pg-background_1.5-1PIGSTY~trixie_amd64.deb
postgresql-13-pg-background 1.5 d13.aarch64 pigsty 39.9 KiB postgresql-13-pg-background_1.5-1PIGSTY~trixie_arm64.deb
postgresql-13-pg-background 1.5 u22.x86_64 pigsty 48.4 KiB postgresql-13-pg-background_1.5-1PIGSTY~jammy_amd64.deb
postgresql-13-pg-background 1.5 u22.aarch64 pigsty 47.3 KiB postgresql-13-pg-background_1.5-1PIGSTY~jammy_arm64.deb
postgresql-13-pg-background 1.5 u24.x86_64 pigsty 42.5 KiB postgresql-13-pg-background_1.5-1PIGSTY~noble_amd64.deb
postgresql-13-pg-background 1.5 u24.aarch64 pigsty 41.9 KiB postgresql-13-pg-background_1.5-1PIGSTY~noble_arm64.deb

Source

Repository
github.com/vibhorkum/pg_background
 Source Tarball
pg_background-1.5.tar.gz
 
pig build pkg pg_background;		# build spec not ready

Install

Make sure PGDG and PIGSTY repo available:

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

Install this extension with pig:

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

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

Create this extension with:

CREATE EXTENSION pg_background;
Last updated on
pg_laterpostgis