UUXO/dbbackup
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
80 Commits 1 Branch 0 Tags
main
Commit Graph

6 Commits

Author SHA1 Message Date
Renz
f5f302a11c Add authentication mismatch detection and pgpass support 
Phase 1: Detection & Guidance
- Detect OS user vs DB user mismatch
- Identify PostgreSQL authentication method (peer/ident/md5)
- Show helpful error messages with 4 solutions:
  1. sudo -u <user> (for peer auth)
  2. ~/.pgpass file (recommended)
  3. PGPASSWORD env variable
  4. --password flag

Phase 2: pgpass Support
- Auto-load passwords from ~/.pgpass file
- Support standard PostgreSQL pgpass format
- Check file permissions (must be 0600)
- Support wildcard matching (host:port:db:user:pass)

Tested on CentOS Stream 10 with PostgreSQL 16
 2025-11-07 14:43:34 +00:00
Renz
21f03b2d11 Fix pgx DSN for Unix socket connections 
- Use keyword format for Unix sockets (peer auth)
- Use URL format for TCP connections
- Fixes 'database tmp/postgres does not exist' error
- Fixes TLS connection errors on Unix sockets
- Properly handles localhost peer authentication
 2025-11-05 09:35:20 +00:00
Renz
84e4beee54 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
c352eb1f1b Fix MySQL connection handling: socket detection, timeouts, localhost vs remote 2025-10-25 10:33:29 +00:00
Renz
f014a20b10 Final debug pass 2025-10-24 19:03:06 +00:00
Renz
9b3c3f2b1b 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