A pgAdmin4 feature I have always wanted is having some "restore" command in the server or Databases context menu. That would make restoring databases much easier, especially during development and testing when various changes occur frequently.
Currently there are two options for restoring databases in pgAdmin from custom format backups, both a bit inconvenient:
- Manually create database with the required name, then use Restore from its context menu; this has more steps than needed - there is no need to create the database manually
- Use Restore from any existing database's menu, enabling the "CREATE DATABASE" option; faster, but potentially dangerous or inconvenient if one manages to overwrite the other database by mistake
For someone frequently dumping and restoring various databases from within pgAdmin4 while also doing development in it, the new menu item would be quite useful. Alternatively, it could be added as an option in the Create / Database menu; something like "Create Database from backup".
--
Kind Regards,
Arni Kromić