From: Frank Bax <fbax@sympatico.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: Setting the process title, or can I?
Date: Tue, 20 Mar 2012 07:26:29 -0400
Message-ID: <4F686965.5060306@sympatico.ca> (raw)
In-Reply-To: <CAKwGa_9MOQ1zsFaXcdyaCqbPUNDXhMHPOzpo1SSxME8a5YJ2UA@mail.gmail.com>
References: <CAKwGa_9MOQ1zsFaXcdyaCqbPUNDXhMHPOzpo1SSxME8a5YJ2UA@mail.gmail.com>
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).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: fbax@sympatico.ca
Subject: Re: Setting the process title, or can I?
In-Reply-To: <4F686965.5060306@sympatico.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox