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.