On Sun, Jun 23, 2013 at 01:55:19PM +0900, MauMau wrote:
From: Robert Haas robertmh...@gmail.com
On Fri, Jun 21, 2013 at 10:02 PM, MauMau maumau...@gmail.com wrote:
I'm comfortable with 5 seconds. We are talking about the interval
between
sending SIGQUIT to the children and then sending
On 2013-06-21 23:19:27 -0400, Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
On Fri, Jun 21, 2013 at 5:44 PM, Tom Lane t...@sss.pgh.pa.us wrote:
The traditional theory has been that that would be less robust, not
more so. Child backends are (mostly) able to carry out queries
On 2013-06-21 16:56:57 -0400, Alvaro Herrera wrote:
What we could do to improve the robustness a bit - at least on linux -
is to prctl(PR_SET_PDEATHSIG, SIGKILL) which would cause children to be
killed if the postmaster goes away...
This is an interesting idea (even if it has no
On Fri, Jun 21, 2013 at 11:19 PM, Tom Lane t...@sss.pgh.pa.us wrote:
I think that's the Tom Lane theory. The Robert Haas theory is that if
the postmaster has died, there's no reason to suppose that it hasn't
corrupted shared memory on the way down, or that the system isn't
otherwise heavily
On 2013-06-20 22:36:45 -0400, Alvaro Herrera wrote:
Noah Misch escribió:
On Thu, Jun 20, 2013 at 12:33:25PM -0400, Alvaro Herrera wrote:
MauMau escribi?:
Here, reliable means that the database server is certainly shut
down when pg_ctl returns, not telling a lie that I shut down the
Andres Freund escribió:
On 2013-06-20 22:36:45 -0400, Alvaro Herrera wrote:
If we leave postmaster running after SIGKILLing its children, the only
thing we can do is have it continue to SIGKILL processes continuously
every few seconds until they die (or just sit around doing nothing until
Alvaro Herrera alvhe...@2ndquadrant.com writes:
Andres Freund escribió:
What we could do to improve the robustness a bit - at least on linux -
is to prctl(PR_SET_PDEATHSIG, SIGKILL) which would cause children to be
killed if the postmaster goes away...
This is an interesting idea (even if it
On Fri, Jun 21, 2013 at 5:44 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Alvaro Herrera alvhe...@2ndquadrant.com writes:
Andres Freund escribió:
What we could do to improve the robustness a bit - at least on linux -
is to prctl(PR_SET_PDEATHSIG, SIGKILL) which would cause children to be
killed if
Robert Haas robertmh...@gmail.com writes:
On Fri, Jun 21, 2013 at 5:44 PM, Tom Lane t...@sss.pgh.pa.us wrote:
The traditional theory has been that that would be less robust, not
more so. Child backends are (mostly) able to carry out queries whether
or not the postmaster is around.
I think
On Thu, Jun 20, 2013 at 12:33:25PM -0400, Alvaro Herrera wrote:
MauMau escribi?:
Here, reliable means that the database server is certainly shut
down when pg_ctl returns, not telling a lie that I shut down the
server processes for you, so you do not have to be worried that some
postgres
Noah Misch escribió:
On Thu, Jun 20, 2013 at 12:33:25PM -0400, Alvaro Herrera wrote:
MauMau escribi?:
Here, reliable means that the database server is certainly shut
down when pg_ctl returns, not telling a lie that I shut down the
server processes for you, so you do not have to be
11 matches
Mail list logo