64 results found
-
Support h3-pg as a PostgreSQL Extension
As a database administrator or developer, I would like to have H3 Hexagonal Hierarchical Geospatial Indexing System in PostgreSQL via h3-pg extension so that I can efficiently index and analyze geospatial data, including creating heatmaps and performing various spatial analyses, enhancing location-based decision-making for applications and services.
2 votes -
Serverless PostgreSQL and MySQL Databases
As a database administrator or developer, I would like to have serverless PostgreSQL and MySQL databases so that I can effortlessly scale my databases based on workload, ensure high availability, simplify deployment and integration, reduce operational overhead, and optimize costs.
2 votes -
Tiered Storage for PostgreSQL and MySQL Databases
As a database administrator or developer, I would like to have Tiered Storage for PostgreSQL and MySQL databases so that I can achieve cost-effectiveness for less frequently accessed data, ensure scalability, and efficiently manage data lifecycle.
1 vote -
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.12 votes -
Replicate the usage of Oracle Autonomous Transaction
As developer or DBA
I want to be able to reproduce the behavior of Oracle Autonomous Transaction inside Postgres.
so that I can create a different transaction that is not impacting the current one. Use case can be logging for example),
In addition, this can be achieved using DBLinks but it requires to put the password inside a plSQL function. To avoid that, Aiven could have a new parameter allowing local connections without password.2 votes -
In-Place Major Upgrades on Standbys and Read-Replicas for PostgreSQL
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 -
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.10 votes -
Support orafce as a PostgreSQL Extension
As a database administrator or developer, I would like to utilize the Orafce extension in PostgreSQL so that I can easily incorporate familiar database functions and packages from other systems, simplifying the migration process and ensuring compatibility with existing applications and data structures.
4 votes -
Support for scram
Aiven end customers and their security teams are asking for support for more modern authentication methods, mainly scram-sha256. Scram has been supported by Postgres since version 10. Introducing the support in Aiven platform would allow customers to enchance their database security.
5 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.
21 votes -
pgbouncer metrics prometheus endpoint support
As a DBA or SRE, I want to be able to monitor more pgbouncer metrics. Please add support of pgbouncer input plugin for telegraf to expose prometheus endpoint
https://github.com/influxdata/telegraf/tree/master/plugins/inputs/pgbouncer3 votes -
Initiate a high-availability takeover manually
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 -
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.40 votes -
Preserve Ownership for PostgreSQL Service Accounts in Terraform
As a user managing PostgreSQL service accounts through Terraform,
I want to ensure that enabling the replication option using your Terraform provider does not lead to the recreation of the service account.
This way, the service account can retain its ownership and privileges over database objects such as tables and functions, avoiding potential disruptions.
Additionally, maintaining ownership and privileges is crucial for seamless operation and consistency in our database management processes.1 vote -
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.15 votes -
Support tds_fdw as a PostgreSQL Extension
As a database administrator or developer, I would like to integrate PostgreSQL with external databases using the TDS protocol so that I can seamlessly access data in Microsoft SQL Server and Sybase 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 -
Support Hydra as a PostgreSQL Extension
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 -
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 -
Support Bingo as a PostgreSQL Extension
As a developer or chemical database administrator,
I would like to perform chemical substructure searches and similarity searches on molecules and reactions efficiently,
so that I can quickly retrieve relevant chemical data and improve the accuracy and speed of chemical searches within the PostgreSQL database.3 votes -
Utilizing Row Level Security (RLS) and the BYPASSRLS Attribute
As a security administrator or developer, I would like to utilize Row-Level Security (RLS) in PostgreSQL so that I can control data access at a granular level based on specific conditions, ensuring that users only see and modify the data they are authorized to access. Additionally, I want the ability to assign the BYPASSRLS attribute to trusted roles or users when necessary, allowing them to have unrestricted access to data while still maintaining overall security.
3 votes
- Don't see your idea?