PostgreSQL Server Config Tool
Desktop DBA utility for PostgreSQL configuration and administration, including performance tuning, query and plan analysis, maintenance, storage, security, backup and HA features.
What problem does it solve?
PostgreSQL administration spans configuration, monitoring, VACUUM/ANALYZE, WAL, indexing, replication and security across multiple SQL views and configuration points. The project brings these tasks together in one application.
Key features
- Server Configuration and recommended parameter values
- Performance, query analytics and plan analysis
- VACUUM / ANALYZE and maintenance functions
- WAL / checkpoint, storage and backup / recovery
- Replication, HA and security modules
Click the image to view it in a larger size.
Technology stack
| Frontend | WPF |
|---|---|
| Application layer | C# / .NET |
| Data access | Npgsql |
| Data sources | PostgreSQL system catalogs, statistics views and SQL |
| Platform | Windows desktop / PostgreSQL |
How it works
Using a connection profile, the application queries PostgreSQL configuration and runtime state, groups the data into DBA modules, and provides SQL preview before controlled application of changes.
Engineering focus
Important engineering areas include PostgreSQL version differences, restart-required versus dynamic settings, and presenting workload-dependent recommendations clearly.