From: | "Gareth Vaughan" <gareth(at)specialisedstructures(dot)co(dot)nz> |
---|---|
To: | "'Dave Page'" <dpage(at)pgadmin(dot)org> |
Cc: | "'pgadmin-support lists(dot)postgresql(dot)org'" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | RE: error restoring backup in version 4.4.1 |
Date: | 2019-01-21 22:18:33 |
Message-ID: | 044a01d4b1d7$40db0ed0$c2912c70$@specialisedstructures.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(at)pgadmin(dot)org]
Sent: Tuesday, January 22, 2019 12:58 AM
To: Gareth Vaughan <gareth(at)specialisedstructures(dot)co(dot)nz>
Cc: pgadmin-support lists.postgresql.org <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: error restoring backup in version 4.4.1
Hi
On Sun, Jan 20, 2019 at 8:57 PM Gareth Vaughan <gareth(at)specialisedstructures(dot)co(dot)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 for both 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
From | Date | Subject | |
---|---|---|---|
Next Message | joeg3333 | 2019-01-22 02:37:29 | Re: pgAgent v4.0.0 Released |
Previous Message | Ray O'Donnell | 2019-01-21 21:13:02 | Re: pgAdmin auto-starting |