Re: run function on server restart

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: run function on server restart
Date: 2012-08-24 21:52:30
Message-ID: 5037F79E.8070307@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 08/24/2012 03:46 PM, John D. West wrote:
> I have various background processes outside of postgres that need to be
> killed and restarted after the server reboots.
>
> -- John
>
>
> On Fri, Aug 24, 2012 at 2:29 PM, Kevin Grittner
> <Kevin(dot)Grittner(at)wicourts(dot)gov <mailto:Kevin(dot)Grittner(at)wicourts(dot)gov>> wrote:
>
> "John D. West" <john(dot)d(dot)west(at)asu(dot)edu <mailto:john(dot)d(dot)west(at)asu(dot)edu>> wrote:
>
> > Sometimes the server process crashes and restarts, usually when I
> > run some large calculations that eat up all available memory.
>
> You might want to reconfigure to avoid that.
>
> > Is there any way to detect this and run a cleanup routine when it
> > happens?
>
> What is it that are you trying to clean up?
>
> -Kevin
>
>
Seems it would be the responsibility of the dependent processes to
recognize pg went away, and clean themselves up (as only they know how
to do).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2012-08-24 21:56:34 Re: run function on server restart
Previous Message Mathieu Fenniak 2012-08-24 21:48:02 fast-archiver tool, useful for pgsql DB backups