---
title: "Get-VEPSQLInstancePublish"
description: "Returns active publishing sessions for backed-up PostgreSQL instances. Product: Veeam Backup & Replication Product Edition: Community, Standard, Enterprise, Enterprise Plus, Veeam Universal License This cmdlet returns information about the publis"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/get-vepsqlinstancepublish.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for PostgreSQL > Get-VEPSQLInstancePublish"
dateModified: "2026-08-18"
---

# Get-VEPSQLInstancePublish

## Short Description
Returns active publishing sessions for backed-up PostgreSQL instances.

**Product**: Veeam Backup & Replication

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

## Syntax
```
Get-VEPSQLInstancePublish [[-InstanceName] <String>] [<CommonParameters>]
```

## Detailed Description
This cmdlet returns information about the publishing process for backed-up PostgreSQL instances.

## 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 the name of the published PostgreSQL instance. The cmdlet will return information about the publishing process performed for the specified instance.</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>True (ByValue)</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 [`VEPSQLInstancePublish`](vepsqlinstancepublish.md)`[]` array that contains information about the publishing process of PostgreSQL instances.

## Examples

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

This command returns a list of all published PostgreSQL instances. Save the result to the `$publish` variable to be able to use it with other cmdlets.

```
$publish = Get-VEPSQLInstancePublish
```

:::

::: example
### Example 2. Getting Published PostgreSQL Instance with Specific Name

This command returns a specific published instance. Save the result to the `$publish` variable to be able to use it with other cmdlets.

```
$publish = Get-VEPSQLInstancePublish -InstanceName "rhel01:5433"
```

:::