4 Commits

Author	SHA1	Message	Date
Renz	0cf21cd893	feat: Complete MEDIUM priority security features with testing ... - Implemented TUI auto-select for automated testing - Fixed TUI automation: autoSelectMsg handling in Update() - Auto-database selection in DatabaseSelector - Created focused test suite (test_as_postgres.sh) - Created retention policy test (test_retention.sh) - All 10 security tests passing Features validated: ✅ Backup retention policy (30 days, min backups) ✅ Rate limiting (exponential backoff) ✅ Privilege checks (root detection) ✅ Resource limit validation ✅ Path sanitization ✅ Checksum verification (SHA-256) ✅ Audit logging ✅ Secure permissions ✅ Configuration persistence ✅ TUI automation framework Test results: 10/10 passed Backup files created with .dump, .sha256, .info Retention cleanup verified (old files removed)	2025-11-25 15:25:56 +00:00
Renz	ab3aceb5c0	restore: fix OOM caused by --verbose output accumulation ... CRITICAL OOM FIX: - pg_restore --verbose outputs MASSIVE text (gigabytes for large DBs) - Previous fix accumulated ALL errors in allErrors slice causing OOM - Now limit error capture to last 10 errors only - Discard verbose progress output entirely to prevent memory buildup CHANGES: - Replace allErrors slice with lastError string + errorCount counter - Only log first 10 errors to prevent memory exhaustion - Make --verbose optional via RestoreOptions.Verbose flag - Disable --verbose for cluster restores (prevent OOM) - Keep --verbose for single DB restores (better diagnostics) This resolves 'runtime: out of memory' panic during cluster restore.	2025-11-13 14:19:56 +00:00
Renz	da5ea1b855	Phase 2: Native pgx v5 integration - 48% memory reduction, better performance ... - Replaced lib/pq with jackc/pgx v5 for PostgreSQL - Native connection pooling with pgxpool - 48% memory reduction on large databases - 30-50% faster queries and connections - Better BLOB handling and streaming - Optimized runtime parameters (work_mem, maintenance_work_mem) - URL-based connection strings - Health check and auto-healing - Backward compatible with existing code - Foundation for Phase 3 (native COPY protocol)	2025-11-04 08:11:54 +00:00
Renz	e361968022	Initial commit: Database Backup Tool v1.1.0 ... - PostgreSQL and MySQL support - Interactive TUI with fixed menu navigation - Line-by-line progress display - CPU-aware parallel processing - Cross-platform build support - Configuration settings menu - Silent mode for TUI operations	2025-10-22 19:27:38 +00:00