error restoring backup in version 4.4.1

Поиск
Список
Период
Сортировка
От Gareth Vaughan
Тема error restoring backup in version 4.4.1
Дата
Msg-id 017201d4b102$bf8b85f0$3ea291d0$@specialisedstructures.co.nz
обсуждение исходный текст
Ответы Re: error restoring backup in version 4.4.1  (Ricardo Martin Gomez <rimartingomez@hotmail.com>)
Re: error restoring backup in version 4.4.1  (Dave Page <dpage@pgadmin.org>)
Список 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

 

 

 

В списке pgadmin-support по дате отправления:

Предыдущее
От: François Valenduc
Дата:
Сообщение: Re: KeyError: 'browser.forgot_password'
Следующее
От: Ricardo Martin Gomez
Дата:
Сообщение: Re: error restoring backup in version 4.4.1