Re: run function on server restart

Поиск
Список
Период
Сортировка
От Chris Angelico
Тема Re: run function on server restart
Дата
Msg-id CAPTjJmrUUHqgjoABJdzXF20bPD_7zZzf-3ZPM+w=dMkfTbZRnA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: run function on server restart  ("John D. West" <john.d.west@asu.edu>)
Ответы Re: run function on server restart
Список 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 по дате отправления:

Предыдущее
От: "John D. West"
Дата:
Сообщение: Re: run function on server restart
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: FETCH in subqueries or CTEs