Re: Why do backups take so long?

On 07/03/2015 00:15, Jan-Peter Seifert wrote:
> Am 06.03.2015 um 19:33 schrieb Raymond O'Donnell:
>
>> pgAdmin just uses pg_dump [1] to do the actual backup, so it would be
>> interesting to run pg_dump directly at the command line to see if the
>> same behaviour manifests itself.
>
> There's nothing interesting about that, because this behaviour is really
> old news:
> http://www.postgresql.org/message-id/20110103123027.118630@gmx.net
>
> Running pg_dump from command line directly works without problems.
>
> Makes me wonder whether the Windows version of pgAdmin is still being
> tested on xp only.

It works fine for me - Windows 7 Home on my laptop, 64-bit, with pgAdmin
III 1.20.0. The interface flashes as described in the message linked
above - presumably as pgAdmin spawns and interacts with a new process
for pg_dump - but the entire operation takes no more than 5s with a tiny
database.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie