omni_aws

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_aws CASCADE;  -- requires: omni_httpc, pgcrypto, omni_xml, omni_web

Usage

omni_aws: Amazon Web Services APIs (S3)

The omni_aws extension provides S3-compatible API functions for PostgreSQL.

S3 API Functions

s3_create_bucket(bucket, region) – Creates an S3 bucket.

s3_list_objects_v2(bucket, path, continuation_token, delimiter, encoding_type, fetch_owner, max_keys, start_after, region) – Lists objects in a bucket with pagination support.

s3_put_object(bucket, path, payload, content_type, region) – Uploads an object. Default content type is application/octet-stream.

Execution

Single request:

SELECT * FROM omni_aws.aws_execute(
    access_key_id => 'AKID',
    secret_access_key => 'SECRET',
    request => omni_aws.s3_put_object('my-bucket', '/path/to/file', 'content'::bytea)
);

Batch requests: Pass requests as an array for efficient batch operations. Returns a table with an error column.

Pre-signed URLs

SELECT omni_aws.s3_presigned_url(
    bucket => 'my-bucket',
    path => '/my-file',
    access_key_id => 'AKID',
    secret_access_key => 'SECRET',
    expires => 604800,  -- 7 days (default)
    region => 'us-east-1'
);

Custom Endpoints

• DigitalOcean Spaces: digitalocean_s3_endpoint()
• Generic: s3_endpoint(url) with ${region} and ${bucket} variables for MinIO and similar providers