Re: PGAdmin3 runs pg_dump etc

On 8/16/2013 4:47 AM, Dave Page wrote:
> On Thu, Aug 15, 2013 at 11:56 PM, Stephen Cook <sclists@gmail.com> wrote:
>> Hello list!
>>
>> I recently noticed that PGAdmin III (v 1.16.1) is kind of slow starting up
>> (it didn't use to be), and in fact one time I wasn't even sure if I clicked
>> on the icon properly to start it. I opened the Task Manager (I run Windows 7
>> Ultimate SP1) and saw pg_restore was running, then the process vanished and
>> PGAdmin finally opened.
>>
>> I did it again, this time watching the process list, and it looks like when
>> I start PGAdmin it automatically runs pg_dump, pg_dumpall, and then
>> pg_restore in the background before showing the splash screen and actually
>> starting.
>>
>> I'm assuming that as my local development databases grow, it is taking
>> longer to do all this, which is why I never noticed until now.
> No, that won't make any difference. It runs those utilities with the
> --version flag to check what version they are so it knows how to call
> them and what servers they will be compatible with. No attempt is made
> to connect to any databases or anything.
>
> I suppose it could slow down if you've replaced any of those utilities
> with scripts of the same name that do something else - i.e. a pg_dump
> script that calls the real pg_dump with the right parameters to
> execute a backup. That doesn't seem like something anyone would do
> though (and certainly wouldn't be advisable).
>
> Probably the best bet would be to enable debug logging and then check
> the timestamps to see what appears to be taking time.

Shortly after sending that email *everything* became terribly slow, and 
soon after my hard drive gave up the ghost. I rebuilt my PC and 
everything is just fine. At least I learned a thing.

Sorry for the noise on the list!


-- Stephen