Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Using external PostgreSQL should not require superuser rights #17513

Closed
tolusha opened this issue Jul 29, 2020 · 1 comment
Closed

Using external PostgreSQL should not require superuser rights #17513

tolusha opened this issue Jul 29, 2020 · 1 comment
Labels
area/che-server area/install Issues related to installation, including offline/air gap and initial setup kind/enhancement A feature request - must adhere to the feature request template. lifecycle/stale Denotes an issue or PR has remained open with no activity and has become stale. severity/P2 Has a minor but important impact to the usage or development of the system.

Comments

@tolusha
Copy link
Contributor

tolusha commented Jul 29, 2020

Is your enhancement related to a problem? Please describe.

This PRs [1] [2] allows to use external DB with Che.
Unfortunately che database user is required superuser rights for instance to create extension [3]
This is might not be acceptable in some cases.

Describe the solution you'd like

Figure out if this extension is needed and if is not then remove its creation.

Describe alternatives you've considered

If extension is still needed

  • remove its creation anyway from che-server side
  • document as additional requirements for external DB usage
  • move its creation to operator for non-external DB case

Additional context

#17274

[1] eclipse-che/che-docs#1430
[2] eclipse-che/che-operator#371
[3] https://github.com/eclipse/che/blob/master/wsmaster/che-core-sql-schema/src/main/resources/che-schema/5.11.0/postgresql/1__optimize_user_search.sql

@tolusha tolusha added the kind/enhancement A feature request - must adhere to the feature request template. label Jul 29, 2020
@che-bot che-bot added the status/need-triage An issue that needs to be prioritized by the curator responsible for the triage. See https://github. label Jul 29, 2020
@benoitf benoitf added severity/P2 Has a minor but important impact to the usage or development of the system. area/install Issues related to installation, including offline/air gap and initial setup area/che-server and removed status/need-triage An issue that needs to be prioritized by the curator responsible for the triage. See https://github. labels Jul 29, 2020
@che-bot
Copy link
Contributor

che-bot commented Feb 4, 2021

Issues go stale after 180 days of inactivity. lifecycle/stale issues rot after an additional 7 days of inactivity and eventually close.

Mark the issue as fresh with /remove-lifecycle stale in a new comment.

If this issue is safe to close now please do so.

Moderators: Add lifecycle/frozen label to avoid stale mode.

@che-bot che-bot added the lifecycle/stale Denotes an issue or PR has remained open with no activity and has become stale. label Feb 4, 2021
@che-bot che-bot closed this as completed Feb 24, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/che-server area/install Issues related to installation, including offline/air gap and initial setup kind/enhancement A feature request - must adhere to the feature request template. lifecycle/stale Denotes an issue or PR has remained open with no activity and has become stale. severity/P2 Has a minor but important impact to the usage or development of the system.
Projects
None yet
Development

No branches or pull requests

3 participants