---
title: "Get-VEPSQLRestoreSession"
description: "Returns active restore sessions started to perform operations with backed-up PostgreSQL instances. Product: Veeam Backup & Replication Product Edition: Enterprise, Enterprise Plus, Veeam Universal License This cmdlet returns an array of active re"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/get-vepsqlrestoresession.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for PostgreSQL > Get-VEPSQLRestoreSession"
dateModified: "2026-08-18"
---

# Get-VEPSQLRestoreSession

## Short Description
Returns active restore sessions started to perform operations with backed-up PostgreSQL instances.

**Product**: Veeam Backup & Replication

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

## Syntax
```
Get-VEPSQLRestoreSession [<CommonParameters>]
```

## Detailed Description
This cmdlet returns an array of active restore sessions started to perform operations with backed-up PostgreSQL instances.

::: note

- You can only get an array of restore sessions that are started in PowerShell. The cmdlet does not return restore sessions started in the Veeam Backup & Replication console.
- The cmdlet only returns an array of restore sessions started within the same PowerShell session.

:::

## Parameters

`<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 [`VEPSQLRestoreSession`](vepsqlrestoresession.md)`[]` array that contains settings of restore sessions started to explore and recover backed-up PostgreSQL data.

## Examples

::: example
### Example 1. Getting All Running Restore Sessions

This command gets all restore sessions started to perform operations with PostgreSQL instances. Save the result to the `$session` variable to be able to use it with other cmdlets.

```
$session = Get-VEPSQLRestoreSession
```

:::

::: example
### Example 2. Getting Specific Restore Session

This example shows how to get a specific restore session started to perform operations with PostgreSQL instances.

```
$session = Get-VEPSQLRestoreSession
$session[0]
```

Perform the following steps:

1. Run the `Get-VEPSQLRestoreSession` cmdlet. Save the result to the `$session` variable. The cmdlet will return an array of active restore sessions.
2. Specify the necessary ordinal number of the restore session for the `$session` variable. In this example, it is the first restore session in the array.

:::

## Related Commands

- [`Start-VEPSQLRestoreSession`](start-vepsqlrestoresession.md)
- [`Stop-VEPSQLRestoreSession`](stop-vepsqlrestoresession.md)