omni_cloudevents

CloudEvents support

Overview

Package	Version	Category	License	Language
`omnigres`	`0.1.0`	FEAT	Apache-2.0	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
2940	`omni`	No	Yes	Yes	Yes	No	No	`omni`
2941	`omni_auth`	No	No	No	Yes	No	No	`omni_auth`
2942	`omni_aws`	No	No	No	Yes	Yes	No	`omni_aws`
2943	`omni_cloudevents`	No	No	No	Yes	Yes	No	`omni_cloudevents`
2944	`omni_containers`	No	Yes	No	Yes	No	No	`omni_containers`
2945	`omni_credentials`	No	No	No	Yes	No	No	`omni_credentials`
2948	`omni_email`	No	No	No	Yes	No	No	`omni_email`
2949	`omni_http`	No	No	No	Yes	No	No	`omni_http`
2950	`omni_httpc`	No	Yes	No	Yes	No	No	`omni_httpc`
2951	`omni_httpd`	No	Yes	No	Yes	No	No	`omni_httpd`
2952	`omni_id`	No	Yes	No	Yes	No	Yes	-
2953	`omni_json`	No	No	No	Yes	Yes	No	`omni_json`
2954	`omni_kube`	No	Yes	No	Yes	No	No	`omni_kube`
2955	`omni_ledger`	No	Yes	No	Yes	No	No	`omni_ledger`
2956	`omni_manifest`	No	No	No	Yes	No	No	`omni_manifest`
2957	`omni_mimetypes`	No	No	No	Yes	No	No	`omni_mimetypes`
2958	`omni_os`	No	Yes	No	Yes	No	No	`omni_os`
2959	`omni_polyfill`	No	Yes	No	Yes	No	No	`omni_polyfill`
2960	`omni_python`	No	Yes	No	Yes	No	No	`omni_python`
2961	`omni_regex`	No	Yes	No	Yes	No	Yes	-
2962	`omni_rest`	No	No	No	Yes	No	No	`omni_rest`
2963	`omni_schema`	No	No	No	Yes	No	No	`omni_schema`
2964	`omni_seq`	No	Yes	No	Yes	No	No	`omni_seq`
2965	`omni_service`	No	No	No	Yes	No	No	`omni_service`
2966	`omni_session`	No	No	No	Yes	No	No	`omni_session`
2968	`omni_sql`	No	Yes	No	Yes	No	No	`omni_sql`
2969	`omni_sqlite`	No	Yes	No	Yes	No	No	`omni_sqlite`
2970	`omni_test`	No	No	No	Yes	No	No	`omni_test`
2971	`omni_txn`	No	Yes	No	Yes	No	No	`omni_txn`
2972	`omni_types`	No	Yes	No	Yes	No	No	`omni_types`
2973	`omni_var`	No	Yes	No	Yes	No	No	`omni_var`
2974	`omni_vfs`	No	Yes	No	Yes	No	No	`omni_vfs`
2975	`omni_vfs_types_v1`	No	No	No	Yes	No	No	`omni_vfs_types_v1`
2976	`omni_web`	No	Yes	No	Yes	No	No	`omni_web`
2977	`omni_worker`	No	Yes	No	Yes	No	No	`omni_worker`
2978	`omni_xml`	No	Yes	No	Yes	No	No	`omni_xml`
2979	`omni_yaml`	No	Yes	No	Yes	No	No	`omni_yaml`

