On 03/20/12 06:14, Bèrto ëd Sèra wrote:
>So as a dirty and quick hack to
> make sure our failure filter works I wanted to have an external process
> kill and relaunch the filter from cron each 30 minutes.
>
> Is there anyway I can mark the process running the filter, maybe using
> the update_process_title feature? I'd like to have something I can see
> from a ps command, grep for it and kill -15 it, without wasting our
> scarce resources on one more pg process to use info from pg_stat_activity.
Change your filter so it only runs once; not in a forever loop; then add
the filter to cron to run every minute.
If this new filter continues to freeze; then use pkill to get rid of it.
Hopefully RHEL has a pkill command which works like (ps | grep | kill).