Indeed Identity PAM uses Microsoft SQL Server or PostgreSQL Pro to store data. The following components require databases:
Core — Indeed Identity PAM Core component database is used to store Indeed Identity PAM privileged accounts, resources, permissions, and other service data
CoreJobs — Indeed Identity PAM Core component database is used to store scheduled jobs
Idp — IdP component database is used to store authenticators of Indeed Identity PAM users and administrators
IdpJobs — IdP component database is used to store scheduled jobs
ILS — Log Server component database is used to store the Indeed Identity PAM events
Database Creation
LaunchpgAdminand connect to the PostgreSQL Pro server
Open the context menu of the Databases item
SelectCreate,Database
Specify a database name, for example:Core, CoreJobs, IdP, IdPJobs, ILS
ClickSave
Creating a Service Account to Work with Data Storage
LaunchpgAdminand connect to the PostgreSQL Pro server
Open the context menu of theLogin/Group Rolesitem
Select Create,Login/Group Role
Specify aName, for example IPAMSQLServiceOps
Go to Definitiontab, enter the new password for account
Go to Privilegestab, checkYesforCan Login?andSuperuser?items
ClickSave, repeat for the rest of the databases.
TheSuperuserfor PostgreSQL is required only for the first access to the database.