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
isstill there. After starting the backup parts of the desktop are being refreshed rapidly - not just the pgAdmin and
thebackup dialogue window. Even the mouse cursor and the icon of another running program in the task bar 'flashed'
afterstarting the backup and switching the active window. The backup eventually completes, but takes much longer for
thesame 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? Which version of Windows did you test it on?
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,
Peter
