Start-VEPSQLInstancePublish

Short Description

Publishes a backed-up PostgreSQL instance.

Applies to

Veeam Backup & Replication

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

Syntax

This cmdlet provides parameter sets that allow you to:

Publish a PostgreSQL instance to a Linux-based PostgreSQL machine.

Start-VEPSQLInstancePublish [-Instance] <VEPSQLInstance> [[-ToPointInTimeUTC] <DateTime>] [-LinuxCredentials <VEPSQLLinuxCredential>] [-ServerName <String>] [-SshPort <Int32>] [-Force] [-Port <Int32>] [<CommonParameters>]

Publish a PostgreSQL instance to a Windows-based PostgreSQL machine.

Start-VEPSQLInstancePublish [-Instance] <VEPSQLInstance> [[-ToPointInTimeUTC] <DateTime>] [-WindowsCredentials <PSCredential>] [-ServerName <String>] [-Force] [-Port <Int32>] [<CommonParameters>]

Detailed Description

This cmdlet publishes a backed-up PostgreSQL instance.

Parameters

Parameters
Parameter	Description	Type	Required	Position	Accept Pipeline Input
Instance	Specifies a PostgreSQL instance that the cmdlet will publish.	Accepts the VEPSQLInstance object. To get this object, run the Get-VEPSQLInstance cmdlet.	True	0	True (ByValue)
ToPointInTimeUTC	Specifies a point in time in the UTC format within the restore interval of the PostgreSQL instance. The cmdlet will publish the instance to the state of the specified point in time.	DateTime	False	1	False
LinuxCredentials	Specifies Linux credentials that the cmdlet will use to connect to the Linux machine.	Accepts the VEPSQLLinuxCredential object. To get this object, run the New-VEPSQLLinuxCredential cmdlet.	False	Named	True (ByValue)
WindowsCredentials	Specifies Windows credentials that the cmdlet will use to connect to the Windows machine.	Accepts the PSCredential object. To get this object, run theGet-Credential cmdlet.	False	Named	True (ByValue)
ServerName	Specifies DNS name or IP address of the target PostgreSQL server. The cmdlet will publish a PostgreSQL instance to that server.	String	False	Named	False
SshPort	Specifies the SSH port number. The cmdlet will use this port to connect to the Linux machine. Default: 22	Int32	False	Named	False
Force	Defines that the cmdlet will replace the target PostgreSQL instance with the instance from the backup. Note: The cmdlet will show no prompt before executing the command.	SwitchParameter	False	Named	False
Port	Specifies the port to connect to the published PostgreSQL instance.	Int32	False	Named	False

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

Output Object

The cmdlet returns the VEPSQLInstancePublish[] array that contains information about the publishing process for the PostgreSQL instance.

Example

Example 1. Publishing PostgreSQL Instance to Linux Machine

This example shows how to publish a backed-up PostgreSQL instance to a Linux machine with PostgreSQL.

$session = Get-VEPSQLRestoreSession

$instance = Get-VEPSQLInstance -Session $session[0]

$securepassword = Read-Host -Prompt "Enter password" -AsSecureString

$linuxcreds = New-VEPSQLLinuxCredential -Account "root" -Password $securepassword

Start-VEPSQLInstancePublish -Instance $instance -LinuxCredentials $linuxcreds

Perform the following steps:

Get the restore session:

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

The cmdlet will return an array of active restore sessions. Note the ordinal number of the necessary restore session. In this example, it is the first restore session in the array.

Run the Get-VEPSQLInstance cmdlet. Set the $session variable as the Session parameter value. Save the result to the $instance variable.

Get Linux credentials:

Run the Read-Host cmdlet. Specify the Prompt parameter value. Provide the AsSecureString parameter. Save the result to the $securepassword variable.
Run the New-VEPSQLLinuxCredential cmdlet. Specify the Account parameter value. Set the $securepassword variable as the Password parameter value.

Run the Start-VEPSQLInstancePublish cmdlet. Specify the following settings:

Set the $instance variable as the Instance parameter value.
Set the $linuxcreds variable as the LinuxCredentials parameter value.

Example 2. Publishing PostgreSQL Instance to Windows Machine

This example shows how to publish a backed-up PostgreSQL instance to a Windows machine with PostgreSQL.

$session = Get-VEPSQLRestoreSession

$instance = Get-VEPSQLInstance -Session $session[0]

$windowscreds = Get-Credential

Start-VEPSQLInstancePublish -Instance $instance -WindowsCredentials $windowscreds

Perform the following steps:

Get the restore session:

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

The cmdlet will return an array of active restore sessions. Note the ordinal number of the necessary restore session. In this example, it is the first restore session in the array.

Run the Get-VEPSQLInstance cmdlet. Set the $session variable as the Session parameter value. Save the result to the $instance variable.

Run the Get-Credential cmdlet to create a credential object. Enter credentials that will be used for authenticating to the target PostgreSQL machine. Save the result to the $credential variable.

Run the Start-VEPSQLInstancePublish cmdlet. Specify the following settings:

Set the $instance variable as the Instance parameter value.
Set the $windowscreds variable as the WindowsCredentials parameter value.

Related Commands

Get-Credential