Skip to content

github.com/faustbrian/go-audit/postgres v1.0.0

Choose a tag to compare

@faustbrian faustbrian released this 26 Aug 06:13
· 48 commits to main since this release

1.0.0 - 2026-08-25

Documentation

  • Link the package README to the repository-wide Golib documentation portal.

Changed

  • Publish the module from its standalone github.com/faustbrian/go-audit/postgres identity while preserving its documented API and behavior.
  • Refresh local v0.0.0 owned-module checksums after dependency manifests and
    release notes were normalized; runtime behavior and public APIs are
    unchanged.

Added

  • Append-only PostgreSQL schema, least-privilege roles, deterministic indexes,
    idempotent atomic append, bounded cursor queries and streaming export.
  • Caller-owned transaction staging and separately privileged legal-hold-aware
    two-phase retention.
  • Digest-pinned PostgreSQL 14 through 18 compatibility, transactional migration
    interruption, backup/restore, connection-loss recovery, fault-classification,
    and leak exercises.
  • Security-definer idempotent append without ordinary-writer table read,
    update, or delete authority.
  • Forward-only hardening migration with canonical digest enforcement,
    acceptance-order snapshot pagination, deterministic retention ordering, and
    revocation of historical fixed-role privileges before deployment-owned role
    grants generated by PrivilegeSQL.
  • Batch-atomic transaction staging, immutable record-ID digest tombstones after
    retention, and exact canonical/schema validation at the security-definer
    append boundary, including the canonical UTC year range.
  • Migration-safe identity capture for protocol-compatible writers already in
    flight while the durability migration commits.
  • Atomic full-table legacy validation before the durability migration accepts
    and backfills existing history.
  • Preserve the published migration 1 and 2 checksums while migration 3 commits
    fixed-role neutralization, including stored-password removal, before
    migration 4 validates legacy history and installs the durable acceptance
    boundary.
  • Add a fresh-install preflight that atomically reserves fixed NOLOGIN roles,
    rejecting existing and concurrent name collisions before migration 1 can
    grant temporary access.
  • Pin the retention trigger's trusted search path so a retention writer cannot
    shadow its ordering and locking dependencies.
  • Bind fixed-role neutralization directly to the PostgreSQL catalog so a
    hostile migration search path cannot hide reserved-role memberships.
  • Enforce unique per-record retention acceptance order and reject ambiguous
    historical orders atomically during durability migration.
  • Reject non-UTF-8 databases before canonical validation or persistence can
    accept only an encoding-dependent subset of records.
  • Enforce the core closed authentication-method vocabulary during legacy
    validation and every new append so credential-shaped custom values cannot
    cross the persistence boundary.
  • Bound durability-migration lock acquisition at 30 seconds so active writers
    cause a visible deployment failure instead of an unbounded wait.
  • Atomic digest-bound evidence for each digest-pinned PostgreSQL 14 through 18
    matrix result.

Release integrity

  • Source commit: 314cd6a3dfb03c1575b77a13a11f9d3f9a787c01
  • Exact-head CI: https://github.com/faustbrian/go-audit/actions/runs/32916459832
  • Release dry-run: urn:sha256:8aeba455076d98bb2eef09edc3d5b147e334b76bfdfc85cc142d85cd7847404f
  • Assets include a CycloneDX SBOM, SLSA v1 in-toto provenance, and SSH-signed checksums.

Verify the checksum attestation with:

ssh-keygen -Y verify -f ALLOWED_SIGNERS -I brian@cline.sh -n golib-release -s SHA256SUMS.sig < SHA256SUMS