Skip to content
← Aiven Ideas

Operational Databases

Join our forum to discuss your ideas with Aiven community or check out our public roadmap.

Operational Databases

Categories

JUMP TO ANOTHER FORUM

(thinking…)

I suggest you ...

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

5 results found

  1. Support pg_qualstats as a PostgreSQL Extension

    As a database administrator or developer,
    I desire the ability to receive automated suggestions for creating, deleting, and optimizing indexes.
    This capability would enable me to actively design and fine-tune indexes, enhancing query performance and facilitating efficient database performance tuning.

    16 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    Closed  ·  0 comments  ·  Aiven for PostgreSQL®  ·  Admin →

  2. Default privileged user for PG 15 connection pool

    Because of a change in Postgresql v15, user's no longer have access to the public schema by default. This means they can no longer create/modify objects by default. This is a breaking change because before you could create database pool for a specific user/db combo and expect that they would be able to access the objects in that database. I believe that Aiven should automatically grant permissions for a particular user on a particular database when there is a pool made for that user/db combo

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Aiven for PostgreSQL®  ·  Admin →
    Closed  ·  AdminSerhat Yanikoglu (Product Manager, Aiven.io) responded

    PostgreSQL 15 removes the global write privilege from the public schema. However, it is possible to provide the same level of collaboration to users, by making use of user schemas, and role-based access. Continuing the pre-PostgreSQL 15 practices on PostgreSQL 15 is discouraged.

  3. Support oracle_fdw as a PostgreSQL Extension

    As a database administrator or developer, I would like to integrate PostgreSQL with Oracle databases using the oracle_fdw extension so that I can seamlessly access data in Oracle databases from within PostgreSQL using standard SQL queries. This feature simplifies data integration and allows for efficient cross-database operations without the need for complex data migration processes.

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Aiven for PostgreSQL®  ·  Admin →

  4. Allow managing Postgres serviceuser privileges through API

    As a applicationplatform developer
    I want to create and manage postgres service users through the API
    so that I can provision a database and associated service user via the API

    This would allow us to create a database and a service user for an application, and grant privileges for only that database to that service user and forward the credentials to the application, which would then be able to connect and start using the database directly.

    We would avoid having to either share credentials for the avnadmin user, or having to write a separate tool to connect using avnadmin to…

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Aiven for PostgreSQL®  ·  Admin →

  5. Support Logical replication from an existing RDS-PostgreSQL to Aiven PostgreSQL

    Source: RDS-PostgreSQL
    Target: Aiven for PostgreSQL

    Current status: Logical replication not supported, only dump & restore is supported for RDS
    Need: Support logical replication to help smooth migration form RDS to Aiven PostgreSQL

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    Closed  ·  1 comment  ·  Aiven for PostgreSQL®  ·  Admin →
  • Don't see your idea?