Database Restore

To restore a database of a PostgreSQL DB instance from an image-level backup, Veeam Backup for AWS performs the following steps:

1. [Applies only if you perform restore from an archived backup] Retrieves data from the archived restore point.
2. Deploys a worker instance in an AWS Region in which DB instance that will host the restored databases resides in an AWS account to which the instance belongs — that is, the production AWS account.

By default, Veeam Backup for AWS selects the most appropriate network settings of AWS Regions in production accounts. However, you can add specific worker configurations. For more information on worker instances, see Managing Worker Configurations.

2. Creates 2 security groups that are associated with the target DB instance and worker instance to allow direct network traffic between the resources. The security group associated with the target instance allows inbound traffic through opened on the instance port only from the worker instance, whereas the security group associated with the worker instance allows outbound traffic through opened on the instance port only to the target instance.
3. Uses the worker instance to retrieve dumps, triggers and stored procedures from a backup file stored in the target backup repository.
4. Uses PostgreSQL capabilities to restore the PostgreSQL databases to the specified DB instance.

5. Removes the worker instance and 2 created security groups from AWS.

To learn how to restore databases of a DB instance from an image-level backup, see RDS Restore.