Re: 1.12.1 - cannot dump from older server versions

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.

Hopefully this could help.

Rogelio
http://www.blocknetworks.com.mx

--
View this message in context: http://postgresql.1045698.n5.nabble.com/1-12-1-cannot-dump-from-older-server-versions-tp3295491p3388207.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.