PostgreSQL has hundreds of configuration settings that affect performance,
durability, and security. Misconfiguration can lead to:
- Data loss (fsync off, weak durability)
- Performance issues (logging too much)
- Security vulnerabilities (weak encryption)
PG Pilot monitors your configuration and alerts on issues.
What it monitors
- All PostgreSQL configuration settings
- Settings that differ from defaults
- Dangerous configuration combinations
- Installed extensions and versions
- Extension update availability
How to use
Navigate to the Configurations section from the main navigation.
Configuration Issues
The Issues tab shows problematic settings:
- Critical: Data safety risks (fsync off, autovacuum disabled)
- Warning: Performance or security concerns
- Notice: Recommendations for improvement
All Settings
Browse all PostgreSQL settings:
- Current value vs default
- Whether modified from default
- Setting category and context
Extensions
See installed extensions:
- Version information
- Update availability
- Category (performance, FDW, etc.)
Each issue links to detailed documentation explaining
the risk and remediation steps.