Module
Description
Deploys a Cora Orchestration database package for PostgreSQL.
NOTE
Run this function to deploy Cora Orchestration PostgreSQL database only.
To deploy Cora Orchestration SQL server database, run the Install-CoraSeQuenceDatabase function.
Syntax
Install-CoraSeQuenceDatabaseLiquibaseChangeSets [-DatabasePackagePath] <String> [-Server] <String> [-Port] <Int32>
[-Database] <String> [-DBCredentials] <PSCredential> [-InstallType] <String> [-DatabaseType] <String>
[[-LiquibaseLogLevel] <String>] [<CommonParameters>]Parameters
-DatabasePackagePath <String>
The path to the database package.
| Required? | true |
| Position? | 1 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-Server <String>
The name of the PostgreSQL server used for hosting the database.
Should follow standard format, and include instance name and port.
| Required? | true |
| Position? | 2 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-Port <Int32>
Determines the port number.
| Required? | true |
| Position? | 3 |
| Default value | 0 |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-Database <String>
Determines the name of the deployed Postgres database.
| Required? | true |
| Position? | 4 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-DBCredentials <PSCredential>
The credentials to be used to connect to the database server, if needed. If not provided, the current user credentials are used with Windows Authentication.
| Required? | true |
| Position? | 5 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-InstallType [<String>]
Determines if this is an upgrade or installation of a new database. Value can be either NewDatabase or Upgrade.
- NewDatabase: Drops the existing database and creates a new database.
- Upgrade: Upgrades the existing database.
| Required? | true |
| Position? | 6 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-DatabaseType [<String>]
Determines the target database type.
| Required? | true |
| Position? | 7 |
| Default value | |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
-LiquibaseLogLevel <String>
Outputs different log information from liquibase.
For more information, see https://docs.liquibase.com/commands/config-ref/loglevel.html.
| Required? | false |
| Position? | 8 |
| Default value | OFF |
| Accept pipeline input? | false |
| Accept wildcard characters? | false |
<CommonParameters>
This function supports these common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, OutBuffer, PipelineVariable, and OutVariable.
For more information, see about_CommonParameters.
Example
PS C:\>Install-CoraSeQuencePostgresDatabase -DatabasePackagePath "C:\liquibase-10.0.0.35.zip" -Server localhost
-Port 5432 -Database MyDatabase -InstallType NewDatabase -DatabaseType Postgres -DBCredentials (Get-Credential)
-LiquibaseLogLevel INFO
