Aiven for PostgreSQL® how-tos
Getting started
Connect to your service
Database administration
- Create additional PostgreSQL® databases
- Perform a PostgreSQL® major version upgrade
- Install or update an extension
- Create manual PostgreSQL® backups
- Restore PostgreSQL® from a backup
- Claim public schema ownership
- Manage connection pooling
- Access PgBouncer statistics
- Use the PostgreSQL® dblink extension
- Use the PostgreSQL® pg_repack extension
- Enable JIT in PostgreSQL®
- Identify PostgreSQL® slow queries
- Detect and terminate long-running queries
- Optimize PostgreSQL® slow queries
- Check and avoid transaction ID wraparound
- Prevent PostgreSQL® full disk issues
- Enable and use pgvector on Aiven for PostgreSQL®
- Check size of a database, a table or an index
- Restrict access to databases or tables in Aiven for PostgreSQL®".
Migration
- Migrate to a different cloud provider or region
- Migrate to Aiven for PostgreSQL® with aiven-db-migrate
- Migrate to Aiven for PostgreSQL® with pg_dump and pg_restore
- Migrating to Aiven for PostgreSQL® using Bucardo
- Migrate between PostgreSQL® instances using aiven-db-migrate in Python
- Migrate PostgreSQL® databases to Aiven using the console
Replication
Integration
Cluster management
- Monitor a managed Aiven for PostgreSQL® service
- Resize a managed Aiven for PostgreSQL® service
- Schedule automatic maintenance updates
- Upgrade a managed Aiven for PostgreSQL® service
- Tag a managed Aiven for PostgreSQL® service
- Power off and delete a managed Aiven for PostgreSQL® service
- Migrate a managed Aiven for PostgreSQL® service
- Fork a managed Aiven for PostgreSQL® service