omni_httpd

Overview

Version

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:

• Install
• pig
• dnf
• apt

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_httpd CASCADE;  -- requires: omni_types, omni_http

Usage

omni_httpd: HTTP server

The omni_httpd extension is an embedded HTTP server for PostgreSQL, allowing HTTP request handling in SQL.

Define a Handler

CREATE FUNCTION my_handler(request omni_httpd.http_request)
    RETURNS omni_httpd.http_outcome
    RETURN omni_httpd.http_response(body => request.headers::text);

Register a Route

INSERT INTO omni_httpd.urlpattern_router (match, handler)
VALUES (omni_httpd.urlpattern('/headers'), 'my_handler'::regproc);

Configuration

• omni_httpd.http_workers – Number of HTTP workers (defaults to CPU count, respects max_worker_processes)
• omni_httpd.temp_dir – Temporary directory for sockets (defaults to /tmp)

Control

SELECT omni_httpd.stop();   -- Stop the server
SELECT omni_httpd.start();  -- Start the server
-- Pass immediate => true for immediate execution without waiting for transaction commit

Key Types

• omni_httpd.http_request – Request type with path, method, query_string, headers, body
• omni_httpd.http_response – Response constructor
• omni_httpd.http_outcome – Return type for handlers