Switch-VEPSQLInstanceInstantRecovery

Short Description

Performs switchover of a PostgreSQL instance published within an instant recovery session.

Product: Veeam Backup & Replication

Product Edition: Enterprise, Enterprise Plus, Veeam Universal License

Syntax

Switch-VEPSQLInstanceInstantRecovery [-Instance] <VEPSQLInstanceInstantRecovery> [<CommonParameters>]

Detailed Description

This cmdlet performs a manual switchover of a PostgreSQL instance published within an instant recovery session. You can perform a switchover after all database files are copied to the target server and the cache file is synchronized. Run the New-VEPSQLIRSwitchOverOptions cmdlet to define the switchover option settings. For more information on the switchover options, see the Switchover section of the Veeam Explorers User Guide.

Parameters

Parameters
Parameter	Description	Type	Required	Position	Accept Pipeline Input
Instance	Specifies a PostgreSQL instance. The cmdlet will switchover this instance. Accepts the `VEPSQLInstanceInstantRecovery` object. To get this object, run the `Get-VEPSQLInstanceInstantRecovery` cmdlet.	`VEPSQLInstanceInstantRecovery`	True	0	True (ByValue)

<CommonParameters>

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the About Common Parameters section of Microsoft Docs.

Examples

Starting Switchover of Published PostgreSQL Instance

This example shows how to perform a manual switchover of the rhel01:5433 instance.

$IRInstance = Get-VEPSQLInstanceInstantRecovery -InstanceName "rhel01:5433"

Switch-VEPSQLInstanceInstantRecovery -Instance $IRInstance

Perform the following steps:

Run the Get-VEPSQLInstanceInstantRecovery cmdlet. Specify the InstanceName parameter value. Save the result to the $IRInstance variable.
Run the Switch-VEPSQLInstanceInstantRecovery cmdlet. Set the $IRInstance variable as the Instance parameter value.

Get-VEPSQLInstanceInstantRecovery