I am working on packaging postgrest and this application makes use of custom created roles in postgres to implement its functionality.
I have the app up and running but when I try to create a role from psql I get ERROR: permission denied to create role.
I tried looking through the cloudron gitlab to see if I could find any examples of another app that already does this but I didn't see any.
It seems like this nodejs app is what cloudron uses to interact with the postgresql instance it offers as a service when provisioning new databases for apps.
This function specifically seems to be used when provisioning a new database for an app and it creates the role of the postgresql user that is created for the app being setup but doesn't seem to provide options for setting up additional roles that the application might need.
I tried to search for create role across all the code in the cloudron gitlab and it doesn't appear to support searching for things in code unless you filter down to a specific project first so if there are other apps already that do this I am not sure how to find them using gitlab search.
I also tried to use google search with site:git.cloudron.io create role but it looks like google is not indexing the content of that gitlab site which seems to be what is desired as the robots.txt has disallow: /.
Is there a method for getting whatever additional roles are needed setup during the application install so that permissions can stay the same but any custom roles that are needed can be setup by cloudron for the app to function?