You can browse and restore one or more databases.
Before You Begin
- To back up roles in the database, enable backups for global objects in the database. The pg_dump utility that is used to perform DumpBased backup operation does not back up roles by default. If you did not have the global objects backed up already, to restore the data with the database user defined in the destination instance properties as the owner, create the additional settings bPGRestoreNoACL and bPGRestoreNoOwner before initiating the restore job.
-
To restore from a parallel DumpBased backup, do the following:
- If you want to perform stage free restores for Linux clients, verify that the nfs-utils package is installed on the client and configure the 3DFS cache path on theMediaAgent that hosts the 3DFS server.
-
For stage free restores, verify that the following ports are open:
- For the MediaAgent on a Windows computer, open 111, 445, 2049, and 2050.
- For the MediaAgent on a Linux computer, open 111 and 2049.
- Enter an optimal value for the number of parallel jobs based on the hardware setup of the server, client, and network. For more information, go to the -j command line argument in the PostgreSQL documentation website.
Procedure
-
From the navigation pane, go to Protect > Databases.
The Overview page appears.
-
On the Instances tab, click the instance.
The instance page appears.
-
On the Database groups tab, in the Database groups table, for the database group that you want to restore, click the action button , and then click Restore.
The Backup content page appears.
-
Select the databases that you want to restore, and then click Restore.
The Restore options dialog box appears.
-
Follow the steps for the type of restore operation you want to run:
-
To run an in-place restore operation, do the following:
-
Click the In place option.
For an in-place restore operation, the destination server and the destination instance are the same as the source server and the source instance.
-
To restore a Dumpbased backupset using parallel jobs, in the Staging path box, enter the location to set the staging path to a local directory.
Note
The Staging path box appears only if you use parallel jobs to dump the Google Cloud SQL for PostgreSQL Database.
-
Select a MediaAgent from the MediaAgent list.
-
-
To run an out-of-place restore operation, do the following:
-
Click the Out of place option.
-
Select the Restore type.
-
Select the Destination server.
-
Select the Destination instance.
-
In the Staging path box, enter the location in the destination access node.
Note
-
The Staging path box appears only if you enable backups for global objects in Google Cloud SQL for PostgreSQL Databases.
-
You can enter a staging path only if you have selected the destination server and destination instance.
-
-
Select a MediaAgent from the MediaAgent list.
-
-
-
Click Submit.