Providing SUPERUSER access to the PostgreSQL databases.

ovh / public-cloud-roadmap

Agile roadmap for OVHcloud Public Cloud services. Discover the features our product teams are working on, comment and influence our backlog.

https://www.ovhcloud.com/en/public-cloud/

184 stars 5 forks source link

Providing SUPERUSER access to the PostgreSQL databases. #551

Open sachinnnaik opened 5 months ago

sachinnnaik commented 5 months ago

The user is requesting superuser access to the PostgreSQL database to perform activities such as terminating PIDs, changing custom passwords for users, and initiating a database VACUUM process.

Current status: As our Public Cloud Databases products are managed services, we do not provide superuser or root access for these types of products.

Future request: Can we implement SUPERUSER access for PostgreSQL databases created under the OVH Public Cloud Project in the future?

thild42 commented 5 months ago

Hello @sachinnnaik, and thank you for your feedback.

A subset of administration operations could be performed by the special avnadmin user.

to terminate queries, you could use SELECT pg_terminate_backend(pid);.
for user administration with CREATE USER/ROLE and DROP USER/ROLE plus permissions GRANT and REVOKE.
for vacuuming, you indeed cannot use directly the VACUUM statement, but you could configure the autovacuum behaviour using advanced parameters.

sachinnnaik commented 5 months ago

Hello @thild42,

Thank you so much for the provided information. Is that possible to restart the DB for the customer through OVH platform?

thild42 commented 5 months ago

Hello @sachinnnaik.

It is not possible to restart a service. This is a feature that is often request but usually for bad reasons.

What is it you want to achieve through a service restart ?

sachinnnaik commented 5 months ago

Hello @thild42

The restart task was a request from one of our customers. I am working with the customer and trying to get more details about it.

Thank you for your timely response.