---
title: "Get-VEPSQLInstanceRestoreInterval"
description: "Returns details on the available restore period for a backed-up PostgreSQL instance. Product: Veeam Backup & Replication Product Edition: Enterprise, Enterprise Plus, Veeam Universal License This cmdlet returns details on available restore period"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/get-vepsqlinstancerestoreinterval.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for PostgreSQL > Get-VEPSQLInstanceRestoreInterval"
dateModified: "2026-08-18"
---

# Get-VEPSQLInstanceRestoreInterval

## Short Description
Returns details on the available restore period for a backed-up PostgreSQL instance.

**Product**: Veeam Backup & Replication

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

## Syntax
```
Get-VEPSQLInstanceRestoreInterval [-Instance] <VEPSQLInstance> [<CommonParameters>]
```

## Detailed Description
This cmdlet returns details on available restore period for a backed-up PostgreSQL instance.

## 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">Instance</span></p>
        </td>
        <td>
          <p>Specifies a backed-up PostgreSQL instance. The cmdlet will return information on the available restore period for the specified instance.</p><p>Accepts the <a href="vepsqlinstance.md"><code>VEPSQLInstance</code></a> object. To get this object, run the <a href="get-vepsqlinstance.md"><code>Get-VEPSQLInstance</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><a href="vepsqlinstance.md"><code>VEPSQLInstance</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.

## Output Object
The cmdlet returns the [`VEPSQLDatabaseRestoreInterval`](vepsqldatabaserestoreinterval.md) object that contains details on available restore period for the specified PostgreSQL instance.

## Examples

::: example
### Getting Restore Period for PostgreSQL Instance

This example shows how to get details on an available restore period for the PostgreSQL instance.

```
$session = Get-VEPSQLRestoreSession
$instance = Get-VEPSQLInstance -Session $session[0] -DataDirectory /var/lib/pgsql/13/data
Get-VEPSQLInstanceRestoreInterval -Instance $instance
```

Perform the following steps:

1. Run the [`Get-VEPSQLRestoreSession`](get-vepsqlrestoresession.md) cmdlet. Save the result to the `$session` variable.
2. Run the [`Get-VEPSQLInstance`](get-vepsqlinstance.md) cmdlet. Set the `$session` variable as the `Session` parameter value. Specify the `DataDirectory` parameter value. Save the result to the `$instance` variable.
3. Run the `Get-VEPSQLInstanceRestoreInterval` cmdlet. Set the `$instance` variable as the `Instance` parameter value.

:::

## Related Commands

- [`Get-VEPSQLRestoreSession`](get-vepsqlrestoresession.md)
- [`Get-VEPSQLInstance`](get-vepsqlinstance.md)