How to avoid admin rights for PostgreSQL access?


I launched first time temporal platform on production. While doing this exercise I faced the following difficulty.

In the production environment I have specific user name for temporal which has access only to main db and visibility db. But I was not able to complete setup. After assigning admin role to the temporal user I was able to complete setup.

Question: Is it possible to avoid having admin role for temporal with postgresql?


There are two parts, setting up db schemas and then using the tables.

For the first part you would need to be able to set up schemas, would recommend using schema tools. After this is set up Temporal does need to do CRUD operations on created tables, check if that user has permissions to do that.

Thank you for this clarification. I will try to go deeper from auto-setup container.