Skip to main content

Aiven for PostgreSQL

Aiven is pocketPG's most complete provider integration. Most features work automatically once the connection is established.

Auto-detection​

Aiven instances are detected from the hostname (*.aivencloud.com). You can also set the provider explicitly in the provider configuration modal.

Cloud metrics​

When Aiven API credentials are configured (project name + API token), pocketPG pulls:

  • CPU usage
  • Memory usage
  • Disk usage

Metrics are displayed in the Cloud Metrics tab.

Host CPU count​

When available, Aiven service metadata helps pocketPG understand the underlying instance shape and produce more realistic recommendations.

Provider-aware tuning​

Aiven does not allow ALTER SYSTEM SET — it returns a permission error. pocketPG handles this:

  • Configurable parameters show a "Copy CLI" button with an avn service update command.
  • Service-managed parameters show a "Service Managed" badge.
  • Per-table ALTER TABLE DDL (fillfactor, autovacuum overrides) always works on Aiven.

Managed-provider checkpoint caveat​

Aiven's internal operations (archiving, backups, replication housekeeping) can increment checkpoints_req. The Health tab's checkpoint card includes a note about this on Aiven instances.