Is there any tool that allows to restart PostgreSQL when there is no more connection slots -


is there automated tool allows restart postgresql or kill pending queries on readers when there no more connection slots? problem connections readers in use because of unknown reason (slow query may be) , need quick , dirty solution monitor readers , kill queries when such event occurs. know it's more workaround masking real problem task have write script doing this, pretty sure there tool can use instead. research i've done led me following result: nagios. unfortunately, i'm still waiting ticket processed server support team.

postgresql version 9.4

ref the statistics collector

select pid, query pg_stat_activity waiting='t';

ref function-admin: pg_cancel_backend

select pg_cancel_backend(pid of postgres process);

a simple bash script. pass in paramters command line

#!/bin/bash dbname="test" username="postgres" vartest=`psql -d $dbname -u $username -h localhost -p 5432 -t -c "select  pid pg_stat_activity waiting='f';"` p_var in ${vartest[@]} # admin function please read more on function-admin in postgres documentation  # q_result= `psql -d $dbname -u $username -h localhost -p 5432 -t -c "select pg_cancel_backend('$p_var');"`  # sanitiy check grabs pid , related query  q_result=`psql -d $dbname -u $username -h localhost -p 5432 -t -c "select pid, query  pg_stat_activity  pid='$p_var';"` done

Comments

Post a Comment

Popular posts from this blog

searchKeyword not working in AngularJS filter -

i writing app using angularjs on front end. want search through table word/field; 1 search box everything. according article here: http://hello-angularjs.appspot.com/searchtable can use filter: searchkeyword this. this code, , not working expected. <label>search: <input ng-model="searchkeyword"></label> <table ng-repeat="post in posts | orderby: sort | filter: searchkeyword"> <tr> <td> {{index(post)}} </td> <td> {{post.title}} </td> <td> {{post.author}} </td> <td> {{post.content}} </td> <td> {{post.date | date: "d/m/yyyy"}} </td> </tr> </table> what should do? thank you try this: controller $scope.posts = [ {title:'title one', author:'author one', content: 'content one'}, {title:'title two', author:'author two', content: 'cont...
Read more

sequelize.js - Sequelize: sort by enum cases -

i have model ( article ) field (the name type ) of type enum('source', 'translated') , return 1 article ordered type field. source articles should returned before translated articles. like: article.findone(order: [ { type: [ 'source', 'translated' ] } ]); unfortunately there appears no built-in solution sorting enums. instead have sort by case , couldn't find documentation on how sequelize. what conventional approach here? sorting case hard in sequelize, sort field (the second answer in linked post) should possible: order: sequelize.fn('field', sequelize.col('type'), 'source', 'translated') it's supported mysql far know though
Read more

user interface - how to replace an ongoing process of image capture from another process call over the same ImageLabel in python's GUI TKinter -

i trying use following code create interactive gui changes color-space(hsv, rbg, grayscale etc) on event of button click. display opencv video in tkinter using multiprocessing being new python having problems multiprocessing , attempts on making gui change it's color space on button clicks hangs entire system. on it's implementation highly appreciated. thankyou. below code: import cv2 pil import image,imagetk import tkinter tk import numpy np multiprocessing import process , queue def quit_it(root,process): root.destroy() process.terminate() def black_andwhite(root,process): process.terminate p=process(target=capture_image, args=(5,queue, )) p.start() root.after(0, func=lambda: update_all(root, image_label, queue)) def update_image(image_label, queue): frame = queue.get() = image.fromarray(frame) b = imagetk.photoimage(image=a) image_label.configure(image=b) image_label._image_cache = b root.update() def update_all(root...
Read more