Start-VEPSQLRestoreSession

Short Description

Starts a restore session to explore backed-up PostgreSQL instances and to perform operations with these instances.

Product: Veeam Backup & Replication

Product Edition: Enterprise, Enterprise Plus, Veeam Universal License

Syntax

Detailed Description

This cmdlet starts a new restore session, establishes a connection to the backup server and retrieves backed-up PostgreSQL databases.

Within the restore session, you can get information about the backed-up PostgreSQL instances using the following cmdlets:

• Get-VEPSQLInstanceReturns backed-up PostgreSQL instances.
• Get-VEPSQLTablespaceReturns tablespaces for a backed-up PostgreSQL instance.

After you get backed-up PostgreSQL instances, you can restore, publish, or perform instant recovery with these instances.

• Run the Start-VEPSQLInstanceRestoreRestores a backed-up PostgreSQL instance. cmdlet to restore PostgreSQL instances.
• Run the Start-VEPSQLInstancePublishPublishes a backed-up PostgreSQL instance. cmdlet to publish PostgreSQL instances.
• Run the Start-VEPSQLInstanceInstantRecoveryPerforms instant recovery of a backed-up PostgreSQL instance. cmdlet to perform instant recovery of PostgreSQL instances.

Within the restore session you can also get information about the backed-up PostgreSQL databases with the Get-VEPSQLDatabaseReturns backed-up PostgreSQL databases. cmdlet. After you get the backed-up PostgreSQL databases, you can export these databases with the Start-VEPSQLDatabaseExportStarts an export process for a backed-up or a published PostgreSQL database. cmdlet.

Parameters

<CommonParameters>

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

Output Object

The cmdlet returns the VEPSQLRestoreSession object that contains settings of the restore session started to explore and recover backed-up PostgreSQL data.

Examples

Starting Restore Session

This example shows how to start a restore session to perform operations with PostgreSQL instances.

Perform the following steps:

1. Run the Get-VBRApplicationRestorePoint cmdlet. Provide the PostgreSQL parameter. Save the result to the $restorepoint variable.

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

2. Run the Start-VEPSQLRestoreSession cmdlet. Set the $restorepoint variable as the RestorePoint parameter value and select the necessary restore point.

Related Commands

Get-VBRApplicationRestorePoint