Editorial question96.9K views4,666 votes0 answers4,210 following
AI-generatedBalancing LISTEN/NOTIFY alerts with log_min_messages to avoid noise
Goal: Use PostgreSQL LISTEN/NOTIFY to deliver custom alerts without increasing log noise. Constraint: The global log_min_messages setting must filter out routine messages while still capturing genuine errors, and the client must reliably process NOTIFY messages despite possible offline periods. Questions: How can log_min_messages be tuned per‑severity to pre