Skip site navigation (1) Skip section navigation (2)

Re: Server status hanging on OS X

From: MattK <mksql(at)yahoo(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Server status hanging on OS X
Date: 2012-03-20 19:53:03
Message-ID: 1332273183.1933.YahooMailNeo@web110804.mail.gq1.yahoo.com (view raw or flat)
Thread:
Lists: pgadmin-support
With reduced logging, I still get regular periods of unresponsiveness, even when Don't Refresh is set in the monitor window.

Does PgAdmin look at all logs in pg_log, or only the current one?

Is there a way to disable log monitoring, as a test for the cause of this issue?





>________________________________
> From: MattK <mksql(at)yahoo(dot)com>
>To: Dave Page <dpage(at)pgadmin(dot)org> 
>Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> 
>Sent: Tuesday, March 20, 2012 12:54 PM
>Subject: Re: [pgadmin-support] Server status hanging on OS X
> 
>
>Very likely. I had some large log files (>1GB). Setting the log rotation size to 100MB seems to have brought my the server status monitor back to life.
>
>
>Thanks!
>
>
>
>>________________________________
>> From: Dave Page <dpage(at)pgadmin(dot)org>
>>To: MattK <mksql(at)yahoo(dot)com> 
>>Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> 
>>Sent: Tuesday, March 20, 2012 4:47 AM
>>Subject: Re: [pgadmin-support] Server status hanging on OS X
>> 
>>On Mon, Mar 19, 2012 at 7:26 PM, MattK <mksql(at)yahoo(dot)com> wrote:
>>> I can reproduce the issue in v1.14.0 and v1.14.1 as well. This does not
>>> happen on all of my Postgres instances, the one I am trying to actively
>>> monitor that exhibits the problem is through the ssh port forward.
>>>
>>> Running ssh -v -L  5433:<server>:5432 <user>@<server> seems to show a
>>> constant traffic stream, with messages like this repeating:
>>>
>>> debug2: channel 5: window 1997018 sent adjust 100134
>>> debug2: channel 5: window 1997018 sent adjust 100134
>>> debug2: channel 5: window 1997018 sent adjust 100134
>>> debug2: channel 5: window 1997018 sent adjust 100134
>>> debug2: channel 5: window 1997018 sent adjust 100134
>>> debug2: channel 5: window 1997018 sent adjust 100134
>>
>>Could it be trying to load a very
 large log file?
>>
>>-- 
>>Dave Page
>>Blog: http://pgsnake.blogspot.com
>>Twitter: @pgsnake
>>
>>EnterpriseDB UK: http://www.enterprisedb.com
>>The Enterprise PostgreSQL Company
>>
>>
>>
>
>

In response to

Responses

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2012-03-20 20:13:26
Subject: Re: Server status hanging on OS X
Previous:From: MattKDate: 2012-03-20 16:54:18
Subject: Re: Server status hanging on OS X

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group