64 results found
-
Display the service startup/shutdown time in the GET service endpoint
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 -
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 -
Admin can initiate failovers
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
10 votes -
Configurable random_page_cost parameter in PostgreSQL Settings
As a customer,
I want to be able to configurerandom_page_cost
and optionallyseq_page_cost
in Postgres advanced configurations in order to influence the query planner.4 votes -
Bktree_spgist
As db admin
I want to add bktree extension for Postgres
so that I can do a similarity search based on hamming distance
In addition, this extension also includes the SP-GiST.Please see the following repository:
https://github.com/fake-name/pg-spgist_hamming1 vote -
Support Postgres Event Triggers
As developer
I want to create event triggers
so that I can react to DDL changes across the entire database.Aiven for Postgres currently does not support Event Triggers: https://www.postgresql.org/docs/16/event-triggers.html
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.16 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.
11 votes -
Display a warning when updating parameters that cannot be lowered once increased
There are parameters like the 'maxworkerprocesses' that cannot be lowered once it's been enabled and increased with the warning message: "PostgreSQL setting 'maxworkerprocesses' cannot be lowered from its current value". It would be nice to be warned prior to toggling and increasing these settings.
1 vote -
Kerberos Authentication Support for PostgreSQL
As a database administrator or developer,
I would like to integrate Kerberos authentication with PostgreSQL,
So that user management becomes centralized through existing Kerberos services like ActiveDirectory, enhancing security, simplifying authentication, and eliminating the need for separate authentication methods.3 votes -
Support for wal_compression in PostgreSQL services
Allowing WAL compression could be beneficial for several reasons: reduction of disk space usage, IO efficiency, faster replication, generally improving performance.
6 votes -
Expose PgBouncer max_prepared_statements in the Advanced Configuration
As Database Administrator or Engineer,
I want to be able to edit the PgBouncer maxpreparedstatements configuration parameter, as it has a direct impact in the latency of the consumers of the database through the pool.Also, the default setting of 100 max prepared statements that Aiven has in the system is incorrect and will cause issues with ORM users when they upgrade the pgbouncer version in Aiven.
https://github.com/prisma/prisma/issues/21531#issuecomment-1794539086
6 votes -
pgoutput
As a dba
I want to add the PGOUTPUT extension
so that we can use this type of logical replication
In addition, it is important as our system integration requires it to work, and it is generally better performing over test_decoding1 vote -
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.10 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 -
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 -
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/pgbouncer10 votes -
Support PLV8 on versions of Postgres greater than 10
As Software Developer
I want to use PLV8 on Postgres 16
so that I can use Javascript as a procedural language on my PG 16 service.2 votes -
Make PostgreSQL Upgrade Logs Available Post Upgrade Failure
As a database administrator or developer,
I would like to access the service upgrade logs after a failed and reverted upgrade,
so that I would be able to troubleshoot the problem myself before retrying, and without requiring the assistance of the support team.3 votes -
Change the default SSL Mode
Make it possible to change the default SSL mode.
This way, by setting this value to "verify-full", we can make it so that anyone trying to connect to the database MUST have the CA certificate.Because currently, what's the point of the CA certificate if it is not mandatory?
2 votes
- Don't see your idea?