Re: [HACKERS] New sync commit mode remote_write

2012-04-24 Thread Robert Haas
On Tue, Apr 24, 2012 at 12:21 PM, Jeff Janes wrote: > On Thu, Apr 19, 2012 at 11:50 AM, Robert Haas wrote: >> On 4/19/12, Jeff Janes wrote: >>> The work around would be for the master to refuse to automatically >>> restart after a crash, insisting on a fail-over instead (or a manual >>> forcing

Re: [HACKERS] New sync commit mode remote_write

2012-04-24 Thread Jeff Janes
On Thu, Apr 19, 2012 at 11:50 AM, Robert Haas wrote: > On 4/19/12, Jeff Janes wrote: >> The work around would be for the master to refuse to automatically >> restart after a crash, insisting on a fail-over instead (or a manual >> forcing of recovery)? > > I suppose that would work, but I think Si

Re: [HACKERS] New sync commit mode remote_write

2012-04-24 Thread Robert Haas
On Fri, Apr 20, 2012 at 3:58 PM, Fujii Masao wrote: > On Sat, Apr 21, 2012 at 12:20 AM, Simon Riggs wrote: >> On Thu, Apr 19, 2012 at 7:50 PM, Robert Haas wrote: >>> On 4/19/12, Jeff Janes wrote: The work around would be for the master to refuse to automatically restart after a crash,

Re: [HACKERS] New sync commit mode remote_write

2012-04-20 Thread Fujii Masao
On Sat, Apr 21, 2012 at 12:20 AM, Simon Riggs wrote: > On Thu, Apr 19, 2012 at 7:50 PM, Robert Haas wrote: >> On 4/19/12, Jeff Janes wrote: >>> The work around would be for the master to refuse to automatically >>> restart after a crash, insisting on a fail-over instead (or a manual >>> forcing

Re: [HACKERS] New sync commit mode remote_write

2012-04-20 Thread Simon Riggs
On Thu, Apr 19, 2012 at 7:50 PM, Robert Haas wrote: > On 4/19/12, Jeff Janes wrote: >> The work around would be for the master to refuse to automatically >> restart after a crash, insisting on a fail-over instead (or a manual >> forcing of recovery)? > > I suppose that would work, but I think Sim

Re: [HACKERS] New sync commit mode remote_write

2012-04-19 Thread Robert Haas
On 4/19/12, Jeff Janes wrote: > The work around would be for the master to refuse to automatically > restart after a crash, insisting on a fail-over instead (or a manual > forcing of recovery)? I suppose that would work, but I think Simon's idea is better: don't let the slave replay the WAL until

Re: [HACKERS] New sync commit mode remote_write

2012-04-19 Thread Jeff Janes
On Thu, Apr 19, 2012 at 2:47 AM, Robert Haas wrote: > On Apr 19, 2012, at 5:05 AM, Magnus Hagander wrote: >> I admit to not having followed the discussion around the new mode for >> synchronous_commit very closely, so my apologies if this has been >> discussed and dismiseed - I blame failing to f

Re: [HACKERS] New sync commit mode remote_write

2012-04-19 Thread Simon Riggs
On Thu, Apr 19, 2012 at 10:05 AM, Magnus Hagander wrote: > I admit to not having followed the discussion around the new mode for > synchronous_commit very closely, so my apologies if this has been > discussed and dismiseed - I blame failing to find it int he archives > ;) > > My understanding from

Re: [HACKERS] New sync commit mode remote_write

2012-04-19 Thread Magnus Hagander
On Thu, Apr 19, 2012 at 12:40, Simon Riggs wrote: > On Thu, Apr 19, 2012 at 10:05 AM, Magnus Hagander wrote: >> I admit to not having followed the discussion around the new mode for >> synchronous_commit very closely, so my apologies if this has been >> discussed and dismiseed - I blame failing t

Re: [HACKERS] New sync commit mode remote_write

2012-04-19 Thread Robert Haas
On Apr 19, 2012, at 5:05 AM, Magnus Hagander wrote: > I admit to not having followed the discussion around the new mode for > synchronous_commit very closely, so my apologies if this has been > discussed and dismiseed - I blame failing to find it int he archives > ;) > > My understanding from loo

[HACKERS] New sync commit mode remote_write

2012-04-19 Thread Magnus Hagander
I admit to not having followed the discussion around the new mode for synchronous_commit very closely, so my apologies if this has been discussed and dismiseed - I blame failing to find it int he archives ;) My understanding from looking at the docs is that synchronous_commit=remote_write will alw