Re: PGAdmin3 runs pg_dump etc

On Thu, Aug 15, 2013 at 11:56 PM, Stephen Cook <sclists(at)gmail(dot)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.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company