Re: 1.12.1 - cannot dump from older server versions

Hello,

unfortunately this issue isn't resolved yet.

If I dump a database on a ( local ) PostgreSQL 8.4 ( 32-bit ) server using pgAdmin 1.12 and later I get massive
blinkingand the whole system ( Windows 64-bit ) seems to be slowed down more than usual. The dumping takes a very long
timetoo. It doesn't matter whether I use pgdump 8.4 or 9.1.
 
If I use pgAdmin 1.10.5 instead everything seems fine - at least no blinking and dumping doesn't take much longer.
I use the binaries from the server installations ( 8.3 & 8.4 32-bit and 9.0 & 9.1 64-bit ).
Didn't you change the wxWidget-library in 1.12?

Could you look into this again, please?

Thank you very much,

Peter

-------- Original-Nachricht --------
> Datum: Wed, 16 Feb 2011 23:42:52 +0100
> Von: Guillaume Lelarge <guillaume@lelarge.info>
> An: rleonanaya <rogelio@blocknetworks.com.mx>
> CC: pgadmin-support@postgresql.org
> Betreff: Re: [pgadmin-support] 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.Seifert@gmx.de a écrit :
> >>> Hello,
> >>>
> >>> -------- Original-Nachricht --------
> >>>> Datum: Tue, 11 Jan 2011 23:52:11 +0100
> >>>> Von: Guillaume Lelarge <guillaume@lelarge.info>
> >>>> An: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
> >>>> CC: pgadmin-support@postgresql.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
> 
> -- 
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support

-- 
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de