Aiven for PostgreSQL® how-tos# Getting started Create a managed Aiven for PostgreSQL® service Connect to Aiven for PostgreSQL® Load sample data into Aiven for PostgreSQL® Connect to your service Connect with Go Connect with Java Connect with NodeJS Connect with PHP Connect with Python Connect with psql Connect with pgAdmin Connect with Rivery Connect with Skyvia Connect with Zapier 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 Create and use read-only replicas Set up logical replication to Aiven for PostgreSQL® Enable logical replication on Amazon Aurora PostgreSQL® Enable logical replication on Amazon RDS PostgreSQL® Enable logical replication on Google Cloud SQL Integration Monitor PostgreSQL metrics with Datadog Monitor PostgreSQL metrics with Grafana® Monitor PostgreSQL metrics with pgwatch2 Visualize data with Grafana® Report and analyze with Google Looker Studio Integrate two PostgreSQL services 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
