Backups of Postgres databases are created using the pg_dump
command that can output a variety of formats. By default, backups are created as plain text SQL scripts, but a compressed custom PostgreSQL format is more efficient. Webmin helps you to create backups in both of these formats as well as in the TAR
format.
The method of restoring your database will depend on the file format chosen during backup. If you chose the plain SQL text format, then simply running your backup script will restore the database. Take a look at the recipe, Execute custom SQL commands, for more information.
If you chose the custom archive or TAR
file format, you should use the procedure described in this recipe.