Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] After upgrade to 9.6: waiting column does not exist - Mailing list pgsql-general

From Johann Spies
Subject Re: [GENERAL] After upgrade to 9.6: waiting column does not exist
Date
Msg-id CAGZ55DQuQiRTCbgTnky1aDfnEB-Zyv0_q1dWENnF0YMio9teAA@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] After upgrade to 9.6: waiting column does not exist  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-general
Tree view


On 9 December 2016 at 10:13, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:

On 09/12/2016 10:04, John R Pierce wrote:

are you running some sort of monitoring software thats periodically looking at pg_stat_activity ?   whatever query its doing needs to be rewritten to take into account the pg_stat_activity changes in 9.6


Thanks John.  I see munin queries the 'waiting'  column.

Also It would help to modify your log line prefix (log_line_prefix) to include client's address, PID, and application name.


Thanks for the hint Achilleas.  It makes a lot of sense.

Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

pgsql-general by date:

Previous
From: Qiu Xiafei
Date:
Subject: [GENERAL] Is is safe to use SPI in multiple threads?
Next
From: Shreeyansh Dba
Date:
Subject: [GENERAL] Re: [ADMIN] Would like to below scenario is possible for gettingpage/block corruption