Re: [HACKERS] suppress automatic recovery after back crash

2010-07-19 Thread Robert Haas
On Sat, Jul 17, 2010 at 10:16 AM, Tom Lane t...@sss.pgh.pa.us wrote: Simon Riggs si...@2ndquadrant.com writes: On Sun, 2010-06-27 at 20:54 -0400, Robert Haas wrote: automatic_restart = true      # reinitialize after backend crash? automatic_restart makes me think when does that happen?. Can

Re: [HACKERS] suppress automatic recovery after back crash

2010-07-17 Thread Simon Riggs
On Sun, 2010-06-27 at 20:54 -0400, Robert Haas wrote: automatic_restart = true # reinitialize after backend crash? automatic_restart makes me think when does that happen?. Can we call this restart_after_crash? Or similar. So we are explicit about when the restart will kick in. -- Simon

Re: [HACKERS] suppress automatic recovery after back crash

2010-07-17 Thread Tom Lane
Simon Riggs si...@2ndquadrant.com writes: On Sun, 2010-06-27 at 20:54 -0400, Robert Haas wrote: automatic_restart = true # reinitialize after backend crash? automatic_restart makes me think when does that happen?. Can we call this restart_after_crash? Or similar. +1. automatic_restart

Re: [HACKERS] suppress automatic recovery after back crash

2010-07-15 Thread Fujii Masao
On Wed, Jul 14, 2010 at 11:59 PM, Robert Haas robertmh...@gmail.com wrote: On Wed, Jul 14, 2010 at 3:41 AM, Fujii Masao masao.fu...@gmail.com wrote: I read the patch and found some small typos. Thanks.  Corrected version attached. We should add something like?: - Even if this

Re: [HACKERS] suppress automatic recovery after back crash

2010-07-14 Thread Fujii Masao
On Mon, Jun 28, 2010 at 9:09 PM, Robert Haas robertmh...@gmail.com wrote: I mulled over which of those names was better; updated version, reflecting your proposed naming, attached. I read the patch and found some small typos. +If true, any error will terminate the current session.

Re: [HACKERS] suppress automatic recovery after back crash

2010-07-14 Thread Robert Haas
On Wed, Jul 14, 2010 at 3:41 AM, Fujii Masao masao.fu...@gmail.com wrote: I read the patch and found some small typos. Thanks. Corrected version attached. We should add something like?: - Even if this value is set to true, a backend crash during hot standby doesn't reinitialize

Re: [HACKERS] suppress automatic recovery after back crash

2010-06-28 Thread Robert Haas
On Sun, Jun 27, 2010 at 9:02 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Thu, Jun 17, 2010 at 7:25 PM, Tom Lane t...@sss.pgh.pa.us wrote: Then all you need is a tweak to make the postmaster exit(1) after a crash instead of trying to launch recovery.

Re: [HACKERS] suppress automatic recovery after back crash

2010-06-28 Thread Fujii Masao
On Mon, Jun 28, 2010 at 9:54 AM, Robert Haas robertmh...@gmail.com wrote: This seems useful to me so here's a patch to implement it. +1 This would be very useful for people who want to give a clusterware control of postgres. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION

[HACKERS] suppress automatic recovery after back crash

2010-06-27 Thread Robert Haas
[moving from -performance to -hackers; original subject is: PostgreSQL as a local in-memory cache] On Thu, Jun 17, 2010 at 7:25 PM, Tom Lane t...@sss.pgh.pa.us wrote: Josh Berkus j...@agliodbs.com writes: (a) and (d) are probably simple, if by reprovisioning you mean rm -rf $PGDATA; initdb.

Re: [HACKERS] suppress automatic recovery after back crash

2010-06-27 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Thu, Jun 17, 2010 at 7:25 PM, Tom Lane t...@sss.pgh.pa.us wrote: Then all you need is a tweak to make the postmaster exit(1) after a crash instead of trying to launch recovery. This seems useful to me so here's a patch to implement it. Hm, is it