Start-VEPSQLDatabaseExport

Short Description

Starts an export process for a backed-up or a published PostgreSQL database.

Product: Veeam Backup & Replication

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

Syntax

This cmdlet provides the following parameter sets:

WindowsBackedUpDatabaseExportToLinuxLocalhostTarget

Start-VEPSQLDatabaseExport [-Database] <VEPSQLDatabase> [-StagingServerName] <String>

[-WindowsStagingCredentials] <PSCredential> [-ToPointInTimeUTC <DateTime>] -Path <String>

[-DisableCompression] [-LinuxTargetCredentials] <VEPSQLLinuxCredential> [-Force] [<CommonParameters>]

WindowsBackedUpDatabaseExportToWindowsLocalhostTarget

Start-VEPSQLDatabaseExport [-Database] <VEPSQLDatabase> [-StagingServerName] <String>

[-WindowsStagingCredentials] <PSCredential> [-ToPointInTimeUTC <DateTime>] -Path <String>

[-DisableCompression] [-WindowsTargetCredentials] <PSCredential> [-Force] [<CommonParameters>]

WindowsBackedUpDatabaseExportToLinuxTarget

Start-VEPSQLDatabaseExport [-Database] <VEPSQLDatabase> [-StagingServerName] <String>

[-WindowsStagingCredentials] <PSCredential> [-ToPointInTimeUTC <DateTime>] -Path <String>

[-DisableCompression] [-LinuxTargetCredentials] <VEPSQLLinuxCredential> [-LinuxTargetHost] <String>

[-LinuxTargetSshPort <Int32>] [-Force] [<CommonParameters>]

WindowsBackedUpDatabaseExportToWindowsTarget

Start-VEPSQLDatabaseExport [-Database] <VEPSQLDatabase> [-StagingServerName] <String>

[-WindowsStagingCredentials] <PSCredential> [-ToPointInTimeUTC <DateTime>] -Path <String>

[-DisableCompression] [-WindowsTargetCredentials] <PSCredential> [-WindowsTargetHost] <String> [-Force] [<CommonParameters>]

LinuxBackedUpDatabaseExportToLinuxLocalhostTarget

Start-VEPSQLDatabaseExport [-Database] <VEPSQLDatabase> [-StagingServerName] <String>

[-LinuxStagingCredentials] <VEPSQLLinuxCredential> [-StagingSshPort <Int32>] [-ToPointInTimeUTC <DateTime>]

-Path <String> [-DisableCompression] [-LinuxTargetCredentials] <VEPSQLLinuxCredential> [-Force] [<CommonParameters>]

LinuxBackedUpDatabaseExportToWindowsLocalhostTarget

Start-VEPSQLDatabaseExport [-Database] <VEPSQLDatabase> [-StagingServerName] <String>

[-LinuxStagingCredentials] <VEPSQLLinuxCredential> [-StagingSshPort <Int32>] [-ToPointInTimeUTC <DateTime>]

-Path <String> [-DisableCompression] [-WindowsTargetCredentials] <PSCredential> [-Force] [<CommonParameters>]

LinuxBackedUpDatabaseExportToLinuxTarget

Start-VEPSQLDatabaseExport [-Database] <VEPSQLDatabase> [-StagingServerName] <String>

[-LinuxStagingCredentials] <VEPSQLLinuxCredential> [-StagingSshPort <Int32>] [-ToPointInTimeUTC <DateTime>]

-Path <String> [-DisableCompression] [-LinuxTargetCredentials] <VEPSQLLinuxCredential>

[-LinuxTargetHost] <String> [-LinuxTargetSshPort <Int32>] [-Force] [<CommonParameters>]

LinuxBackedUpDatabaseExportToWindowsTarget

Start-VEPSQLDatabaseExport [-Database] <VEPSQLDatabase> [-StagingServerName] <String>

[-LinuxStagingCredentials] <VEPSQLLinuxCredential> [-StagingSshPort <Int32>] [-ToPointInTimeUTC <DateTime>]

-Path <String> [-DisableCompression] [-WindowsTargetCredentials] <PSCredential> [-WindowsTargetHost] <String>

[-Force] [<CommonParameters>]

PublishedDatabaseExportToLinuxLocalhostTarget

