RE: error restoring backup in version 4.4.1

Hi

Command used in 3.6:
C:\Program Files (x86)\pgAdmin 4\v3\runtime\pg_restore.exe --host "localhost" --port "5432" --username "myUserName"
--no-password--role " myRoleName " --dbname "myDB" --verbose "C:\\temp\\DB_ARC~1\\SSEB48~1.BAC 


Command used in 4.1:
C:\Program Files (x86)\pgAdmin 4\v4\runtime\pg_restore.exe --host "localhost" --port "5432" --username " myUserName "
--no-password--role " myRoleName " --dbname "myDB" --verbose "C:\\temp\\DB_ARC~1\\SSEB48~1.BAC" 

Gareth



-----Original Message-----
From: Dave Page [mailto:dpage@pgadmin.org]
Sent: Tuesday, January 22, 2019 12:58 AM
To: Gareth Vaughan <gareth@specialisedstructures.co.nz>
Cc: pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Re: error restoring backup in version 4.4.1

Hi

On Sun, Jan 20, 2019 at 8:57 PM Gareth Vaughan <gareth@specialisedstructures.co.nz> wrote:
>
> 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;

At the top of the dialogue that shows the output, it should show the command that was executed. Can you show us that
forboth cases please? 
It should be something like:

/Library/PostgreSQL/10/bin/pg_dump --file "/Users/dpage/foo.sql"
--host "localhost" --port "5433" --username "postgres" --no-password --verbose --format=c --blobs "postgres"

Thanks.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company