select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Time series

pg_background

Run SQL queries in the background

pgext.cloud · Source code · License text · Control file

Overview

Packagepg_background
Version2.0.2
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPGDG
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars254
Latest commit2026-08-29
Latest release2026-08-29
Catalogue updated2026-08-30

Related extensions

Required by

pg_dbms_lockExtension to add Oracle DBMS_LOCK full compatibility to PostgreSQL

See also

pg_taskexecute any sql command at any specific time at background
pg_durableSQL-native durable orchestrations for PostgreSQL
pg_laterRun queries now and get results later
pg_dispatchAsynchronous SQL dispatcher built on pg_cron
pg_retryRetry SQL statements on transient errors with exponential backoff
pglockLightweight distributed lock service inside PostgreSQL
pgmqA lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
ulakTransactional Outbox extension for PostgreSQL with reliable asynchronous delivery
omni_workerGeneralized worker pool
pg_cronJob scheduler for PostgreSQL