Re: run function on server restart - Mailing list pgsql-general

From Chris Angelico
Subject Re: run function on server restart
Date
Msg-id CAPTjJmrUUHqgjoABJdzXF20bPD_7zZzf-3ZPM+w=dMkfTbZRnA@mail.gmail.com
Whole thread Raw
In response to Re: run function on server restart  ("John D. West" <john.d.west@asu.edu>)
Responses Re: run function on server restart  ("John D. West" <john.d.west@asu.edu>)
List pgsql-general
On Sat, Aug 25, 2012 at 8:25 AM, John D. West <john.d.west@asu.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


pgsql-general by date:

Previous
From: "John D. West"
Date:
Subject: Re: run function on server restart
Next
From: Craig Ringer
Date:
Subject: Re: FETCH in subqueries or CTEs