Error on postgresql

Installation RPM Installation
1

Hello!
As part of our implementation process, we cloned our staging database to a new production server, changed database users (eg: changed openiam to openiam_prd) and updated the configuration accordingly. When running the openiam services, the openiam-esb is stuck in a not running state with the following error:

org.postgresql.util.PSQLException: ERROR: permission denied for large object

Previously we encountered the same error but with different object id, and our dba team fixed it (it no longer logged the same error), and after fixing other problems, we see again the same message, but with a different object.

Any pointers to help us investigate?

Thanks in advance!

Cristhian

2

Hello @ccaballero646,

I will follow up on this. Are you still using 4.2.1.11?

3

Hello @ccaballero646,

Could you please provide the openiam-esb logs?

Thanks.

4

After the database cloning, who is owner of the database? openiam/openiam_prd?
You need the openiam_prd to have permissions on all large objects now.