Re: [GENERAL] After upgrade to 9.6: waiting column does not exist

Поиск
Список
Период
Сортировка
От Johann Spies
Тема Re: [GENERAL] After upgrade to 9.6: waiting column does not exist
Дата
Msg-id CAGZ55DQuQiRTCbgTnky1aDfnEB-Zyv0_q1dWENnF0YMio9teAA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] After upgrade to 9.6: waiting column does not exist  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-general
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: Qiu Xiafei
Дата:
Сообщение: [GENERAL] Is is safe to use SPI in multiple threads?
Следующее
От: Shreeyansh Dba
Дата:
Сообщение: [GENERAL] Re: [ADMIN] Would like to below scenario is possible for gettingpage/block corruption