跳转到主要内容

omni_httpd

HTTP server

omnigres : HTTP server

Overview

ID Extension Package Version Category License Language
2951 omni_httpd omnigres 0.4.11 FEAT Apache-2.0 C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d-- No Yes No Yes no no
Relationships
Schemas omni_httpd
Requires omni_types omni_http
Need By omni_rest omni_session
See Also pg_graphql pg_net pg_session_jwt http documentdb pgjwt pg_oidc_validator login_hook
Siblings omni omni_auth omni_aws omni_cloudevents omni_containers omni_credentials omni_email omni_http omni_httpc omni_id omni_json omni_kube omni_ledger omni_manifest omni_mimetypes omni_os omni_polyfill omni_python omni_regex omni_rest omni_schema omni_seq omni_service omni_session omni_sql omni_sqlite omni_test omni_txn omni_types omni_var omni_vfs omni_vfs_types_v1 omni_web omni_worker omni_xml omni_yaml

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT PIGSTY 0.4.11 18 17 16 15 14 omnigres omni_types, omni_http
RPM PIGSTY 20251108 18 17 16 15 14 omnigres_$v -
DEB PIGSTY 20251108 18 17 16 15 14 postgresql-$v-omnigres -
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64 PIGSTY 20251108 PIGSTY 20250120 PIGSTY 20250120 PIGSTY 20250120 PIGSTY 20250120
el8.aarch64 PIGSTY 20251108 PIGSTY 20250120 PIGSTY 20250120 PIGSTY 20250120 PIGSTY 20250120
el9.x86_64 PIGSTY 20251108 PIGSTY 20250507 PIGSTY 20250507 PIGSTY 20250507 PIGSTY 20250507
el9.aarch64 PIGSTY 20251108 PIGSTY 20250507 PIGSTY 20250507 PIGSTY 20250507 PIGSTY 20250507
el10.x86_64 PIGSTY 20251108 PIGSTY 20251108 PIGSTY 20251108 PIGSTY 20251108 PIGSTY 20251108
el10.aarch64 PIGSTY 20251108 PIGSTY 20251108 PIGSTY 20251108 PIGSTY 20251108 PIGSTY 20251108
d12.x86_64 PIGSTY 20251108 PIGSTY 20250120 PIGSTY 20250120 PIGSTY 20250120 PIGSTY 20250120
d12.aarch64 PIGSTY 20251108 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 20251108 PIGSTY 20250120 PIGSTY 20250120 PIGSTY 20250120 PIGSTY 20250120
u22.aarch64 PIGSTY 20251108 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
u26.x86_64 PIGSTY 20251108 PIGSTY 20251108 PIGSTY 20251108 PIGSTY 20251108 PIGSTY 20251108
u26.aarch64 PIGSTY 20251108 PIGSTY 20251108 PIGSTY 20251108 PIGSTY 20251108 PIGSTY 20251108

Source 

pig build pkg omnigres;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

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

Install this extension with pig:

pig install omnigres;		# install via package name, for the active PG version
pig install omni_httpd;		# install by extension name, for the current active PG version

pig install omni_httpd -v 18;   # install for PG 18
pig install omni_httpd -v 17;   # install for PG 17
pig install omni_httpd -v 16;   # install for PG 16
pig install omni_httpd -v 15;   # install for PG 15
pig install omni_httpd -v 14;   # install for PG 14

Create this extension with:

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