Start-VEPSQLDatabaseExport [-PublishedDatabase] <VEPSQLPublishedDatabase> -Path <String> [-DisableCompression]

[-LinuxTargetCredentials] <VEPSQLLinuxCredential> [-Force] [<CommonParameters>]
PublishedDatabaseExportToWindowsLocalhostTarget

Start-VEPSQLDatabaseExport [-PublishedDatabase] <VEPSQLPublishedDatabase> -Path <String> [-DisableCompression]

[-WindowsTargetCredentials] <PSCredential> [-Force] [<CommonParameters>]

PublishedDatabaseExportToLinuxTarget

Start-VEPSQLDatabaseExport [-PublishedDatabase] <VEPSQLPublishedDatabase> -Path <String> [-DisableCompression]

[-LinuxTargetCredentials] <VEPSQLLinuxCredential> [-LinuxTargetHost] <String> [-LinuxTargetSshPort <Int32>]

[-Force] [<CommonParameters>]

PublishedDatabaseExportToWindowsTarget

Start-VEPSQLDatabaseExport [-PublishedDatabase] <VEPSQLPublishedDatabase> -Path <String> [-DisableCompression]

[-WindowsTargetCredentials] <PSCredential> [-WindowsTargetHost] <String> [-Force] [<CommonParameters>]

Detailed Description

This cmdlet starts an export process for a backed-up or a published PostgreSQL database. You can export the necessary PostgreSQL database to the local host where the PowerShell session is running or any Windows or Linux server.

After you run the Start-VEPSQLDatabaseExport cmdlet, you can use the following cmdlets:

Parameters

Parameters
Parameter	Description	Type	Required	Position	Accept Pipeline Input
Database	Specifies a backed-up PostgreSQL database. The cmdlet will export this database. Accepts the `VEPSQLDatabase` object. To get this object, run the `Get-VEPSQLDatabase` cmdlet.	`VEPSQLDatabase`	True	0	True (ByValue)
DisableCompression	Defines that the cmdlet will not compress the output file.	`SwitchParameter`	False	Named	False
Force	Defines that the cmdlet will overwrite the existing PostgreSQL database files with the database files from the backup. If you provide this parameter, the cmdlet will show no prompt before executing the command.	`SwitchParameter`	False	Named	False
LinuxStagingCredentials	Specifies the credentials for the Linux-based staging server. Accepts the `VEPSQLLinuxCredential` object. To get this object, run the `New-VEPSQLLinuxCredential` cmdlet.	`VEPSQLLinuxCredential`	True	1	True (ByValue)
LinuxTargetCredentials	Specifies the credentials for the target Linux machine. Accepts the `VEPSQLLinuxCredential` object. To get this object, run the `New-VEPSQLLinuxCredential` cmdlet.	`VEPSQLLinuxCredential`	True	3	True (ByValue)
LinuxTargetHost	Specifies the name of the target Linux server.	`String`	True	4	True (ByValue)
LinuxTargetSshPort	Specifies the SSH port number. The cmdlet will use this port to connect to the target Linux machine.	`Int32`	False	Named	False
Path	Specifies the target path. The cmdlet will export a database to the location specified in this path. Note: This parameter works for both Windows and Linux target machines.	`String`	True	Named	False
PublishedDatabase	Specifies a published PostgreSQL database. The cmdlet will export this database. Accepts the `VEPSQLPublishedDatabase` object. To get this object, run the `Get-VEPSQLPublishedDatabase` cmdlet.	`VEPSQLPublishedDatabase`	True	0	True (ByValue)
StagingServerName	Specifies DNS name or IP address of the staging server.	`String`	True	2	True (ByValue)
StagingSshPort	Specifies the SSH port number. The cmdlet will use this port to connect to the staging Linux machine.	`Int32`	False	Named	False
ToPointInTimeUTC	Specifies the point in time in the UTC format within a restore interval of the PostgreSQL database. The cmdlet will export the specified database to the state of the specified point in time. If you do not use this parameter, the cmdlet will export the database to the point in time when the restore point for which you started the restore session was created.	`DateTime`	False	Named	False
WindowsStagingCredentials	Specifies the credentials for the Windows-based staging server. Accepts the `PSCredential` object. To get this object, run the `Get-Credential` cmdlet.	`PSCredential`	True	1	True (ByValue)
WindowsTargetCredentials	Specifies the credentials for the target Windows machine. Accepts the `PSCredential` object. To get this object, run the `Get-Credential` cmdlet.	`PSCredential`	True	3	True (ByValue)
WindowsTargetHost	Specifies the name of the target Windows server.	`String`	True	4	True (ByValue)

