Re: 1.12.1 - cannot dump from older server versions

Le 11/01/2011 23:31, Jan-Peter Seifert a écrit :
> Hello,
>
> Am 06.01.2011 12:11, schrieb Guillaume Lelarge:
>
>>>>> I have problems dumping databases on older server versions (e.g. 8.4)
>>>> with pgAdmin 1.12.1. It seems to enter an endless loop after clicking 'OK'.
>>>> It doesn't matter whether the binaries path points to v8.4 or v9.0. Dumping
>>>> from 9.0 works fine.
>>>>> I have 8.3 (pg_installer, two instances/services), 8.4 and 9.0 installed
>>>> on Windows xp.
>>>>>
>>>>
>>>> Do you have any error message? I have no issue with the dump/restore
>>>> facility with 1.12 release.
>>>
>>> Sorry for replying this late. I've tested it with 1.12.2 on a different system again (Windows 7, 64-Bit). The issue is still there. After starting the backup parts of the desktop are being refreshed rapidly - not just the pgAdmin and the backup dialogue window. Even the mouse cursor and the icon of another running program in the task bar 'flashed' after starting the backup and switching the active window. The backup eventually completes, but takes much longer for the same database on a 8.4 server - about a minute instead of 8 seconds when using pgAdmin 1.10.5. Could check this again, please?
>>>
>>
>> There is not much to check. As soon as you click the Backup button,
>> pgAdmin launches pg_dump and everything is donc by this tool. If you
>> have an issue afterwards, it's not related to pgAdmin.
>>
>> Moreover, I can't reproduce the fact that it takes more time to dump an
>> 8.4 database with 9.0 pg_dump.
>
> Thank you very much for checking again.
>
> It's just strange that I'm not the only one experiencing this behaviour
> at work. If I find a system without this behaviour or a hint at the
> reason I'll post again.
> It looks as if the backup window is being refreshed repeatedly.
> Did you use the server's binaries as I did or those packaged with
> pgAdmin?

The server's one.

> Which version of Windows did you test it on?

Windows XP.

> I also had added the server's binaries to the environmental variable
> PATH in the past - pgAdmin seems to correctly(?) call the version of
> PostgreSQL 8.4 though.
>
> Thank you very much,
>

--
Guillaume
http://www.postgresql.fr
http://dalibo.com