OK, In step (1), when you're creating the database. Can you check that is selected template0 in both. (3.6 and 4.1)
Obtener Outlook para Android<https://aka.ms/ghei36> ________________________________ From: Gareth Vaughan <gar...@specialisedstructures.co.nz> Sent: Sunday, January 20, 2019 10:06:38 PM To: 'Ricardo Martin Gomez'; pgadmin-support@lists.postgresql.org Subject: RE: error restoring backup in version 4.4.1 Hi Ricardo Thanks for looking at this so quickly! I didn’t run a second restore. I only used this to restore the backup to a new db. 0) select Delete/Drop existing myDB from the browser panel 1) create a new db named myDB via the Create - Database dialogue accessible from the browser panel 2) right click on the new myDB and select restore 3) navigate to the backup file, select the rolename and click restore That process generates an error in 4.1 but works fine in 3.6 Gareth From: Ricardo Martin Gomez [mailto:rimartingo...@hotmail.com] Sent: Monday, January 21, 2019 1:59 PM To: pgadmin-support@lists.postgresql.org; Gareth Vaughan <gar...@specialisedstructures.co.nz> Subject: Re: error restoring backup in version 4.4.1 Hi Garreth, When you run second restore. Is the target database recreated recently? Obtener Outlook para Android<https://aka.ms/ghei36> ________________________________ From: Gareth Vaughan <gar...@specialisedstructures.co.nz<mailto:gar...@specialisedstructures.co.nz>> Sent: Sunday, January 20, 2019 5:57:22 PM To: pgadmin-support@lists.postgresql.org<mailto: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
