PGMQ

Overview

PGMQ is a lightweight message queue built as a PostgreSQL extension. It does not require any external workers or other mechanisms outside of PostgreSQL itself and offers API compatibility with popular queues like AWS SQS and RSMQ (Redis Simple Message Queue). PGMQ guarantees exactly once delivery and supports message archiving for retention and replayability.

This Starter deploys PGMQ to Koyeb with one click. Keep in mind that this image does not offer persistent storage for data.

Configuration

The following environment variable is required when deploying this one-click:

• POSTGRES_PASSWORD: The password to set for the PostgreSQL instance.

Once the service is deployed, you can enable PGMQ by logging in with psql and creating the extension by typing:

CREATE EXTENSION pgmq;

You can then create a queue and begin to use it as outlined in the PGMQ documentation.

Connecting to PGMQ

To use the PGMQ instance, deploy any service that includes a PostgreSQL client to Koyeb in the same region. From the client, connect to the PGMQ instance through its private domain, which is visible on the service's overview page.