From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | rleonanaya <rogelio(at)blocknetworks(dot)com(dot)mx> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: 1.12.1 - cannot dump from older server versions |
Date: | 2011-02-16 22:42:52 |
Message-ID: | 4D5C52EC.2040402@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Le 16/02/2011 19:41, rleonanaya a écrit :
>
>
> Guillaume Lelarge-3 wrote:
>>
>> Le 12/01/2011 18:23, Jan-Peter(dot)Seifert(at)gmx(dot)de a écrit :
>>> Hello,
>>>
>>> -------- Original-Nachricht --------
>>>> Datum: Tue, 11 Jan 2011 23:52:11 +0100
>>>> Von: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
>>>> An: Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)de>
>>>> CC: pgadmin-support(at)postgresql(dot)org
>>>> Betreff: Re: [pgadmin-support] 1.12.1 - cannot dump from older server
>>>> versions
>>>
>>> I've compared the calls made by both versions of pgAdmin:
>>>
>>> 1.10.5
>>> C:\Program Files (x86)\PostgreSQL\8.4\bin\pg_dump.exe --host localhost
>>> --port 5432 --username postgres --format custom --blobs --verbose --file
>>> "D:\db.backup" db
>>>
>>>
>>> 1.12.2:
>>> C:\Program Files (x86)\PostgreSQL\8.4\bin\pg_dump.exe --host localhost
>>> --port 5432 --username "postgres" --format custom --blobs --verbose
>>> --file "D:\db.backup" db
>>>
>>> There's just a slight difference in that the username gets quoted by
>>> 1.12.2
>>>
>> Yeah, that's a bug of 1.12.2, but I'm quite sure it doesn't explain the
>> time difference. Bug fixed BTW.
>> --
>> Guillaume
>>
>
> I'm having the same behavior of Peter...
>
> My environment is:
> - PostgreSQL 9.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (Debian
> 4.3.2-1.1) 4.3.2, 32-bit
> - PgAdmin III v.1.12.2 on Win 7 64 bits
> - A 152 MB Database in UTF8 encoding
> - use backup of pgAdmin with defaults (any changes made)
>
>
> What I can see in the task manager of Win 7 is that the command pg_dump runs
> by some seconds and then it closes, then another time it runs by some
> seconds and then it closes... I think this is what makes the refreshing look
> of all the desktop and the slow pg_dump process.
>
> The only thing that I can assume is that the pg_dump is being made table by
> table instead of the entire database or something like that, cause, this
> started after in the PgAdmin has delivered the "object" selector
> functionality in the backup wizard.
>
pgAdmin launches pg_dump only once even when you ask it to dump part of
the database, table by table.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2011-02-16 22:45:47 | Re: dynamic results of a PG_Dump or pg_Restore in the list |
Previous Message | Doug Easterbrook | 2011-02-16 22:13:26 | dynamic results of a PG_Dump or pg_Restore in the list |