Back to browse
GitHub Repository

A postgres extension to avoid accidental mistakes

48 starsC

pg_savior: a seatbelt for Postgres – blocks accidental DELETE/UPDATE

by vira28·Apr 26, 2026·3 points·0 comments

AI Analysis

●●SolidSolve My ProblemNiche Gem

Parser hook blocks DELETE without WHERE before it wipes your production table.

Strengths
  • Hooks Postgres parser to raise ERROR and abort transaction before data loss occurs
  • Row-count threshold guard and blocks CREATE INDEX without CONCURRENTLY on large tables
  • Per-session bypass GUC allows emergency overrides without disabling globally
Weaknesses
  • Pre-1.0 not production-ready, similar guard tools already exist in Postgres ecosystem
  • Requires shared_preload_libraries and restart for cluster-wide protection
Target Audience

PostgreSQL DBAs, backend developers with production databases

Similar To

pg_guard · pg_stat_statements · PgBouncer

Similar Projects

Developer Tools●●●Banger

PgCortex – AI enrichment per Postgres row, zero transaction blocking

Outbox + external worker architecture solves a real production pain: LLM calls in Postgres triggers without blocking transactions.

Big BrainSolve My Problem
supreeth_ravi
104mo ago