error restoring backup in version 4.4.1

From: "Gareth Vaughan" <gareth(at)specialisedstructures(dot)co(dot)nz>
To: <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: error restoring backup in version 4.4.1
Date: 2019-01-20 20:57:22
Message-ID: 017201d4b102$bf8b85f0$3ea291d0$@specialisedstructures.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Ricardo Martin Gomez 2019-01-21 00:58:56 Re: error restoring backup in version 4.4.1
Previous Message François Valenduc 2019-01-20 20:34:43 Re: KeyError: 'browser.forgot_password'