141 results found
-
Support Citus as a PostgreSQL Extension
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.
60 votes -
Multi-Region Standby Capability with Automatic Promotion for Relational Databases
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.
47 votes -
PostgreSQL Audit Logging Capability
As a database administrator or developer, I would like to have audit logging capability in the system so that I can track and monitor user activities, maintain data security, and ensure compliance with regulatory requirements.
42 votes -
Support FerretDB as a MongoDB alternative
As a developer looking for an open-source alternative to MongoDB,
I want to use FerretDB to translate MongoDB wire protocol queries to SQL,
so that I can stop using proprietary MongoDB instances.42 votes -
Failover ready scaled read replica
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.41 votes -
Support postgresql_anomymizer as a PostgreSQL Extension
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.
31 votes -
Datadog Database Monitoring Explain Insights for PostgreSQL
As a database admin or a developer,
I would like the explain parameterized queries are enabled and the user agent's search path is configured to include all schemas in the Datadog agent configuration,
so that I would be able to fully utilize the Explain Insights module of the Datadog Database Monitoring feature with my PostgreSQL databases.22 votes -
JSON data type support
As a developer using Aiven for Valkey,
I would like to have support for the JSON data type,
so that I can store, update, and retrieve JSON values in an Aiven for Valkey database, similar to any other data types.21 votes -
Active Active Cross region replication - Valkey
As a devops engineer/admin,
I want to run both read/write request to the Valkey clusters that locates closest geographically region
So that I can reduce the latency and improve the experience of my end-user20 votes -
Support Certificate Authentication on Postgres
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 policies18 votes -
Logs in JSON format
As an Operations Engineer
I want to have logs in JSON format
so that I can process them in third-party log management and analytics systems without having to write custom parsing rules.Related PostgreSQL documentation: https://www.postgresql.org/docs/15/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-JSONLOG
17 votes -
Backup extraction capability
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.17 votes -
LDAP Authentication Support for PostgreSQL
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.16 votes -
pgbouncer logging
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.14 votes -
Support High Availability Read-Replica Services
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.13 votes -
Cascade Power Off for Database Services with Read Replicas
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.13 votes -
Almost zero downtime major release upgrades with logical replication
Based on a similar mechanism with aivendbmigrate I would like to have major release upgrade mechanism based on logical replication.
Steps:
- create an empty target instance with new major release
- create a full logical replication setup (like aivendbmigrate does) 2.1. inform users about limitations (lobs, schema changes during that period etc.) 2.2. inform users about testing and rollback capabilities
- perform the usual migrate thing with transferring everything and switch to a CDC state until next steps are defined
- provide specific cutover scenarios 4.1. DNS switch if possible? 4.2. some pgbouncer magic to prevent forced reconnections of…
12 votes -
Enable Configuration of log_parameter_max_length and log_parameter_max_length_on_error
As a Database Administrator,
I want to have the ability to configure the PostgreSQL parameters
log_parameter_max_lengthandlog_parameter_max_length_on_errorwithin Aiven's platform,so that I can prevent sensitive data from being exposed in database logs, especially during the logging of slow queries.
In addition, enabling this configuration is crucial for maintaining compliance with data protection regulations and upholding the privacy standards expected.
12 votes -
Support pg_jsonschema as a PostgreSQL Extension
As a Software Engineer or DBA, I want to be able to enforce schemas on JSON/JSONB fields in a convenient manner, so that I can ensure bad data doesn't getting written to my database. https://github.com/supabase/pg_jsonschema seems to be the most popular extension for doing this.
12 votes -
Tiered Storage on Valkey
As an devops engineers
I want to store extensive amount of data on Valkey but only need part of them to be on memory
so that I can still utilize the low-latency nature of Valkey but also be able to retain as much data as I can without pay the cost for unnecessary memory.
In addition, i also want to be able to move data around different tiers12 votes
- Don't see your idea?