Get-VEPSQLDatabaseExport - Veeam Explorers PowerShell Reference

Get-VEPSQLDatabaseExport [-Name <String[]>] [-InstanceName <String[]>] [-ServerName <String[]>] [-TargetServerName <String[]>] [<CommonParameters>]

Parameter	Description	Type	Required	Position	Accept Pipeline Input
InstanceName	Specifies an array of names of PostgreSQL instances. The cmdlet will return an array of databases on the specified instances that have ongoing export sessions. This parameter accepts wildcard characters.	String[]	False	Named	False
Name	Specifies an array of names of PostgreSQL databases. The cmdlet will return an array of databases with the specified names that have ongoing export sessions. This parameter accepts wildcard characters.	String[]	False	Named	False
ServerName	Specifies an array of names of PostgreSQL servers (as DNS names or IP addresses). The cmdlet will return an array of databases on the specified servers that have ongoing export sessions. This parameter accepts wildcard characters.	String[]	False	Named	False
TargetServerName	Specifies an array of names of target PostgreSQL servers (as DNS names or IP addresses) for export operations. The cmdlet will return an array of databases that are being exported to the specified target servers. This parameter accepts wildcard characters.	String[]	False	Named	False

This command returns all active PostgreSQL export sessions. Save the result to the $export variable to be able to use it with other cmdlets.

$export = Get-VEPSQLDatabaseExport

This example shows how to get an array of active PostgreSQL export sessions for databases with specific names located on specific instances.

$dbnames = @("fiscal", "sales", "IT")

$instancenames = @("rhel01:5433", "rhel01:5434")

$export = Get-VEPSQLDatabaseExport -Name $dbnames -InstanceName $instancenames

Perform the following steps:

Declare the $dbnames variable. Assign to this variable an array with the names of the necessary PostgreSQL databases.
Declare the $instancenames variable. Assign to this variable an array with the names of the PostgreSQL instances that you want to query.
Run the Get-VEPSQLDatabaseExport cmdlet. Set the $dbnames variable as the Name parameter value. Set the $instancenames variable as the InstanceName parameter value. Save the result to the $export variable to be able to use it with other cmdlets.

This example shows how to get an array of active PostgreSQL export sessions from backups of specific servers to specific target servers.

$targetservernames = @("win01", "rhel03")

$export = Get-VEPSQLDatabaseExport -TargetServerName $targetservernames

Perform the following steps:

Declare the $targetservernames variable. Assign to this variable an array with the names of the necessary target servers with PostgreSQL.
Run the Get-VEPSQLDatabaseExport cmdlet. Set the $targetservernames variable as the TargetServerName parameter value. Save the result to the $export variable to be able to use it with other cmdlets.