Module postgres_checkpointer

PostgreSQL-backed checkpointer implementation with ACID guarantees.

This checkpointer stores agent state in a PostgreSQL database, providing:

• ACID transaction guarantees
• Persistent storage with backup capabilities
• SQL querying for analytics and debugging
• Multi-region replication support

Schema

The checkpointer automatically creates the following table:

CREATE TABLE IF NOT EXISTS agent_checkpoints (
    thread_id TEXT PRIMARY KEY,
    state JSONB NOT NULL,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

Structs

PostgresCheckpointer

PostgreSQL-backed checkpointer with connection pooling.

PostgresCheckpointerBuilder

Builder for configuring a PostgreSQL checkpointer.