Using `psql` works only for `plain` format (SQL) database dumps, but we allow other formats in `dump_database`, so it would to good to also support them here using `pg_restore`.