Re: 1.12.1 - cannot dump from older server versions

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