Extensions
pg_task

pg_task

pg_task : execute any sql command at any specific time at background

Overview

ID Extension Package Version Category License Language
1080
pg_task
pg_task
 1.0.0
TIME
MIT
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--sL---
No
Yes
Yes
No
no
no
Relationships
See Also
timescaledb
pg_cron
pg_later
pg_background
pg_partman
timescaledb_toolkit
timeseries
periods

breaks on many systems

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 1.0.0
18
17
16
15
14
 pg_task -
RPM
PGDG
 2.1.7
18
17
16
15
14
 pg_task_$v -
DEB
PIGSTY
 2.1.12
18
17
16
15
14
 postgresql-$v-pg-task -
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
el8.aarch64
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
el9.x86_64
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
el9.aarch64
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
el10.x86_64
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
el10.aarch64
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
PGDG 2.1.7
d12.x86_64
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
d12.aarch64
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
d13.x86_64
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
d13.aarch64
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
u22.x86_64
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
u22.aarch64
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
u24.x86_64
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
u24.aarch64
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
PIGSTY 2.1.12
Package Version OS ORG SIZE File URL
pg_task_18 2.1.7 el8.x86_64 pgdg 72.4 KiB pg_task_18-2.1.7-3PGDG.rhel8.x86_64.rpm
pg_task_18 2.1.7 el8.aarch64 pgdg 63.3 KiB pg_task_18-2.1.7-3PGDG.rhel8.aarch64.rpm
pg_task_18 2.1.7 el9.x86_64 pgdg 63.5 KiB pg_task_18-2.1.7-3PGDG.rhel9.x86_64.rpm
pg_task_18 2.1.7 el9.aarch64 pgdg 54.5 KiB pg_task_18-2.1.7-3PGDG.rhel9.aarch64.rpm
pg_task_18 2.1.7 el10.x86_64 pgdg 59.7 KiB pg_task_18-2.1.7-3PGDG.rhel10.x86_64.rpm
pg_task_18 2.1.7 el10.aarch64 pgdg 56.3 KiB pg_task_18-2.1.7-3PGDG.rhel10.aarch64.rpm
postgresql-18-pg-task 2.1.12 d12.x86_64 pigsty 192.2 KiB postgresql-18-pg-task_2.1.12-1PIGSTY~bookworm_amd64.deb
postgresql-18-pg-task 2.1.12 d12.aarch64 pigsty 182.8 KiB postgresql-18-pg-task_2.1.12-1PIGSTY~bookworm_arm64.deb
postgresql-18-pg-task 2.1.12 d13.x86_64 pigsty 191.6 KiB postgresql-18-pg-task_2.1.12-1PIGSTY~trixie_amd64.deb
postgresql-18-pg-task 2.1.12 d13.aarch64 pigsty 184.7 KiB postgresql-18-pg-task_2.1.12-1PIGSTY~trixie_arm64.deb
postgresql-18-pg-task 2.1.12 u22.x86_64 pigsty 201.0 KiB postgresql-18-pg-task_2.1.12-1PIGSTY~jammy_amd64.deb
postgresql-18-pg-task 2.1.12 u22.aarch64 pigsty 190.4 KiB postgresql-18-pg-task_2.1.12-1PIGSTY~jammy_arm64.deb
postgresql-18-pg-task 2.1.12 u24.x86_64 pigsty 193.1 KiB postgresql-18-pg-task_2.1.12-1PIGSTY~noble_amd64.deb
postgresql-18-pg-task 2.1.12 u24.aarch64 pigsty 183.7 KiB postgresql-18-pg-task_2.1.12-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_task_17 2.1.7 el8.x86_64 pgdg 72.5 KiB pg_task_17-2.1.7-1PGDG.rhel8.x86_64.rpm
pg_task_17 2.1.7 el8.aarch64 pgdg 63.4 KiB pg_task_17-2.1.7-1PGDG.rhel8.aarch64.rpm
pg_task_17 2.1.7 el9.x86_64 pgdg 63.3 KiB pg_task_17-2.1.7-1PGDG.rhel9.x86_64.rpm
pg_task_17 2.1.7 el9.aarch64 pgdg 54.4 KiB pg_task_17-2.1.7-1PGDG.rhel9.aarch64.rpm
pg_task_17 2.1.7 el10.x86_64 pgdg 59.6 KiB pg_task_17-2.1.7-3PGDG.rhel10.x86_64.rpm
pg_task_17 2.1.7 el10.aarch64 pgdg 56.2 KiB pg_task_17-2.1.7-3PGDG.rhel10.aarch64.rpm
postgresql-17-pg-task 2.1.12 d12.x86_64 pigsty 192.8 KiB postgresql-17-pg-task_2.1.12-1PIGSTY~bookworm_amd64.deb
postgresql-17-pg-task 2.1.12 d12.aarch64 pigsty 183.6 KiB postgresql-17-pg-task_2.1.12-1PIGSTY~bookworm_arm64.deb
postgresql-17-pg-task 2.1.12 d13.x86_64 pigsty 192.0 KiB postgresql-17-pg-task_2.1.12-1PIGSTY~trixie_amd64.deb
postgresql-17-pg-task 2.1.12 d13.aarch64 pigsty 185.4 KiB postgresql-17-pg-task_2.1.12-1PIGSTY~trixie_arm64.deb
postgresql-17-pg-task 2.1.12 u22.x86_64 pigsty 229.8 KiB postgresql-17-pg-task_2.1.12-1PIGSTY~jammy_amd64.deb
postgresql-17-pg-task 2.1.12 u22.aarch64 pigsty 219.4 KiB postgresql-17-pg-task_2.1.12-1PIGSTY~jammy_arm64.deb
postgresql-17-pg-task 2.1.12 u24.x86_64 pigsty 193.9 KiB postgresql-17-pg-task_2.1.12-1PIGSTY~noble_amd64.deb
postgresql-17-pg-task 2.1.12 u24.aarch64 pigsty 184.0 KiB postgresql-17-pg-task_2.1.12-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_task_16 2.1.7 el8.x86_64 pgdg 72.3 KiB pg_task_16-2.1.7-1PGDG.rhel8.x86_64.rpm
pg_task_16 2.1.5 el8.x86_64 pgdg 72.2 KiB pg_task_16-2.1.5-1PGDG.rhel8.x86_64.rpm
pg_task_16 2.1.7 el8.aarch64 pgdg 63.1 KiB pg_task_16-2.1.7-1PGDG.rhel8.aarch64.rpm
pg_task_16 2.1.5 el8.aarch64 pgdg 63.0 KiB pg_task_16-2.1.5-1PGDG.rhel8.aarch64.rpm
pg_task_16 2.1.7 el9.x86_64 pgdg 62.8 KiB pg_task_16-2.1.7-1PGDG.rhel9.x86_64.rpm
pg_task_16 2.1.5 el9.x86_64 pgdg 62.8 KiB pg_task_16-2.1.5-1PGDG.rhel9.x86_64.rpm
pg_task_16 2.1.7 el9.aarch64 pgdg 53.8 KiB pg_task_16-2.1.7-1PGDG.rhel9.aarch64.rpm
pg_task_16 2.1.5 el9.aarch64 pgdg 53.7 KiB pg_task_16-2.1.5-1PGDG.rhel9.aarch64.rpm
pg_task_16 2.1.7 el10.x86_64 pgdg 58.8 KiB pg_task_16-2.1.7-3PGDG.rhel10.x86_64.rpm
pg_task_16 2.1.7 el10.aarch64 pgdg 55.0 KiB pg_task_16-2.1.7-3PGDG.rhel10.aarch64.rpm
postgresql-16-pg-task 2.1.12 d12.x86_64 pigsty 192.4 KiB postgresql-16-pg-task_2.1.12-1PIGSTY~bookworm_amd64.deb
postgresql-16-pg-task 2.1.12 d12.aarch64 pigsty 183.5 KiB postgresql-16-pg-task_2.1.12-1PIGSTY~bookworm_arm64.deb
postgresql-16-pg-task 2.1.12 d13.x86_64 pigsty 191.6 KiB postgresql-16-pg-task_2.1.12-1PIGSTY~trixie_amd64.deb
postgresql-16-pg-task 2.1.12 d13.aarch64 pigsty 184.8 KiB postgresql-16-pg-task_2.1.12-1PIGSTY~trixie_arm64.deb
postgresql-16-pg-task 2.1.12 u22.x86_64 pigsty 226.9 KiB postgresql-16-pg-task_2.1.12-1PIGSTY~jammy_amd64.deb
postgresql-16-pg-task 2.1.12 u22.aarch64 pigsty 216.6 KiB postgresql-16-pg-task_2.1.12-1PIGSTY~jammy_arm64.deb
postgresql-16-pg-task 2.1.12 u24.x86_64 pigsty 193.1 KiB postgresql-16-pg-task_2.1.12-1PIGSTY~noble_amd64.deb
postgresql-16-pg-task 2.1.12 u24.aarch64 pigsty 183.2 KiB postgresql-16-pg-task_2.1.12-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_task_15 2.1.7 el8.x86_64 pgdg 73.3 KiB pg_task_15-2.1.7-1PGDG.rhel8.x86_64.rpm
pg_task_15 2.1.5 el8.x86_64 pgdg 73.2 KiB pg_task_15-2.1.5-1PGDG.rhel8.x86_64.rpm
pg_task_15 2.1.7 el8.aarch64 pgdg 64.0 KiB pg_task_15-2.1.7-1PGDG.rhel8.aarch64.rpm
pg_task_15 2.1.5 el8.aarch64 pgdg 63.9 KiB pg_task_15-2.1.5-1PGDG.rhel8.aarch64.rpm
pg_task_15 2.1.7 el9.x86_64 pgdg 75.3 KiB pg_task_15-2.1.7-1PGDG.rhel9.x86_64.rpm
pg_task_15 2.1.5 el9.x86_64 pgdg 75.2 KiB pg_task_15-2.1.5-1PGDG.rhel9.x86_64.rpm
pg_task_15 2.1.7 el9.aarch64 pgdg 68.3 KiB pg_task_15-2.1.7-1PGDG.rhel9.aarch64.rpm
pg_task_15 2.1.5 el9.aarch64 pgdg 68.2 KiB pg_task_15-2.1.5-1PGDG.rhel9.aarch64.rpm
pg_task_15 2.1.7 el10.x86_64 pgdg 72.3 KiB pg_task_15-2.1.7-3PGDG.rhel10.x86_64.rpm
pg_task_15 2.1.7 el10.aarch64 pgdg 69.5 KiB pg_task_15-2.1.7-3PGDG.rhel10.aarch64.rpm
postgresql-15-pg-task 2.1.12 d12.x86_64 pigsty 193.0 KiB postgresql-15-pg-task_2.1.12-1PIGSTY~bookworm_amd64.deb
postgresql-15-pg-task 2.1.12 d12.aarch64 pigsty 183.3 KiB postgresql-15-pg-task_2.1.12-1PIGSTY~bookworm_arm64.deb
postgresql-15-pg-task 2.1.12 d13.x86_64 pigsty 192.1 KiB postgresql-15-pg-task_2.1.12-1PIGSTY~trixie_amd64.deb
postgresql-15-pg-task 2.1.12 d13.aarch64 pigsty 184.7 KiB postgresql-15-pg-task_2.1.12-1PIGSTY~trixie_arm64.deb
postgresql-15-pg-task 2.1.12 u22.x86_64 pigsty 236.4 KiB postgresql-15-pg-task_2.1.12-1PIGSTY~jammy_amd64.deb
postgresql-15-pg-task 2.1.12 u22.aarch64 pigsty 229.2 KiB postgresql-15-pg-task_2.1.12-1PIGSTY~jammy_arm64.deb
postgresql-15-pg-task 2.1.12 u24.x86_64 pigsty 202.5 KiB postgresql-15-pg-task_2.1.12-1PIGSTY~noble_amd64.deb
postgresql-15-pg-task 2.1.12 u24.aarch64 pigsty 195.6 KiB postgresql-15-pg-task_2.1.12-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_task_14 2.1.7 el8.x86_64 pgdg 73.0 KiB pg_task_14-2.1.7-1PGDG.rhel8.x86_64.rpm
pg_task_14 2.1.5 el8.x86_64 pgdg 72.9 KiB pg_task_14-2.1.5-1PGDG.rhel8.x86_64.rpm
pg_task_14 2.1.7 el8.aarch64 pgdg 63.8 KiB pg_task_14-2.1.7-1PGDG.rhel8.aarch64.rpm
pg_task_14 2.1.5 el8.aarch64 pgdg 63.7 KiB pg_task_14-2.1.5-1PGDG.rhel8.aarch64.rpm
pg_task_14 2.1.7 el9.x86_64 pgdg 74.9 KiB pg_task_14-2.1.7-1PGDG.rhel9.x86_64.rpm
pg_task_14 2.1.5 el9.x86_64 pgdg 74.9 KiB pg_task_14-2.1.5-1PGDG.rhel9.x86_64.rpm
pg_task_14 2.1.7 el9.aarch64 pgdg 68.2 KiB pg_task_14-2.1.7-1PGDG.rhel9.aarch64.rpm
pg_task_14 2.1.5 el9.aarch64 pgdg 68.1 KiB pg_task_14-2.1.5-1PGDG.rhel9.aarch64.rpm
pg_task_14 2.1.7 el10.x86_64 pgdg 72.1 KiB pg_task_14-2.1.7-3PGDG.rhel10.x86_64.rpm
pg_task_14 2.1.7 el10.aarch64 pgdg 69.4 KiB pg_task_14-2.1.7-3PGDG.rhel10.aarch64.rpm
postgresql-14-pg-task 2.1.12 d12.x86_64 pigsty 192.6 KiB postgresql-14-pg-task_2.1.12-1PIGSTY~bookworm_amd64.deb
postgresql-14-pg-task 2.1.12 d12.aarch64 pigsty 182.7 KiB postgresql-14-pg-task_2.1.12-1PIGSTY~bookworm_arm64.deb
postgresql-14-pg-task 2.1.12 d13.x86_64 pigsty 191.8 KiB postgresql-14-pg-task_2.1.12-1PIGSTY~trixie_amd64.deb
postgresql-14-pg-task 2.1.12 d13.aarch64 pigsty 183.9 KiB postgresql-14-pg-task_2.1.12-1PIGSTY~trixie_arm64.deb
postgresql-14-pg-task 2.1.12 u22.x86_64 pigsty 232.1 KiB postgresql-14-pg-task_2.1.12-1PIGSTY~jammy_amd64.deb
postgresql-14-pg-task 2.1.12 u22.aarch64 pigsty 224.7 KiB postgresql-14-pg-task_2.1.12-1PIGSTY~jammy_arm64.deb
postgresql-14-pg-task 2.1.12 u24.x86_64 pigsty 201.8 KiB postgresql-14-pg-task_2.1.12-1PIGSTY~noble_amd64.deb
postgresql-14-pg-task 2.1.12 u24.aarch64 pigsty 195.2 KiB postgresql-14-pg-task_2.1.12-1PIGSTY~noble_arm64.deb

Source

Repository
github.com/RekGRpth/pg_task
 Source Tarball
pg_task-1.0.0.tar.gz
 
pig build pkg pg_task;		# build 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 pg_task;		# install via package name, for the active PG version

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

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'pg_task';

This extension does not need CREATE EXTENSION DDL command

Last updated on
pg_cronpg_later