Restoring a Database Group for Google Cloud SQL for PostgreSQL

Updated

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.

  • To restore from a parallel DumpBased backup, do the following:

    • Use parallel jobs to dump the PostgreSQL database.

    • 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

  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. Click the instance.

    The instance page appears.

  3. Under Database groups, for the database group that you want to back up, click the action button , and then click Restore.

    The Backup content page appears.

  4. Select the databases that you want to restore, and then click Restore.

    The Restore options dialog box appears.

  5. To run an in-place restore operation, on the In place tab, verify that the destination client and the destination instance are the same as the source client and the source instance.

  6. To run an out-of-place restore operation, on the Out of place tab, select the destination client and the destination instance.

  7. To restore a Dumpbased backupset using parallel jobs, do the following:

    1. For restores for a Dumpbasedbackupset on Linux and Windows servers, in the Number of parallel jobs box, enter the number of parallel jobs to restore the database.

    2. In the Staging path box, enter the location to set the staging path to a local directory.

  8. To stage the global objects file after the restore is complete for a Dumpbased backupset, do the following:

    1. Select the Stage global objects file check box.

    2. To set the staging path for global objects file, in the Staging path box, enter the location in the destination access node.

  9. Click Submit.