Provider configuration
pocketPG can detect your cloud provider automatically from the connection hostname, or you can set it explicitly in the provider configuration modal.
Supported providers
| Provider | Auto-detection | Cloud metrics | Tuning awareness |
|---|---|---|---|
| Aiven | *.aivencloud.com | CPU, memory, disk via Aiven API | avn service update CLI instead of ALTER SYSTEM SET |
| Amazon RDS | *.rds.amazonaws.com | Planned | Managed-provider checkpoint caveat |
| Amazon Aurora | *.rds.amazonaws.com | Planned | Managed-AWS behavior with Aurora-specific notes |
| Azure | *.postgres.database.azure.com | Planned | Managed-provider checkpoint caveat |
| Google Cloud SQL | *.cloudsql.google.com | Planned | Managed-provider checkpoint caveat |
| Self-managed | No detection needed | N/A | Full ALTER SYSTEM SET support |
What provider configuration enables
Cloud metrics
When provider credentials are configured, pocketPG can pull CPU, memory, and disk metrics from the provider API. Aiven is currently the most complete integration.
Instance shape
Cloud provider APIs can expose instance shape details that make recommendations more realistic than PostgreSQL settings alone.
Provider-aware tuning
On Aiven, global PostgreSQL configuration changes must go through Aiven service configuration instead of ALTER SYSTEM SET. pocketPG detects this and shows provider-appropriate copy commands where possible. Parameters that the provider manages internally are marked as service-managed.
Per-table ALTER TABLE DDL (fillfactor, autovacuum scale factors) works on all providers, including Aiven. Only global ALTER SYSTEM SET is restricted on managed services.
Managed-provider checkpoint caveat
On managed PostgreSQL services, checkpoints_req can increment from provider-internal housekeeping (backups, archiving, replication). pocketPG's checkpoint card appends a note on managed providers advising you to verify the WAL rate before acting on checkpoint-frequency recommendations.