Related	`omni_web`
Depended By	`omni_email` `omni_schema` `omni_test`

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	PIGSTY	`0.1.0`	1817161514	`omnigres`	`omni_web`
RPM	PIGSTY	`0.1.0`	1817161514	`omnigres_$v`	-
DEB	PIGSTY	`0.1.0`	1817161514	`postgresql-$v-omnigres`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY MISS	PIGSTY 20250120	PIGSTY 20250120	PIGSTY 20250120	PIGSTY 20250120
el8.aarch64	PIGSTY MISS	PIGSTY 20250120	PIGSTY 20250120	PIGSTY 20250120	PIGSTY 20250120
el9.x86_64	PIGSTY MISS	PIGSTY 20250507	PIGSTY 20250507	PIGSTY 20250507	PIGSTY 20250507
el9.aarch64	PIGSTY MISS	PIGSTY 20250507	PIGSTY 20250507	PIGSTY 20250507	PIGSTY 20250507
el10.x86_64	PIGSTY MISS	PIGSTY MISS	PIGSTY MISS	PIGSTY MISS	PIGSTY MISS
el10.aarch64	PIGSTY MISS	PIGSTY MISS	PIGSTY MISS	PIGSTY MISS	PIGSTY MISS
d12.x86_64	PIGSTY MISS	PIGSTY 20250120	PIGSTY 20250120	PIGSTY 20250120	PIGSTY 20250120
d12.aarch64	PIGSTY MISS	PIGSTY 20250120	PIGSTY 20250120	PIGSTY 20250120	PIGSTY 20250120
d13.x86_64	PIGSTY 20251108	PIGSTY 20251108	PIGSTY 20251108	PIGSTY 20251108	PIGSTY 20251108
d13.aarch64	PIGSTY 20251108	PIGSTY 20251108	PIGSTY 20251108	PIGSTY 20251108	PIGSTY 20251108
u22.x86_64	PIGSTY MISS	PIGSTY 20250120	PIGSTY 20250120	PIGSTY 20250120	PIGSTY 20250120
u22.aarch64	PIGSTY MISS	PIGSTY 20250120	PIGSTY 20250120	PIGSTY 20250120	PIGSTY 20250120
u24.x86_64	PIGSTY 20251108	PIGSTY 20251108	PIGSTY 20251108	PIGSTY 20251108	PIGSTY 20251108
u24.aarch64	PIGSTY 20251108	PIGSTY 20251108	PIGSTY 20251108	PIGSTY 20251108	PIGSTY 20251108

Build

You can build the RPM / DEB packages for omnigres using pig build:

pig build pkg omnigres         # build RPM / DEB packages

Install

You can install omnigres directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

pig install omnigres;          # Install for current active PG version

pig ext install -y omnigres -v 18  # PG 18
pig ext install -y omnigres -v 17  # PG 17
pig ext install -y omnigres -v 16  # PG 16
pig ext install -y omnigres -v 15  # PG 15
pig ext install -y omnigres -v 14  # PG 14

dnf install -y omnigres_18       # PG 18
dnf install -y omnigres_17       # PG 17
dnf install -y omnigres_16       # PG 16
dnf install -y omnigres_15       # PG 15
dnf install -y omnigres_14       # PG 14

apt install -y postgresql-18-omnigres   # PG 18
apt install -y postgresql-17-omnigres   # PG 17
apt install -y postgresql-16-omnigres   # PG 16
apt install -y postgresql-15-omnigres   # PG 15
apt install -y postgresql-14-omnigres   # PG 14

Create Extension:

CREATE EXTENSION omni_cloudevents CASCADE;  -- requires: omni_web

Usage

omni_cloudevents: CloudEvents support

The omni_cloudevents extension enables creation, validation, and publication of standardized CloudEvents from SQL. It is a templated extension.

Setup

SELECT omni_cloudevents.instantiate(schema => 'omni_cloudevents');
SET search_path TO omni_cloudevents, public;

Creating Events

SELECT cloudevent(
    id     => gen_random_uuid(),
    source => 'https://service.com/endpoint',
    type   => 'user.login'
);

Optional parameters: datacontenttype, dataschema, subject, ts (defaults to now), data (any PG type), specversion (default 1.0).

Publishing Events

SELECT publish(
    cloudevent(
        id     => gen_random_uuid(),
        source => 'https://api.yourservice.com/sys',
        type   => 'file.uploaded',
        data   => 'data-lake-bucket-123'::text
    )
);

Published events are persisted in the cloudevents_egress table.

NOTICE Publisher

SELECT omni_cloudevents.create_notice_publisher();
-- To observe uncommitted events:
SELECT omni_cloudevents.create_notice_publisher(publish_uncommitted => true);
-- Delete a publisher:
SELECT omni_cloudevents.delete_publisher(name);

Events generate JSON-formatted NOTICE messages with full event details.

Feedback

Was this page helpful?

Thanks for the feedback! Please let us know how we can improve.

Sorry to hear that. Please let us know how we can improve.

Last Modified 2026-03-12: add pg extension catalog (95749bf)