Databases

Indeed Identity PAM uses Microsoft SQL Server or PostgreSQL Pro to store data. The following components require databases:

  • IPAMCore — PAM Core component database is used to store Indeed Identity PAM privileged accounts, resources, permissions, and other service data
  • IPAMCoreJobs — PAM Core component database is used to store scheduled jobs
  • IPAMIdp — IdP component database is used to store authenticators of Indeed Identity PAM users and administrators
  • IPAMIdpJobs — 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


  1. Launch pgAdmin and connect to the PostgreSQL Pro server
  2. Open the context menu of the Databases item 
  3. Select Create, Database
  4. Specify a database name, for example: IPAMCore, IPAMCoreJobs, IPAMIdP, IPAMIdPJobs, ILS
  5. Click Save


Creating a service account to work with data storage


  1. Launch pgAdmin and connect to the PostgreSQL Pro server
  2. Open the context menu of the Login/Group Roles item
  3. Select Create, Login/Group Role
  4. Specify a Name, for example IPAMSQLServiceOps
  5. Go to Definition tab, enter the new password for account
  6. Go to Privileges tab, check Yes for Can Login? and Superuser? items
  7. Click Save, repeat for the rest of the databases.



The Superuser for PostgreSQL is required only for the first access to the database.