Re: run function on server restart
| От | John D. West |
|---|---|
| Тема | Re: run function on server restart |
| Дата | |
| Msg-id | CACYo-=J0o+9tQM4fWhpM1_g_0nsMLvU+KdsGOqa+Ddb6DbYDrw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: run function on server restart ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) |
| Ответы |
Re: run function on server restart
|
| Список | pgsql-general |
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.
-- John
Apparently the answer to my original question is "no, there is no way to run a function at postgres startup." The question on monitoring apps intrigues me, however. What can they do, and what is available?
Thanks!
-- John
On Fri, Aug 24, 2012 at 3:56 PM, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
> I have various background processes outside of postgres that needAll of our applications are coded such that when they have an error
> to be killed and restarted after the server reboots.
on a database connection, they check for a serialization failure or
a broken connection; if they find either they retry the database
transaction. That would be my first recommendation. (Well, second,
after identifying the causes of server crashes and fixing them.)
Are you running any monitoring applications which could trigger what
you want?
-Kevin
В списке pgsql-general по дате отправления: