Additional commands for database creation

The following PowerShell commands are provided for reference and may be helpful while creating or updating the IMS database:

  • DBPort. The PostgreSQL port to use during installation if it's not the default port (5432). The PgBouncer port (6432) in the config file cannot be used to create a fresh database, so this setting uses the default port (5432). If the PostgreSQL port is different, then use this parameter during installation (only for a new database). For example:

    `.\Execute-DBMigrator.ps1 -CoreJsonConfigFilePath [Core Service json file path] -DBPwd [Database user password] -DBPort [Postgresql port] `

  • IgnoreDBPreValidation. Append this parameter to the command to skip the installation pre-validation check. By default, this checks for the required DB server port. For example:

    `.\Execute-DBMigrator.ps1 -CoreJsonConfigFilePath [Core Service json file path] -DBPwd [Database user password] -IgnoreDBPreValidation`

    Skipping this check is not recommended.

  • IgnoreIMSDB. Append this parameter to the command to skip the IMS DB creation or upgrade. For example:

    `.\Execute-DBMigrator.ps1 -CoreJsonConfigFilePath [Core Service json file path] -DBPwd [Database user password] -IgnoreIMSDB`

    Disabling the IMS DB creation or upgrade is not recommended.

  • IgnoreReadingsDB. Append this parameter to the command to skip the Readings DB creation or upgrade. For example:

    `.\Execute-DBMigrator.ps1 -CoreJsonConfigFilePath [Core Service json file path] -DBPwd [Database user password] -IgnoreReadingsDB`

    Disabling the Readings DB creation or upgrade is not recommended.