Skip site navigation (1) Skip section navigation (2)

Re: Setting the process title, or can I?

From: Frank Bax <fbax(at)sympatico(dot)ca>
To:
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Setting the process title, or can I?
Date: 2012-03-20 11:26:29
Message-ID: 4F686965.5060306@sympatico.ca (view raw or flat)
Thread:
Lists: pgsql-sql
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).

In response to

Responses

pgsql-sql by date

Next:From: Bèrto ëd SèraDate: 2012-03-20 11:33:26
Subject: Re: Setting the process title, or can I?
Previous:From: Bèrto ëd SèraDate: 2012-03-20 10:14:00
Subject: Setting the process title, or can I?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group