Issue with deploying PostgreSQL in local setup

I have used following link as reference to deploy PostgreSQL in local instance:

 https://academy.creatio.com/docs/user/setup_and_administration/on-site_deployment/database_server/deploy_postgresql_database_windows

 As mentioned in the link, I have created 2 user roles- sysadmin and public user profile(to set up connection to the restored db). whenever I use public user login in connection config file, I get an error: "42501:permission denied for table SysSettings".

However sysadmin credentials seem to work.  Kindly help in resolving the issue.

 

Like 0

Like

2 comments

Dear Gokul,

 

Thank you for your question!

 

Please be advised that this issue has been resolved within the support ticket submitted to us.

 

As discussed in the ticket, we recommend using the following link to deploy the PostgreSQL in the local instance:

 

https://academy.creatio.com/documents/administration/7-16/postgresql-da…

 

We appreciate your cooperation!

 

Thank you!

 

Regards,

 

Danyil

Danyil Onoprienko,

Thank you for providing solution. I was able to resolve the error.

Show all comments