Re: error restoring backup in version 4.4.1

Поиск
Список
Период
Сортировка
От Ricardo Martin Gomez
Тема Re: error restoring backup in version 4.4.1
Дата
Msg-id SC1P15201MB2304D83D3362350871683478A39F0@SC1P15201MB2304.LAMP152.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на error restoring backup in version 4.4.1  ("Gareth Vaughan" <gareth@specialisedstructures.co.nz>)
Ответы RE: error restoring backup in version 4.4.1  ("Gareth Vaughan" <gareth@specialisedstructures.co.nz>)
Список pgadmin-support
Hi Garreth,
When you run second restore.
Is the target database recreated recently?


From: Gareth Vaughan <gareth@specialisedstructures.co.nz>
Sent: Sunday, January 20, 2019 5:57:22 PM
To: pgadmin-support@lists.postgresql.org
Subject: error restoring backup in version 4.4.1
 

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 по дате отправления:

Предыдущее
От: "Gareth Vaughan"
Дата:
Сообщение: error restoring backup in version 4.4.1
Следующее
От: "Gareth Vaughan"
Дата:
Сообщение: RE: error restoring backup in version 4.4.1