Genpact Cora Knowledge Center

Support

PowerShell Function: Install-CoraSeQuenceDatabaseLiquibaseChangeSets

Module

CoraSeQuence.Database

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