Database administration tasks
=============================

.. grid:: 1 2 2 2

    .. grid-item-card:: :doc:`Create additional PostgreSQL® databases </docs/products/postgresql/howto/create-database>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Perform a PostgreSQL® major version upgrade </docs/products/postgresql/howto/upgrade>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Install or update an extension </docs/products/postgresql/howto/manage-extensions>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Create manual PostgreSQL® backups </docs/products/postgresql/howto/create-manual-backups>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Restore PostgreSQL® from a backup </docs/products/postgresql/howto/restore-backup>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Claim public schema ownership </docs/products/postgresql/howto/claim-public-schema-ownership>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Manage connection pooling </docs/products/postgresql/howto/manage-pool>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Access PgBouncer statistics </docs/products/postgresql/howto/pgbouncer-stats>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Use the PostgreSQL® dblink extension </docs/products/postgresql/howto/use-dblink-extension>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Use the PostgreSQL® pg_repack extension </docs/products/postgresql/howto/use-pg-repack-extension>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Enable JIT in PostgreSQL® </docs/products/postgresql/howto/enable-jit>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Identify PostgreSQL® slow queries </docs/products/postgresql/howto/identify-pg-slow-queries>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Detect and terminate long-running queries </docs/products/postgresql/howto/pg-long-running-queries>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Optimize PostgreSQL® slow queries </docs/products/postgresql/howto/optimize-pg-slow-queries>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Check and avoid transaction ID wraparound </docs/products/postgresql/howto/check-avoid-transaction-id-wraparound>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Prevent PostgreSQL® full disk issues </docs/products/postgresql/howto/prevent-full-disk>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Enable and use pgvector on Aiven for PostgreSQL® </docs/products/postgresql/howto/use-pgvector>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Check size of a database, a table or an index </docs/products/postgresql/howto/pg-object-size>`
        :shadow: md
        :margin: 2 2 0 0

    .. grid-item-card:: :doc:`Restrict access to databases or tables in Aiven for PostgreSQL®". </docs/products/postgresql/howto/readonly-user>`
        :shadow: md
        :margin: 2 2 0 0