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

# Get-VEPSQLPublishedDatabase

## Short Description
Returns published PostgreSQL databases.

**Product**: Veeam Backup & Replication

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

## Syntax
```
Get-VEPSQLPublishedDatabase [[-Name] <String[]>] [[-InstanceName] <String[]>] [[-ServerName] <String[]>] [<CommonParameters>]
```

## Detailed Description
This cmdlet returns an array of published PostgreSQL databases. Once you get the necessary PostgreSQL database, you can use [`Start-VEPSQLDatabaseExport`](start-vepsqldatabaseexport.md) cmdlet to export it.

Note that you will only get an array of PostgreSQL databases published with PowerShell. The cmdlet does not return PostgreSQL databases published in the Veeam Backup & Replication console.

## 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.</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>1</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.</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>0</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 target PostgreSQL servers (as DNS names or IP addresses). The cmdlet will return an array of databases published on the specified servers.</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>2</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 [`VEPSQLPublishedDatabase`](vepsqlpublisheddatabase.md)`[]` array that contains settings of published PostgreSQL databases.

## Examples

::: example
### Example 1. Getting All Published PostgreSQL Databases

This example shows how to get an array of all published PostgreSQL databases.

```
Get-VEPSQLPublishedDatabase
```

:::

::: example
### Example 2. Getting All Published PostgreSQL Databases with Specific Names Belonging to Specific Instances

This example shows how to get an array of published PostgreSQL databases with specific names belonging to specific instances on the backup file.

```
$dbnames = @("fiscal", "sales")
$instancenames = @("rhel01:5433", "rhel01:5434")
$database = Get-VEPSQLPublishedDatabase -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-VEPSQLPublishedDatabase` cmdlet. Set the `$dbnames` variable as the `Name` parameter value and set the `$instancenames` variable as the `InstanceName` parameter value. Save the result to the `$database` variable to be able to use it with other cmdlets.

:::

::: example
### Example 3. Getting All PostgreSQL Databases Published on Specific Servers

This example shows how to get an array of all PostgreSQL databases published on the specified servers.

```
$servernames = @("rhel01", "rhel02")
$database = Get-VEPSQLPublishedDatabase -ServerName $servernames
```

Perform the following steps:

1. Declare the `$servernames` variable. Assign to this variable an array with the names of the necessary servers with PostgreSQL.
2. Run the `Get-VEPSQLPublishedDatabase` cmdlet. Set the `$servernames` variable as the `ServerName` parameter value. Save the result to the `$database` variable to be able to use it with other cmdlets.

:::