Query on SailPoint IIQ Login with Read-Only PostgreSQL Database in DR Setup

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

8.4 p1

Share all details about your problem, including any error messages you may have received.

Hi SailPoint Community,

We are currently setting up a DR (Disaster Recovery) environment using PostgreSQL as the database. At the moment, the database is in read-only mode.

Is it possible to log in to SailPoint IdentityIQ when the database is in read-only mode? If not, could you please suggest any recommended approach for handling DR scenarios in this setup?

2

Hi @satishbabu - I would not recommend trying to connect a live IIQ environment to a DR databse. Also any write actions in SailPoint would try to write to the database and would fail.

Please consult the Disaster Recovery Architecture in this guide for setting up a DR environment. You’ll need more than just another DB (i.e. load balancers, replicated servers, etc) for true DR prep

Also helpful:

https://community.sailpoint.com/t5/Technical-White-Papers/IdentityIQ-Secure-Deployment-Guide/ta-p/76559#toc-hId--680813931

https://community.sailpoint.com/t5/Services-Standard-Deployment/SailPoint-IdentityIQ-Disaster-Recovery-Failover-Guidebook-docx/ta-p/76797

Hope this helps