Skip site navigation (1) Skip section navigation (2)

Re: running script on server shutdown (TODO)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: running script on server shutdown (TODO)
Date: 2005-12-10 20:06:44
Message-ID: 23245.1134245204@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr> writes:
> I've written a small patch for following TODO item:
>   Add GUC variable to run a command on database
>   panic or smart/fast/immediate shutdown.

I'm not sure why this is in TODO; it's a stupid if not outright
dangerous idea.  Quite aside from any security considerations,
the time the script takes is taken away from the time available
to shut down the database before the kernel takes matters into
its own hands.

Besides, what is the point?  Whatever you need to do can be incorporated
into the initscript you use to start up or shut down the postmaster.
I see no need for this functionality to be inside the postmaster.

			regards, tom lane

In response to

Responses

pgsql-patches by date

Next:From: Andrew DunstanDate: 2005-12-10 22:47:44
Subject: Re: running script on server shutdown (TODO)
Previous:From: Volkan YAZICIDate: 2005-12-10 19:36:20
Subject: running script on server shutdown (TODO)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group