<CommonParameters>

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the About Common Parameters section of Microsoft Learn.

Output Object

The cmdlet returns the VEPSQLDatabaseExport object that contains information about the specified export session.

Examples

Start-VEPSQLDatabaseExport Example 1. Exporting Latest State of Published Database to Windows Host

This example shows how to export a published database to a Windows server, using its latest state on the backup file.

$publisheddatabase = Get-VEPSQLPublishedDatabase -Name "database_1"

$wincreds = Get-Credential

$export = Start-VEPSQLDatabaseExport -PublishedDatabase $publisheddatabase -WindowsTargetCredentials $wincreds -Path "C:\Users\Administrator\Desktop\rhel01_5433_postgres.dump" -DisableCompression

Perform the following steps:

Run the Get-VEPSQLPublishedDatabase cmdlet. Specify the Name parameter value. Save the result to the $publisheddatabase variable.
Run the Get-Credential cmdlet to create a credential object. Enter credentials that will be used to connect to the local host on which the PowerShell session is running. Save the result to the $wincreds variable.
Run the Start-VEPSQLDatabaseExport cmdlet. Specify the following settings:
- Set the $publisheddatabase variable as the PublishedDatabase parameter value.
- Set the $wincreds variable as the WindowsTargetCredentials parameter value.
- Specify the Path parameter value.
- Provide the DisableCompression parameter so that the cmdlet does not reduce size of the output.
Save the result to the $export variable to use it with other cmdlets.

Start-VEPSQLDatabaseExport Example 2. Exporting Point-in-Time State of Backed-Up Database to Another Linux Server

This example shows how to export a backed-up PostgreSQL database to a Linux server, using a point-in-time state on the backup file.

$session = Get-VEPSQLRestoreSession

$databases = Get-VEPSQLDatabase -Session $session[0]

$time = Get-Date -Date "2026-11-24 13:00:00"

$timeutc = $time.ToUniversalTime()

$securepassword = Read-Host -Prompt "Enter password" -AsSecureString

$linuxcreds = New-VEPSQLLinuxCredential -Account "root" -Password $securepassword

$targetsecurepassword = Read-Host -Prompt "Enter password" -AsSecureString

$targetlinuxcreds = New-VEPSQLLinuxCredential -Account "root" -Password $targetsecurepassword

$export = Start-VEPSQLDatabaseExport -Database $databases[0] -LinuxStagingCredentials $linuxcreds -StagingServerName "rhel01" -LinuxTargetCredentials $targetlinuxcreds -LinuxTargetHost "rhel02" -LinuxTargetSshPort 22 -ToPointInTimeUTC $timeutc -Path "/var/lib/postgresql/rhel01_5433_postgres.dump"

Perform the following steps:

Run the Get-VEPSQLRestoreSession 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 first restore session in the array.
Run the Get-VEPSQLDatabase cmdlet. Set the $session variable as the Session parameter value and select the necessary restore session. Save the result to the $databases variable.
Run the Get-Date cmdlet. Specify the Date parameter value to set the point in time to which the database must be exported. Save the result to the $time variable.
Convert the scheduled time to the UTC format using the ToUniversalTime() method. Save the result to the $timeutc variable.
Run the Read-Host cmdlet to create a secure password. Enter credentials that will be used to connect to the staging server. Provide the AsSecureString parameter. Save the result to the $securepassword variable.
Run the New-VEPSQLLinuxCredential cmdlet. Specify the Account parameter value. Set the $securepassword variable as the Password parameter value. Save the result to the $linuxcreds variable.
Run the Read-Host cmdlet to create a secure password. Enter credentials that will be used to connect to the target Linux server. Provide the AsSecureString parameter. Save the result to the $targetsecurepassword variable.
Run the New-VEPSQLLinuxCredential cmdlet. Specify the Account parameter value. Set the $targetsecurepassword variable as the Password parameter value. Save the result to the $targetlinuxcreds variable.
Run the Start-VEPSQLDatabaseExport cmdlet. Specify the following settings:
- Set the $databases variable as the Database parameter value and select the necessary database.
- Set the $linuxcreds variable as the LinuxStagingCredentials parameter value.
- Specify the StagingServerName parameter value.
- Set the $targetlinuxcreds variable as the LinuxTargetCredentials parameter value.
- Specify the LinuxTargetHost parameter value.
- Specify the LinuxTargetSshPort parameter value.
- Set the $timeutc variable as the ToPointInTimeUTC parameter value.
- Specify the Path parameter value.
Save the result to the $export variable to use it with other cmdlets.

