pgmq
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
Module:
Categories:
Overview
PIGSTY 3rd Party Extension: pgmq
: A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
Information
- Extension ID: 2900
- Extension Name:
pgmq
- Package Name:
pgmq
- Category:
FEAT
- License: PostgreSQL
- Website: https://github.com/tembo-io/pgmq
- Language: SQL
- Extra Tags: N/A
- Comment: N/A
Metadata
- Latest Version: 1.5.0
- Postgres Support:
17
,16
,15
,14
,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION
DDL - Relocatable: Can be installed into other schemas
- Trusted: Trusted, Can be created by user with
CREATE
Privilege - Schemas:
pgmq
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pgmq_$v
- RPM Ver :
1.5.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pgmq
- DEB Ver :
1.5.0
- DEB Deps: N/A
Packages
OS | Arch | PG17 | PG16 | PG15 | PG14 | PG13 |
---|---|---|---|---|---|---|
el8 |
x86_64 |
pgmq_17 PIGSTY 1.5.0 |
pgmq_16 PIGSTY 1.5.0 |
pgmq_15 PIGSTY 1.5.0 |
pgmq_14 PIGSTY 1.5.0 |
pgmq_13 PIGSTY 1.5.0 |
el8 |
aarch64 |
pgmq_17 PIGSTY 1.5.0 |
pgmq_16 PIGSTY 1.5.0 |
pgmq_15 PIGSTY 1.5.0 |
pgmq_14 PIGSTY 1.5.0 |
pgmq_13 PIGSTY 1.5.0 |
el9 |
x86_64 |
pgmq_17 PIGSTY 1.5.0 |
pgmq_16 PIGSTY 1.5.0 |
pgmq_15 PIGSTY 1.5.0 |
pgmq_14 PIGSTY 1.5.0 |
pgmq_13 PIGSTY 1.5.0 |
el9 |
aarch64 |
pgmq_17 PIGSTY 1.5.0 |
pgmq_16 PIGSTY 1.5.0 |
pgmq_15 PIGSTY 1.5.0 |
pgmq_14 PIGSTY 1.5.0 |
pgmq_13 PIGSTY 1.5.0 |
d12 |
x86_64 |
postgresql-17-pgmq PIGSTY 1.5.0 |
postgresql-16-pgmq PIGSTY 1.5.0 |
postgresql-15-pgmq PIGSTY 1.5.0 |
postgresql-14-pgmq PIGSTY 1.5.0 |
postgresql-13-pgmq PIGSTY 1.5.0 |
d12 |
aarch64 |
postgresql-17-pgmq PIGSTY 1.5.0 |
postgresql-16-pgmq PIGSTY 1.5.0 |
postgresql-15-pgmq PIGSTY 1.5.0 |
postgresql-14-pgmq PIGSTY 1.5.0 |
postgresql-13-pgmq PIGSTY 1.5.0 |
u22 |
x86_64 |
postgresql-17-pgmq PIGSTY 1.5.0 |
postgresql-16-pgmq PIGSTY 1.5.0 |
postgresql-15-pgmq PIGSTY 1.5.0 |
postgresql-14-pgmq PIGSTY 1.5.0 |
postgresql-13-pgmq PIGSTY 1.5.0 |
u22 |
aarch64 |
postgresql-17-pgmq PIGSTY 1.5.0 |
postgresql-16-pgmq PIGSTY 1.5.0 |
postgresql-15-pgmq PIGSTY 1.5.0 |
postgresql-14-pgmq PIGSTY 1.5.0 |
postgresql-13-pgmq PIGSTY 1.5.0 |
u24 |
x86_64 |
postgresql-17-pgmq PIGSTY 1.5.0 |
postgresql-16-pgmq PIGSTY 1.5.0 |
postgresql-15-pgmq PIGSTY 1.5.0 |
postgresql-14-pgmq PIGSTY 1.5.0 |
postgresql-13-pgmq PIGSTY 1.5.0 |
u24 |
aarch64 |
postgresql-17-pgmq PIGSTY 1.5.0 |
postgresql-16-pgmq PIGSTY 1.5.0 |
postgresql-15-pgmq PIGSTY 1.5.0 |
postgresql-14-pgmq PIGSTY 1.5.0 |
postgresql-13-pgmq PIGSTY 1.5.0 |
Installation
Install pgmq
via the pig
CLI tool:
pig ext install pgmq
Install pgmq
via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgmq"]}' # -l <cls>
Install pgmq
RPM from YUM repo directly:
dnf install pgmq_17;
dnf install pgmq_16;
dnf install pgmq_15;
dnf install pgmq_14;
dnf install pgmq_13;
Install pgmq
DEB from APT repo directly:
apt install postgresql-17-pgmq;
apt install postgresql-16-pgmq;
apt install postgresql-15-pgmq;
apt install postgresql-14-pgmq;
apt install postgresql-13-pgmq;
Enable pgmq
extension on PostgreSQL cluster:
CREATE EXTENSION pgmq;
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.