---
title: "Get-VEPSQLDatabaseExport"
description: "Returns PostgreSQL databases with ongoing export sessions. Product: Veeam Backup & Replication Product Edition: Community, Standard, Enterprise, Enterprise Plus, Veeam Universal License This cmdlet returns an array of PostgreSQL databases with on"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/get-vepsqldatabaseexport.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for PostgreSQL > Get-VEPSQLDatabaseExport"
dateModified: "2026-08-18"
---

# Get-VEPSQLDatabaseExport

## Short Description
Returns PostgreSQL databases with ongoing export sessions.

**Product**: 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:

- [`Restart-VEPSQLDatabaseExport`](restart-vepsqldatabaseexport.md)
- [`Stop-VEPSQLDatabaseExport`](stop-vepsqldatabaseexport.md)

## Parameters

<table style="width:100%;" class="Blue_Table">
      <tr style="vertical-align:top">
        <th style="width:20%;">
          <p>Parameter</p>
        </th>
        <th style="width:20%;">
          <p>Description</p>
        </th>
        <th style="width:20%;">
          <p>Type</p>
        </th>
        <th style="width:10%;">
          <p>Required</p>
        </th>
        <th style="width:10%;">
          <p>Position</p>
        </th>
        <th style="width:10%;">
          <p>Accept Pipeline Input</p>
        </th>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">InstanceName</span></p>
        </td>
        <td>
          <p>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.</p><p>This parameter accepts wildcard characters.</p>
        </td>
        <td style="width:10%;">
          <p><code>String[]</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Name</span></p>
        </td>
        <td>
          <p>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.</p><p>This parameter accepts wildcard characters.</p>
        </td>
        <td style="width:10%;">
          <p><code>String[]</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">ServerName</span></p>
        </td>
        <td>
          <p>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.</p><p>This parameter accepts wildcard characters.</p>
        </td>
        <td style="width:10%;">
          <p><code>String[]</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">TargetServerName</span></p>
        </td>
        <td>
          <p>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.</p><p>This parameter accepts wildcard characters.</p>
        </td>
        <td style="width:10%;">
          <p><code>String[]</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
    </table>

`<CommonParameters>`

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the [About Common Parameters](http://go.microsoft.com/fwlink/p/?LinkID=113216) section of Microsoft Docs.

## Output Object
The cmdlet returns the [`VEPSQLDatabaseExport`](vepsqldatabaseexport.md)`[]` array that contains ongoing PostgreSQL export sessions.

## Examples

::: example
### Example 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
```

:::

::: example
### Example 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.

:::

::: example
### Example 3. Getting All PostgreSQL Export Sessions to Specific Servers

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

```
$targetservernames = @("rhel02", "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

- [`Start-VEPSQLDatabaseExport`](start-vepsqldatabaseexport.md)
- [`Stop-VEPSQLDatabaseExport`](stop-vepsqldatabaseexport.md)