Get-VEPSQLDatabaseExport

Short Description

Returns PostgreSQL databases with ongoing export sessions.

Applies to

Veeam Backup & Replication

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

Syntax

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

Detailed Description

This cmdlet returns an array of PostgreSQL databases with ongoing export sessions.

After you get the databases with ongoing export sessions, you can perform the following operations:

Parameters

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.

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.

String[]

False

Named

False

ServerName

Specifies an array of names of PostgreSQL servers. The cmdlet will return an array of databases on the specified servers that have ongoing export sessions.

String[]

False

Named

False

TargetServerName

Specifies an array of names of target PostgreSQL servers for export operations. The cmdlet will return an array of databases that are being exported to the specified target servers.

String[]

False

Named

False

<CommonParameters>

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

Output Object

The cmdlet returns the VEPSQLDatabaseExport[] object that contains an array of ongoing PostgreSQL export sessions.

Examples

Get-VEPSQLDatabaseExportExample 1. Getting All Export Sessions

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

Get-VEPSQLDatabaseExportExample 2. Getting All PostgreSQL Export Sessions for Databases with Specific Names on Specific Instances

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:

  1. Declare the $dbnames variable. Assign to this variable an array with the names of the necessary PostgreSQL databases.
  2. Declare the $instancenames variable. Assign to this variable an array with the names of the PostgreSQL instances that you want to query.
  3. 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.

Get-VEPSQLDatabaseExportExample 3. Getting All PostgreSQL Export Sessions to Specific Servers

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:

  1. Declare the $targetservernames variable. Assign to this variable an array with the names of the necessary target servers with PostgreSQL.
  2. 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.

Related Commands