---
title: "Stop-VEPSQLRestoreSession"
description: "Stops an active restore session initiated to perform operations with PostgreSQL instances. Product: Veeam Backup & Replication Product Edition: Enterprise, Enterprise Plus, Veeam Universal License This cmdlet stops active restore sessions initiat"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/stop-vepsqlrestoresession.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for PostgreSQL > Stop-VEPSQLRestoreSession"
dateModified: "2026-08-18"
---

# Stop-VEPSQLRestoreSession

## Short Description
Stops an active restore session initiated to perform operations with PostgreSQL instances.

**Product**: Veeam Backup & Replication

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

## Syntax
```
Stop-VEPSQLRestoreSession [-Session] <VEPSQLRestoreSession> [<CommonParameters>]
```

## Detailed Description
This cmdlet stops active restore sessions initiated to perform operations with PostgreSQL data.

::: note

- The cmdlet will unpublish all PostgreSQL instances published in the restore session.
- The cmdlet stops restore sessions initiated in the PowerShell console only.
- Active restore sessions will not stop automatically if you close the PowerShell console. To stop a restore session, you must run the `Stop-VEPSQLRestoreSession` cmdlet.

:::

## 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">Session</span></p>
        </td>
        <td>
          <p>Specifies an PostgreSQL restore session that you want to stop.</p><p>Accepts the <a href="vepsqlrestoresession.md"><code>VEPSQLRestoreSession</code></a> object. To get this object, run the <a href="get-vepsqlrestoresession.md"><code>Get-VEPSQLRestoreSession</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><a href="vepsqlrestoresession.md"><code>VEPSQLRestoreSession</code></a></p>
        </td>
        <td style="width:10%;">
          <p>True</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.

## Examples

::: example
### Stopping Restore Session

This example shows how to stop a restore session initiated to perform operations with PostgreSQL instances.

```
$session = Get-VEPSQLRestoreSession
Stop-VEPSQLRestoreSession -Session $session[3]
```

Perform the following steps:

1. Run the [`Get-VEPSQLRestoreSession`](get-vepsqlrestoresession.md) cmdlet. Save the result to the `$session` variable.

   The cmdlet will return an array of active restore sessions. Note the ordinal number of the necessary restore session (in this example, it is the fourth restore session in the array).

2. Run the `Stop-VEPSQLRestoreSession` cmdlet. Set the `$session` variable as the `Session` parameter value.

:::

## Related Commands

- [`Get-VEPSQLRestoreSession`](get-vepsqlrestoresession.md)
- [`Start-VEPSQLRestoreSession`](start-vepsqlrestoresession.md)