Skip site navigation (1) Skip section navigation (2)

Re: 1.12.1 - cannot dump from older server versions

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 (view raw or flat)
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

In response to

Responses

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2011-02-16 22:45:47
Subject: Re: dynamic results of a PG_Dump or pg_Restore in the list
Previous:From: Doug EasterbrookDate: 2011-02-16 22:13:26
Subject: dynamic results of a PG_Dump or pg_Restore in the list

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group