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:
1. 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
2. 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ć
