| From: | Johann Spies <johann(dot)spies(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: After upgrade to 9.6: waiting column does not exist |
| Date: | 2016-12-09 08:55:12 |
| Message-ID: | CAGZ55DQuQiRTCbgTnky1aDfnEB-Zyv0_q1dWENnF0YMio9teAA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 9 December 2016 at 10:13, Achilleas Mantzios <
achill(at)matrix(dot)gatewaynet(dot)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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shreeyansh Dba | 2016-12-09 09:56:14 | Re: [ADMIN] Would like to below scenario is possible for getting page/block corruption |
| Previous Message | Qiu Xiafei | 2016-12-09 08:52:05 | Is is safe to use SPI in multiple threads? |