Stop-VEPSQLInstancePublish

Short Description

Unpublishes PostgreSQL instances from the target server.

Applies to

Veeam Backup & Replication

Product Edition: Community, Enterprise, Enterprise Plus, Veeam Universal License

Syntax

Stop-VEPSQLInstancePublish [-InstancePublish] <VEPSQLInstancePublish> [-Force]  [<CommonParameters>]

Detailed Description

This cmdlet unpublishes PostgreSQL instances from the target server.

Parameters

Parameter

Description

Type

Required

Position

Accept Pipeline Input

InstancePublish

Specifies the PostgreSQL instance publish process. The cmdlet will stop the process and unpublish the instance from the target PostgreSQL server.

Accepts the VEPSQLInstancePublish object. To get this object, run the Get-VEPSQLInstancePublish cmdlet.

True

0

True

Force

Defines that the cmdlet will show no prompt before executing the command.

SwitchParameter

False

Named

False

<CommonParameters>

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

Example

This example shows how to unpublish a PostgreSQL instance.

$session = Get-VEPSQLRestoreSession

$instance = Get-VEPSQLInstance -Session $session[0] -DataDirectory /var/lib/pgsql/13/data

$publish = Get-VEPSQLInstancePublish -InstanceName $instance

Stop-VEPSQLInstancePublish -InstancePublish $publish

Perform the following steps:

  1. Run the Get-VEPSQLRestoreSession cmdlet. Save the result to the $session variable.

The Get-VEPSQLRestoreSession cmdlet will return an array of restore sessions. Mind the ordinal number of the necessary restore session. In our example, it is the first restore session in the array.

  1. Run the Get-VEPSQLInstance cmdlet. Set the $session variable as the Session parameter value. Specify the DataDirectory parameter value. Save the result to the $instance variable.
  2. Run the Get-VEPSQLInstancePublish cmdlet. Set the $instance variable as the InstanceName parameter value. Save the result to the $publish variable.
  3. Run the Stop-VEPSQLInstancePublish cmdlet. Set the $publish variable as the InstancePublish parameter value.

Related Commands