[FOLIO-563] Allow PostgreSQL from AWS RDS to work Created: 18/Apr/17  Updated: 12/Nov/18  Resolved: 25/Apr/17

Status: Closed
Project: FOLIO
Components: None
Affects versions: None
Fix versions: None

Type: New Feature Priority: P3
Reporter: Hongwei Ji Assignee: Hongwei Ji
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: 1 hour, 40 minutes
Original estimate: Not Specified

Sprint:

 Description   

Using AWS PostgreSQL as Folio modules backend, when enabling a module a a tenant, see errors like below even though the user has rds-superuser role:

org.folio.rest.persist.PostgresClient SEVERE ERROR: must be member of role "<tenant>_<module>".

Modify template_delete_tenant.sql by adding following line can address this issue.
GRANT myuniversity_mymodule TO CURRENT_USER;

For convience, following pull requests have been created for various Folio modules.
https://github.com/folio-org/mod-users/pull/20
https://github.com/folio-org/mod-metadata/pull/11
https://github.com/folio-org/mod-auth/pull/17
https://github.com/folio-org/mod-auth/pull/18
https://github.com/folio-org/mod-loan-storage/pull/2
https://github.com/folio-org/mod-configuration/pull/13



 Comments   
Comment by Hongwei Ji [ 25/Apr/17 ]

Thanks for merging PRs. All modules work with AWS RDS PostgreSQL now.

Generated at Thu Feb 08 23:06:43 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.