Re: delete a file everytime pg server starts/crashes

That seems like an odd requirement and I don't think PostgreSQL can do
it itself,
because if postgresql should crash properly then the process that should
write/remove that file would also crash

The simplest way would be to write a cronjob that connects to the
database and does a simple query to see if things are ok,
and act accordingly. But cronjobs cannot be executed more than once a
miunute so there would be a considerable delay.

If you need faster responses you may need to write a custom deamon or
use something like supervisord to manage a long polling script.

I get the feeling there must be a more elegant solution to whatever your
problem is though...

On 2017-10-05 16:04, athinivas wrote:
> Hi,
>
> I'm having a requirement to delete a file in system whenever pg server
> is
> started/crashed. Any idea?
>
> Thanks,
> Athi
>
>
>
> --
> Sent from:
> http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html