Start-VEPSQLDatabaseExport Example 3. Exporting Latest State of Backed-Up Database from Windows Machine to Another Windows Server

This example shows how to export a backed-up PostgreSQL database from a Windows machine to another Windows server, using its latest state on the backup file.

$session = Get-VEPSQLRestoreSession

$databases = Get-VEPSQLDatabase -Session $session[0]

$stagingcreds = Get-Credential

$targetcreds = Get-Credential

$export = Start-VEPSQLDatabaseExport -Database $databases[0] -StagingServerName "winserver01" -WindowsStagingCredentials $stagingcreds -WindowsTargetCredentials $targetcreds -WindowsTargetHost "winserver02" -Path "C:\PostgreSQL\Exports\database_1.dump"

Perform the following steps:

Run the Get-VEPSQLRestoreSession 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 first restore session in the array.
Run the Get-VEPSQLDatabase cmdlet. Set the $session variable as the Session parameter value and select the necessary restore session. Save the result to the $databases variable.
Run the Get-Credential cmdlet to create a credential object. Enter credentials for the Windows-based staging server. Save the result to the $stagingcreds variable.
Run the Get-Credential cmdlet to create a credential object. Enter credentials for the target Windows server. Save the result to the $targetcreds variable.
Run the Start-VEPSQLDatabaseExport cmdlet. Specify the following settings:
- Set the $databases variable as the Database parameter value and select the necessary database.
- Specify the StagingServerName parameter value.
- Set the $stagingcreds variable as the WindowsStagingCredentials parameter value.
- Set the $targetcreds variable as the WindowsTargetCredentials parameter value.
- Specify the WindowsTargetHost parameter value.
- Specify the Path parameter value.
Save the result to the $export variable to use it with other cmdlets.

Start-VEPSQLDatabaseExport Example 4. Exporting Published Database to Another Linux Server

This example shows how to export a published PostgreSQL database to another Linux server.

$publisheddatabase = Get-VEPSQLPublishedDatabase -Name "database_1"

$securepassword = Read-Host -Prompt "Enter password" -AsSecureString

$linuxcreds = New-VEPSQLLinuxCredential -Account "postgres" -Password $securepassword

$export = Start-VEPSQLDatabaseExport -PublishedDatabase $publisheddatabase -LinuxTargetCredentials $linuxcreds -LinuxTargetHost "rhel03" -LinuxTargetSshPort 22 -Path "/var/lib/postgresql/database_1.dump"

Perform the following steps:

Run the Get-VEPSQLPublishedDatabase cmdlet. Specify the Name parameter value. Save the result to the $publisheddatabase variable.
Run the Read-Host cmdlet to create a secure password. Enter credentials that will be used to connect to the target Linux server. Provide the AsSecureString parameter. Save the result to the $securepassword variable.
Run the New-VEPSQLLinuxCredential cmdlet. Specify the Account parameter value. Set the $securepassword variable as the Password parameter value. Save the result to the $linuxcreds variable.
Run the Start-VEPSQLDatabaseExport cmdlet. Specify the following settings:
- Set the $publisheddatabase variable as the PublishedDatabase parameter value.
- Set the $linuxcreds variable as the LinuxTargetCredentials parameter value.
- Specify the LinuxTargetHost parameter value.
- Specify the LinuxTargetSshPort parameter value.
- Specify the Path parameter value.
Save the result to the $export variable to use it with other cmdlets.