Re: run function on server restart

From: Chris Angelico <rosuav(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: run function on server restart
Date: 2012-08-25 06:40:23
Message-ID: CAPTjJmrUUHqgjoABJdzXF20bPD_7zZzf-3ZPM+w=dMkfTbZRnA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Aug 25, 2012 at 8:25 AM, John D. West <john(dot)d(dot)west(at)asu(dot)edu> wrote:
> I *think* my independent processes are cleaning up in that they supposedly
> abort themselves if they lose db connection, but on restart there is a table
> of pid's I'd like to (1) make sure all of the processes are really dead,
> killing any who aren't (2) reset flags in a table showing the status of
> those process, and (3) clear out the pid list so I can restart the
> processes.

Hmm. I wonder is there a way to not use a table for this. What's the
status flagging intended to do? Can it be accomplished with, perhaps,
locks?

ChrisA

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2012-08-25 08:41:31 Re: FETCH in subqueries or CTEs
Previous Message John D. West 2012-08-24 22:25:34 Re: run function on server restart