---
title: "Set-VBRPostgreSQLProcessingOptions"
description: "This cmdlet modifies settings for processing backed-up PostgreSQL database for Veeam Agent backup jobs. To modify settings, specify new values for the necessary parameters. The cmdlet will overwrite the previous parameter values with new values."
canonical: "https://helpcenter.veeam.com/docs/vbr/powershell/set-vbrpostgresqlprocessingoptions.html"
breadcrumb: "Veeam PowerShell Reference > Veeam PowerShell Reference > Veeam Agent Management > Working with Veeam Agent Backup Jobs and Policies > Veeam Agent Job Guest Processing Options > Set-VBRPostgreSQLProcessingOptions"
dateModified: "2026-08-19"
---

# Set-VBRPostgreSQLProcessingOptions

## Short Description
Modifies settings for processing backed-up PostgreSQL databases on Linux computers.

## Syntax
```
Set-VBRPostgreSQLProcessingOptions -Options <VBRPostgreSQLProcessingOptions> [-Credentials <CCredentials>]
 [-UserType <VBRPostgreSQLUserType>] [-EnableArchiveLogBackup] [-ArchiveLogBackupPeriod <Int32>]
 [-ArchiveLogRetainAction <VBRLogRetainAction>] [-ArchiveLogRetainPeriod <Int32>]
 [-ArchiveLogBackupStorage <String>] [<CommonParameters>]
```

## Detailed Description
This cmdlet modifies settings for processing backed-up PostgreSQL database for Veeam Agent backup jobs.

::: note

To modify settings, specify new values for the necessary parameters. The cmdlet will overwrite the previous parameter values with new values. The parameters that you omit will remain unchanged.

:::

## 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">ArchiveLogBackupPeriod</span></p>
        </td>
        <td>
          <p>Specifies how often in minutes the cmdlet will back up WAL files.</p><p>Default: <code>15</code> minutes.</p>
        </td>
        <td style="width:10%;">
          <p><code>Int32</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">ArchiveLogBackupStorage</span></p>
        </td>
        <td>
          <p>For Linux machines.</p><p>Specify a path to a location where WAL files are stored.</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>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">ArchiveLogRetainAction</span></p>
        </td>
        <td>
          <p>Specifies retention policy for WAL files stored in the backup location.</p><ul><li><code>WaitForBackupDeletion</code>: use this option to keep WAL files backups the same period as image-level backups.</li><li><code>KeepOnlyLastDays</code>: use this option to keep WAL files backups for a specific number of days. Use the <code>ArchiveLogRetainPeriod</code> parameter to specify the number of days.</li></ul>
        </td>
        <td style="width:10%;">
          <p><code>VBRLogRetainAction</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">ArchiveLogRetainPeriod</span></p>
        </td>
        <td>
          <p>Specifies the number of days to keep WAL files.</p><p>Default: <code>15</code>.</p>
        </td>
        <td style="width:10%;">
          <p><code>Int32</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Credentials</span></p>
        </td>
        <td>
          <p>Specifies the PostgreSQL credentials that Veeam Agent will use to connect to the PostgreSQL server.</p><p>Accepts the <code>CCredentials</code> object. To get this object, run the <a href="get-vbrcredentials.md"><code>Get-VBRCredentials</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><code>CCredentials</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">EnableArchiveLogBackup</span></p>
        </td>
        <td>
          <p>Defines that the cmdlet will back up WAL files.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Options</span></p>
        </td>
        <td>
          <p>Specifies settings for backed-up PostgreSQL database. The cmdlet will modify these settings.</p><p>Accepts the <code>VBRPostgreSQLProcessingOptions</code> object. To create this object, run the <a href="new-vbrpostgresqlprocessingoptions.md"><code>New-VBRPostgreSQLProcessingOptions</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><code>VBRPostgreSQLProcessingOptions</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>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">UserType</span></p>
        </td>
        <td>
          <p>Specifies the PostgreSQL authentication options. You can specify either of the following types of authentication options:</p><ul><li><code>DBUserWithPassword</code>: use this option for the password-based authentication. Veeam Agent will use the database login and password to authenticate against the PostgreSQL server.</li><li><code>DBUserWithPasswordFile</code>: use this option to authenticate against the PostgreSQL server with the password file. This password file must contain the user name and the password of the database user.</li><li><code>SystemUserWithoutPassword</code>: use this option for the peer authentication method. Veeam Agent will use the OS user name to authenticate against the PostgreSQL server.</li></ul><p>Default: <code>DBUserWithPassword</code>.</p>
        </td>
        <td style="width:10%;">
          <p><code>VBRPostgreSQLUserType</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
    </table>

`<CommonParameters>`

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see [ Microsoft Docs](https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_commonparameters?view=powershell-7).

## Output Object
This cmdlet returns the `VBRPostgreSQLProcessingOptions` object that contains settings for processing backed-up PostgreSQL databases.

## Examples

::: example
### Modifying PostgreSQL Authentication Options

This example shows how to modify the PostgreSQL authentication options. Veeam Agent will use the peer authentication option.

```
$options = New-VBRPostgreSQLProcessingOptions
Set-VBRPostgreSQLProcessingOptions -Options $options -UserType SystemUserWithoutPassword
```

Perform the following steps:

1. Run the [`New-VBRPostgreSQLProcessingOptions`](new-vbrpostgresqlprocessingoptions.md) cmdlet. Save the result to the `$options` variable.
2. Run the `Set-VBRPostgreSQLProcessingOptions` cmdlet. Set the `$options` variable as the `Options` parameter value. Set the `SystemUserWithoutPassword` option for the `UserType` parameter.

:::

## Related Commands

[`New-VBRPostgreSQLProcessingOptions`](new-vbrpostgresqlprocessingoptions.md)