Aiven for PostgreSQL® how-tos
=============================

.. dropdown:: Getting started

    - :doc:`Create a managed Aiven for PostgreSQL® service </docs/platform/howto/create_new_service>`
    - :doc:`Connect to Aiven for PostgreSQL® </docs/products/postgresql/howto/list-code-samples>`
    - :doc:`Load sample data into Aiven for PostgreSQL® </docs/products/postgresql/howto/pagila>`

.. dropdown:: Connect to your service

    - :doc:`Connect with Go </docs/products/postgresql/howto/connect-go>`
    - :doc:`Connect with Java </docs/products/postgresql/howto/connect-java>`
    - :doc:`Connect with NodeJS </docs/products/postgresql/howto/connect-node>`
    - :doc:`Connect with PHP </docs/products/postgresql/howto/connect-php>`
    - :doc:`Connect with Python </docs/products/postgresql/howto/connect-python>`
    - :doc:`Connect with psql </docs/products/postgresql/howto/connect-psql>`
    - :doc:`Connect with pgAdmin </docs/products/postgresql/howto/connect-pgadmin>`
    - :doc:`Connect with Rivery </docs/products/postgresql/howto/connect-rivery>`
    - :doc:`Connect with Skyvia </docs/products/postgresql/howto/connect-skyvia>`
    - :doc:`Connect with Zapier </docs/products/postgresql/howto/connect-zapier>`

.. dropdown:: Database administration

    - :doc:`Create additional PostgreSQL® databases </docs/products/postgresql/howto/create-database>`
    - :doc:`Perform a PostgreSQL® major version upgrade </docs/products/postgresql/howto/upgrade>`
    - :doc:`Install or update an extension </docs/products/postgresql/howto/manage-extensions>`
    - :doc:`Create manual PostgreSQL® backups </docs/products/postgresql/howto/create-manual-backups>`
    - :doc:`Restore PostgreSQL® from a backup </docs/products/postgresql/howto/restore-backup>`
    - :doc:`Claim public schema ownership </docs/products/postgresql/howto/claim-public-schema-ownership>`
    - :doc:`Manage connection pooling </docs/products/postgresql/howto/manage-pool>`
    - :doc:`Access PgBouncer statistics </docs/products/postgresql/howto/pgbouncer-stats>`
    - :doc:`Use the PostgreSQL® dblink extension </docs/products/postgresql/howto/use-dblink-extension>`
    - :doc:`Use the PostgreSQL® pg_repack extension </docs/products/postgresql/howto/use-pg-repack-extension>`
    - :doc:`Enable JIT in PostgreSQL® </docs/products/postgresql/howto/enable-jit>`
    - :doc:`Identify PostgreSQL® slow queries </docs/products/postgresql/howto/identify-pg-slow-queries>`
    - :doc:`Detect and terminate long-running queries </docs/products/postgresql/howto/pg-long-running-queries>`
    - :doc:`Optimize PostgreSQL® slow queries </docs/products/postgresql/howto/optimize-pg-slow-queries>`
    - :doc:`Check and avoid transaction ID wraparound </docs/products/postgresql/howto/check-avoid-transaction-id-wraparound>`
    - :doc:`Prevent PostgreSQL® full disk issues </docs/products/postgresql/howto/prevent-full-disk>`
    - :doc:`Enable and use pgvector on Aiven for PostgreSQL® </docs/products/postgresql/howto/use-pgvector>`
    - :doc:`Check size of a database, a table or an index </docs/products/postgresql/howto/pg-object-size>`
    - :doc:`Restrict access to databases or tables in Aiven for PostgreSQL®". </docs/products/postgresql/howto/readonly-user>`

.. dropdown:: Migration

    - :doc:`Migrate to a different cloud provider or region </docs/products/postgresql/howto/migrate-cloud-region>`
    - :doc:`Migrate to Aiven for PostgreSQL® with aiven-db-migrate </docs/products/postgresql/howto/migrate-aiven-db-migrate>`
    - :doc:`Migrate to Aiven for PostgreSQL® with pg_dump and pg_restore </docs/products/postgresql/howto/migrate-pg-dump-restore>`
    - :doc:`Migrating to Aiven for PostgreSQL® using Bucardo </docs/products/postgresql/howto/migrate-using-bucardo>`
    - :doc:`Migrate between PostgreSQL® instances using aiven-db-migrate in Python </docs/products/postgresql/howto/run-aiven-db-migrate-python>`
    - :doc:`Migrate PostgreSQL® databases to Aiven using the console </docs/products/postgresql/howto/migrate-db-to-aiven-via-console>`

.. dropdown:: Replication

    - :doc:`Create and use read-only replicas </docs/products/postgresql/howto/create-read-replica>`
    - :doc:`Set up logical replication to Aiven for PostgreSQL® </docs/products/postgresql/howto/setup-logical-replication>`
    - :doc:`Enable logical replication on Amazon Aurora PostgreSQL® </docs/products/postgresql/howto/logical-replication-aws-aurora>`
    - :doc:`Enable logical replication on Amazon RDS PostgreSQL® </docs/products/postgresql/howto/logical-replication-aws-rds>`
    - :doc:`Enable logical replication on Google Cloud SQL </docs/products/postgresql/howto/logical-replication-gcp-cloudsql>`

.. dropdown:: Integration

    - :doc:`Monitor PostgreSQL metrics with Datadog </docs/products/postgresql/howto/monitor-database-with-datadog>`
    - :doc:`Monitor PostgreSQL metrics with Grafana® </docs/products/postgresql/howto/report-metrics-grafana>`
    - :doc:`Monitor PostgreSQL metrics with pgwatch2 </docs/products/postgresql/howto/monitor-with-pgwatch2>`
    - :doc:`Visualize data with Grafana® </docs/products/postgresql/howto/visualize-grafana>`
    - :doc:`Report and analyze with Google Looker Studio </docs/products/postgresql/howto/analyze-with-google-data-studio>`
    - :doc:`Integrate two PostgreSQL services </docs/products/postgresql/howto/datasource-integration>`

.. dropdown:: Cluster management

    - :doc:`Monitor a managed Aiven for PostgreSQL® service </docs/platform/howto/monitoring-services>`
    - :doc:`Resize a managed Aiven for PostgreSQL® service </docs/platform/howto/scale-services>`
    - :doc:`Schedule automatic maintenance updates </docs/platform/howto/prepare-for-high-load>`
    - :doc:`Upgrade a managed Aiven for PostgreSQL® service </docs/platform/howto/scale-services>`
    - :doc:`Tag a managed Aiven for PostgreSQL® service </docs/platform/howto/tag-resources>`
    - :doc:`Power-off and delete a managed Aiven for PostgreSQL® service </docs/platform/howto/pause-from-cli>`
    - :doc:`Migrate a managed Aiven for PostgreSQL® service </docs/platform/howto/migrate-services-cloud-region>`
    - :doc:`Fork a managed Aiven for PostgreSQL® service </docs/platform/howto/console-fork-service>`