caddypostgresql

Caddy Storage PostgresQL

[!WARNING] This project is still a work in progress. Do not use in production.

A storage implementation for Caddy that uses PostgreSQL as the backend.

• ✅ Supports all Caddy storage operations
• ✅ Directories semantics fully implemented (e.g. listing objects in a directory)
• ✅ Supports storage export (recursive listing of all files)
• ✅ Works in distributed Caddy setups thanks to distributed locking with fencing tokens (pglock)
• ✅ Fully tested (integration tests + smoke tests and real export test)

How to use

Build the module into your Caddy binary:

xcaddy build --with github.com/dmarcwise/caddy-storage-postgresql

Configure Caddy to use the PostgreSQL storage module. Example Caddyfile:

{
    storage postgresql {
        dsn "postgres://user:password@localhost:5432/caddy?sslmode=disable"
    }
}

The dsn parameter is a PostgreSQL connection string, either as a key/value string or as a connection URI.

The sslmode connection parameter defaults to require. We recommend setting a statement_timeout (e.g. 30s) and other basic parameters.

This module implementation already sets the following connection pooling parameters: maximum open connection (10), maximum idle connections (3), and connection maximum idle time (1h).