---
title: "Get-VEPSQLDatabaseRestore"
description: "Returns information about restore processes for backed-up PostgreSQL databases. Product: Veeam Backup & Replication Product Edition: Community, Standard, Enterprise, Enterprise Plus, Veeam Universal License This cmdlet provides the following para"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/get-vepsqldatabaserestore.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for PostgreSQL > Get-VEPSQLDatabaseRestore"
dateModified: "2026-08-18"
---

# Get-VEPSQLDatabaseRestore

## Short Description
Returns information about restore processes for backed-up PostgreSQL databases.

**Product**: Veeam Backup & Replication

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

## Syntax

This cmdlet provides the following parameter sets:

<ul class="syntax-sets">
  <li>
    <p><code>ByIdParameterSet</code></p>

```
Get-VEPSQLDatabaseRestore -JobId <Guid> [<CommonParameters>]
```
  </li>
  <li>
    <p><code>AllParameterSet</code></p>

```
Get-VEPSQLDatabaseRestore [-DatabaseName <String[]>] [<CommonParameters>]
```
  </li>
</ul>

## Detailed Description
This cmdlet returns information about the restore process for a backed-up PostgreSQL database.

## 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">DatabaseName</span></p>
        </td>
        <td>
          <p>Specifies names of restored PostgreSQL databases. The cmdlet will return restore jobs performed for the specified databases.</p><p>This parameter accepts wildcard characters.</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>Named</p>
        </td>
        <td style="width:10%;">
          <p>True (ByValue)</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">JobId</span></p>
        </td>
        <td>
          <p>Specifies the job ID of the required restore job. The cmdlet will return information about the specified restore job.</p>
        </td>
        <td style="width:10%;">
          <p><code>Guid</code></p>
        </td>
        <td style="width:10%;">
          <p>True</p>
        </td>
        <td style="width:10%;">
          <p>Named</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 [`VEPSQLDatabaseRestore`](vepsqldatabaserestore.md)`[]` array that contains information about the restore process of PostgreSQL databases.

## Examples

::: example
### Example 1. Getting All Restore Processes

This command returns a list of all active restore processes for backed-up PostgreSQL databases. Save the result to the `$restore` variable to be able to use it with other cmdlets.

```
$restore = Get-VEPSQLDatabaseRestore
```

:::

::: example
### Example 2. Getting Restore Process by Job ID

This example shows how to get a specific restore job by its job ID. Save the result to the `$restore` variable to be able to use it with other cmdlets.

```
$restore = Get-VEPSQLDatabaseRestore -JobId "b6b9b806-bc3c-491c-8ef4-0490d0d2608c"
```

:::

::: example
### Example 3. Getting Restore Processes for Specific Database

This command returns all active restore processes for a specific database. Save the result to the `$restore` variable to be able to use it with other cmdlets.

```
$restore = Get-VEPSQLDatabaseRestore -DatabaseName "location1"
```

:::

::: example
### Example 4. Getting Restore Processes for Specific Databases Using Wildcards

This command returns all active restore jobs for databases whose names begin with "db". Save the result to the `$restore` variable to be able to use it with other cmdlets.

```
$restore = Get-VEPSQLDatabaseRestore -DatabaseName "db*"
```

:::