The Restore process of PostgreSQL database is a two-step process. First, you need to download the database backup to a local machine using Xopero application. In the second step, the PostgreSQL database will be restored to a PostgreSQL server using pgAdmin or psql.
Restoring the database file from a backup
To download the PostgreSQL database backup run the Xopero application and go to the Restoring tab. All backed up databases will be available in the PostgreSQL branch.
Expand the branch and mark the checkbox next to the database which has to be restored. Then click on the Restore selected button.
To restore previous version of the database right click on its name and from context menu select Show file versions.
The file restore settings window will be displayed where you have to select the location where the database backup file will be saved. From this directory it also will be restored to the PostgreSQL database server.
Database restore using pgAdmin
To restore previously downloaded database backup, you have to start pgAdmin tool and connect with the database server.
When the connection is established, expand the Databases branch, right-click on the database, where the backup should be restored and click Restore….
In new window, enter path to previously restored database file in the Filename filed and click Restore.
Database restore using command prompt
To restore PostgreSQL database to destination server from previously restored file, open command prompt. Then go to psql location and enter: psql –f „path to a file” database name user, where:
- Path to a file – is a path of database file restored using Xopero application,
- Database name – name of the database, where the backup will be restored,
- User - PostgreSQL user.
The psql tool will ask for PostgreSQL user's password. If a valid password is entered, the restore process will be launched.