Skip to content

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

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

58 results found

  1. As a developer or database administrator,
    I want to scale and distribute my PostgreSQL databases,
    so that I can handle large-scale data processing and analytics workloads efficiently.

    The Citus extension offers the benefits of scalability, improved performance, fault tolerance, high availability, efficient data distribution, and seamless integration with PostgreSQL, enables the users to effectively manage and process large-scale data workloads.

    50 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. As a database administrator or developer, I would like multi-region standby capability for my PostgreSQL and MySQL databases so that I can ensure high-availability and business continuity by maintaining standbys across different regions, enabling automatic promotion in the event of a region-wide outage.

    45 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. As Database administrator, with a large footprint of applications being served,
    I want to have a read only replica cluster in another region, that is sized appropriately, with it's own read replica nodes provisioned,
    so that I can fail over and that read replica can quickly handle the production workload in the scenario of a disaster in one region/cloud vendor, to minimise any disruption to service.

    39 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. As a developer,
    I want to connect to my Aiven for Postgres services without providing credentials and use only certificate authentication as offered by Postgres https://www.postgresql.org/docs/current/auth-cert.html
    so that I can be compliant with my internal security policies

    18 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. As a database administrator for a large enterprise,
    I want to be able to leverage an Aiven platform API,
    so that I can extract and archive, logical backups of my instances in order to meet and pass industry audit and compliance checks for data retention.
    These periods of retention could vary but be as long as 3 years. I would not expect to be able to restore these logical backups in the Aiven platform, and would be manage this myself should I need to.

    16 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. As a data privacy officer, database administrator, data analyst/researcher, or compliance officer, I would like the ability to anonymize sensitive data in the database by masking or replacing personally identifiable information (PII) or commercially sensitive data so that I can protect individuals' privacy and ensure compliance with data protection regulations such as HIPAA and GDPR.

    15 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. As a database administrator or developer,
    I would like to integrate LDAP authentication with PostgreSQL,
    So that user management becomes centralized through existing LDAP services like ActiveDirectory, enhancing security, simplifying authentication, and eliminating the need for separate authentication methods.

    15 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. As a database administrator or developer,
    I would like to perform a cascade power off operation on a database service with read replicas when a power off operation is initiated,
    so that the service hierarchy is navigated, starting with powering off the replicas and ending with the master, all in a single uninterrupted transaction.
    This feature aims to prevent customers from having to set up automatic schedulers on their environments, reducing resource waste and ensuring a seamless and efficient power off process for the database service.

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. As a site reliability engineer,
    I want to be able to create a highly available read-replica service,
    so that I can use it in the critical path of my application without availability being affected by loss of a single node.
    In addition, this can currently be achieved via at least two separate read-replica services (currently plans are limited to those with only one node) and appropriate client configuration, but Aiven should be able to do this for me instead.

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. As a database administrator or developer, I would like to perform in-place major upgrades on standby nodes and read-replicas for PostgreSQL so that the whole upgrade window is considerably shorter, resulting in increased high-availability for standbys and improved availability for read replicas. This feature will also alleviate any bottlenecks caused by the quorum sync replication, enhancing the overall database system's efficiency and resilience.

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. As a DBA
    I want to be able to click a button or call an API to initiate a primary -> secondary failover
    so that I can recover from an issue that Aiven isn't detecting, or so I can exercise my own availability tests.
    This should be available for all DB engines.

    Thank you

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. As a database administrator,
    I would like to be able to see the availability zone locations of the cloud region where my high-availability capable PostgreSQL or MySQL database cluster resides, and I would like to be able to initiate a manual high-availability takeover operation for that cluster,
    so that I can have improved visibility of the availability zones where my database cluster instances are located, and I would have more authority on promotion of read-replicas for the the purpose of troubleshooting performance issues and avoiding incidental issues on specific availability zones.

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. As a database administrator, developer or PO for Cloud Operations,
    I would like the pg_partman extension to be updated to version 5.0.0,
    so that I can keep my infrastructure compatible.

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. As a database administrator or developer, I would like to query and analyze large volumes of data efficiently in PostgreSQL as a column-oriented database so that I can achieve fast and parallelized analytics without extensive code changes, reducing processing time from weeks to minutes.

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. As a database administrator or developer,
    I would like to be able to lower the previously increased, safeguarded PostgreSQL settings,
    so that I would be able to optimize the performance of my service according to its current state.

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. As a developer or database administrator,
    I want to be able to create storage plans with a capacity up to 64 TB using persistent SSD storage,
    so that I can scale up my storage as I grow my business towards enterprise.

    7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. As a DBA
    I want to access the pg_monitor role
    so that I can integrate with my in-house monitoring solution
    In addition, this could be via aiven-extras or an advanced configuration if necessary

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. As a database administrator or developer, I would like to see PgBouncer logging.
    At minimal I should be able to see connection pool creation/deletion/changes and all outbound clients connected to which pool with source IPs.
    1. pgbouncer logs should be available by "avn service logs" and aiven console.
    2. pgbouncer logs should be available with rsyslog integration to 3rd parties.
    3. ideally logging level can be controlled by pg service config parameter pg.logerrorverbosity
    bonus: pgbouncer stats ingested into logging.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. As a devops
    I want to have the service startup time in the GET service endpoint
    so that I can know I a service has been UP or STOPPED since more than 7 days for example. For now I have to fetch the activity logs of the project, then look up for the service, then look for the right event (if the status of the service is UP then I'm looking for the "servicepoweron" event else the "servicepoweroff") but sometimes the service is UP for more than 1 year so I can't find the startup date of the…

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. Allowing WAL compression could be beneficial for several reasons: reduction of disk space usage, IO efficiency, faster replication, generally improving performance.

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
← Previous 1 3
  • Don't see your idea?