PostgreSQL

Reference backend with transactional application work and push notifications.

PostgreSQL is headgate’s reference backend. Its admission query evaluates policy, claims rows, and writes leases atomically. It also provides inspection, application transactions, and LISTEN/NOTIFY wakeups.

Rust

let store = std::sync::Arc::new(
    headgate_postgres::PgStore::connect("postgres://localhost/headgate", 16)?
);

Production notes

• Size the application-owned pool for handlers, API traffic, duties, and transactions.
• Notification connections are separate from ordinary query capacity.
• PgBouncer transaction pooling cannot preserve session-level notifications; polling remains supported.
• Schema qualification and multi-instance isolation are explicit.

Connection budgets

Multiple installations