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