RE: error restoring backup in version 4.4.1 - Mailing list pgadmin-support

From: Ricardo Martin Gomez [mailto:rimartingomez@hotmail.com]
Sent: Monday, January 21, 2019 1:59 PM
To: pgadmin-support@lists.postgresql.org; Gareth Vaughan <gareth@specialisedstructures.co.nz>
Subject: Re: error restoring backup in version 4.4.1

Obtener Outlook para Android

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