Re: restore bug of pgadminIII 1.20.0

From: Neel Patel <neel(dot)patel(at)enterprisedb(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: YuanyuanLiu <liuyuanyuangogo(at)gmail(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: restore bug of pgadminIII 1.20.0
Date: 2015-12-30 11:07:55
Message-ID: CACCA4P1grQUTzni5ftMDx1kvjErsKarCe8e6x-=cmMRreVsGwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Dave,

Sure. I will look into this issue and share the analysis/fix.

Thanks,
Neel Patel

On Wed, Dec 30, 2015 at 4:33 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Neel, can you look at this please?
>
> Thanks.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK:http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> On 30 Dec 2015, at 08:14, YuanyuanLiu <liuyuanyuangogo(at)gmail(dot)com> wrote:
>
> Hi, I found a bug of restore of pgadminIII v1.20.0 , which I installed by
> postgresql-9.4 Graphical installer for windows 32bit).
>
> This is my test example: I tried use pgadminIII to restore table A1 in
> schema publicA in database Vvv1.
> then it failed and I got the message:
> D:\Program Files (x86)\PostgreSQL\9.4\bin>pg_restore.exe --host localhost
> --port
> 5433 --username "postgres" --dbname "Vvv1" --no-password --data-only
> --table \"A1\" --schem
> a \"publicA\" --verbose "C:\Users\Yuanyuan\Desktop\1"
> ....
>
> I found the table and schema name format is wrong, the right way is like
> the
> follwing. and success to restore my table by execute commands like the
> following:
> D:\Program Files (x86)\PostgreSQL\9.4\bin>pg_restore.exe --host localhost
> --port
> 5433 --username "postgres" --dbname "Vvv1" --no-password --data-only
> --table "A1" --schema
> "publicA" --verbose "C:\Users\Yuanyuan\Desktop\1"
>
> I don't know whether anyone has fixed this problem, so I write this to you!
> please have a look!
> Thanks and regards!
>
> Holiday Liu
>
>
>
>
>
>
> --
> View this message in context:
> http://postgresql.nabble.com/restore-bug-of-pgadminIII-1-20-0-tp5879508.html
> Sent from the PostgreSQL - pgadmin support mailing list archive at
> Nabble.com <http://nabble.com>.
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>
>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2016-01-04 09:24:14 Re: Re: Bug#808924: pgadmin3 uses deprecated find -perm +xxx syntax, please switch to find -perm /+++
Previous Message Dave Page 2015-12-30 11:03:49 Re: restore bug of pgadminIII 1.20.0