Hi pgAdmin support
Thanks for the new version. I've tried updating but I've encountered a small error.
I'm currently running postgres 10.4. I generate backups with something like:
pg_dump.exe -Fc -U myRoleName -h localhost -p 5432 --dbname=myDb --file=dbBackup.backup
To restore a backup to a new db in pgAdmin
1) create a new db via the Create - Database dialogue accessible from the browser panel
2) right click on the newly created db and select restore
3) navigate to the backup file, select the rolename and click restore
in pgadmin 4.3.6
this process completes successfully
in pgadmin 4.4.1 this fails with
Failed (exit code 1)
here's the error from the detailed report:
pg_restore: creating SCHEMA "public"
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 3; 2615 2200 SCHEMA public myRoleName
pg_restore: [archiver (db)] could not execute query: ERROR: schema "public" already exists
Command was: CREATE SCHEMA public;
Thanks, Gareth