-
Notifications
You must be signed in to change notification settings - Fork 981
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
Schema creation failed with permission error in preparedDatabases #1130
Comments
Which operator version do you use? 1.5.0 or latest? Schemas are created by the db owner which has the privileges to do so. Maybe you can check also Posrgres logs for more errors. That would help us. Not sure if having the same name for schema and database can lead to troubles. |
Hi, We are using the operator version: Regarding the same name for schema and database - We are able to create it successfully for the In conclusion, it allows to create only one schema one and database using preparedDatabses. The above example i tried by providing the different schema name and database name , is failing with permission denied error in creating the schema Please check |
Will take a few days to look into though. 1 database works? 2 fails? |
Hi Jan, Yes only the first input for database and schema is created. Thanks |
Hi, Problem was: defer should not be used in for loops.
|
Hi @sdudoladov , is there a release planned soon which includes this fix? I'm hitting the same problem on 1.5.0 |
Hello! I'm having this same issue. Which 1.5.0 image version should we use? |
Hi team,
We are trying to create multiple databases using the 'preparedDatabases'.
There is no issue while creating only 1 database and schema. But the issue occurs when we start adding the second database& schema and more.
With the below configuration, the first database & schema passed is created successfully, but the second and other databases and schema creates error.
Below is the configuration of the "cluster values.yaml"
The database is getting created but the schema creation failed with permission error:
The above log shows , the "a3s" schema is created successfully but the "a3sschema" schema creation failed with permission error.
Could you please suggest how do we create multiple databases using "preparedDatabases"
Thanks
The text was updated successfully, but these errors were encountered: