Backup restoration is a common function of RDS-PostgreSQL. The objects can be databases, schema, tables, and other objects with storage significance. This function can be implemented through a visual interface by pgAdmin. The text below uses the backup restoration of a database as an example.
Backup
Open the database Server connection, select the specified database, and right-click to select Backup... The Backup option box appears, as shown in the figure below:
Each of these meanings is:
General: Backup metadata (mandatory), including generated filename, backup method, encoding method, etc.
Data/Objects: Select the backup data range, including whether to save only data or whether to save only schema. You need to select based on your needs.
Options: Other options, including whether to select OID, whether to select DDL operation, etc. You need to select based on your needs.
Click Backup, and the background will start to back up. The Backup file exists in the Filename filled in at the beginning. The execution result is displayed in the bottom right corner when the operation ends.
Restore
The restoration and backup operations of pgAdmin are inverse, which are similar to each other. Open the database Server connection, select the specified database, and right-click Restore.... The Backup option box appears.
General: The files used for recovering the backup, including the format of the restoration file, file name, etc.
Data/Objects: Similar to backup, that is, whether to recover an item of data from a backup file.
Options: Similar to backup, that is, whether to select some specific options for the restoration operation, such as whether to continue the restoration if restoring a statement fails.
Click Restore, and the background will start to restore from the given file. The execution result is displayed in the bottom right corner when the operation ends.