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? 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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
