Get-VEPSQLTablespace
Short Description
Returns tablespaces for a backed-up PostgreSQL instance.
Applies to
Veeam Backup & Replication
Product Edition: Enterprise, Enterprise Plus, Veeam Universal License
Syntax
Get-VEPSQLTablespace [-Instance] <VEPSQLInstance> [<CommonParameters>] |
Detailed Description
This cmdlet returns an array of tablespaces for a backed-up PostgreSQL instance.
Parameters
Parameter | Description | Type | Required | Position | Accept Pipeline Input |
|---|---|---|---|---|---|
Instance | Specifies a PostgreSQL instance. The cmdlet will return an array of tablespaces for the specified instance. | Accepts the VEPSQLInstance object. To get this object, run the Get-VEPSQLInstance cmdlet. | True | 0 | True (ByValue) |
<CommonParameters>
This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the About CommonParameters section of Microsoft Docs.
Output Object
The cmdlet returns the VEPSQLTableSpace[] object that contains an array of tablespaces for the specified instance.
Example
Getting Tablespaces of PostgreSQL Instance
This example shows how to get an array of tablespaces for a backed-up PostgreSQL instance.
$session = Get-VEPSQLRestoreSession $instance = Get-VEPSQLInstance -Session $session[0] -DataDirectory /var/lib/pgsql/13/data Get-VEPSQLTablespace -Instance $instance |
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 our example, it is the first restore session in the array.
- Run the Get-VEPSQLInstance cmdlet. Set the $session variable as the Session parameter value. Specify the DataDirectory parameter value. Save the result to the $instance variable.
- Run the Get-VEPSQLTablespace cmdlet. Set the $instance variable as the Instance parameter value.
Related Commands