Re: [HACKERS] Clean switchover

2013-06-25 Thread Fujii Masao
On Mon, Jun 24, 2013 at 3:41 PM, Andres Freund wrote: > On 2013-06-14 04:56:15 +0900, Fujii Masao wrote: >> On Wed, Jun 12, 2013 at 9:48 PM, Stephen Frost wrote: >> > * Magnus Hagander (mag...@hagander.net) wrote: >> >> On Wed, Jun 12, 2013 at 1:48 PM, Andres Freund >> >> wrote: >> >> > On 2013

Re: [HACKERS] Clean switchover

2013-06-23 Thread Andres Freund
On 2013-06-14 04:56:15 +0900, Fujii Masao wrote: > On Wed, Jun 12, 2013 at 9:48 PM, Stephen Frost wrote: > > * Magnus Hagander (mag...@hagander.net) wrote: > >> On Wed, Jun 12, 2013 at 1:48 PM, Andres Freund > >> wrote: > >> > On 2013-06-12 07:53:29 +0900, Fujii Masao wrote: > >> >> The attached

Re: [HACKERS] Clean switchover

2013-06-13 Thread Mark Kirkwood
On 14/06/13 07:38, Fujii Masao wrote: On Wed, Jun 12, 2013 at 12:55 PM, Mark Kirkwood wrote: On 12/06/13 13:15, Stephen Frost wrote: * Fujii Masao (masao.fu...@gmail.com) wrote: The attached patch fixes this problem. It just changes walsender so that it waits for all the outstanding WAL rec

Re: [HACKERS] Clean switchover

2013-06-13 Thread Fujii Masao
On Wed, Jun 12, 2013 at 9:48 PM, Stephen Frost wrote: > * Magnus Hagander (mag...@hagander.net) wrote: >> On Wed, Jun 12, 2013 at 1:48 PM, Andres Freund >> wrote: >> > On 2013-06-12 07:53:29 +0900, Fujii Masao wrote: >> >> The attached patch fixes this problem. It just changes walsender so that

Re: [HACKERS] Clean switchover

2013-06-13 Thread Fujii Masao
On Wed, Jun 12, 2013 at 9:55 PM, Andres Freund wrote: > On 2013-06-12 08:48:39 -0400, Stephen Frost wrote: >> * Magnus Hagander (mag...@hagander.net) wrote: >> > On Wed, Jun 12, 2013 at 1:48 PM, Andres Freund >> > wrote: >> > > On 2013-06-12 07:53:29 +0900, Fujii Masao wrote: >> > >> The attache

Re: [HACKERS] Clean switchover

2013-06-13 Thread Fujii Masao
On Wed, Jun 12, 2013 at 12:55 PM, Mark Kirkwood wrote: > On 12/06/13 13:15, Stephen Frost wrote: >> >> * Fujii Masao (masao.fu...@gmail.com) wrote: >>> >>> The attached patch fixes this problem. It just changes walsender so that >>> it >>> waits for all the outstanding WAL records to be replicated

Re: [HACKERS] Clean switchover

2013-06-12 Thread Andres Freund
On 2013-06-12 08:48:39 -0400, Stephen Frost wrote: > * Magnus Hagander (mag...@hagander.net) wrote: > > On Wed, Jun 12, 2013 at 1:48 PM, Andres Freund > > wrote: > > > On 2013-06-12 07:53:29 +0900, Fujii Masao wrote: > > >> The attached patch fixes this problem. It just changes walsender so that

Re: [HACKERS] Clean switchover

2013-06-12 Thread Stephen Frost
* Magnus Hagander (mag...@hagander.net) wrote: > On Wed, Jun 12, 2013 at 1:48 PM, Andres Freund wrote: > > On 2013-06-12 07:53:29 +0900, Fujii Masao wrote: > >> The attached patch fixes this problem. It just changes walsender so that it > >> waits for all the outstanding WAL records to be replicat

Re: [HACKERS] Clean switchover

2013-06-12 Thread Magnus Hagander
On Wed, Jun 12, 2013 at 1:48 PM, Andres Freund wrote: > Hi, > > On 2013-06-12 07:53:29 +0900, Fujii Masao wrote: >> The attached patch fixes this problem. It just changes walsender so that it >> waits for all the outstanding WAL records to be replicated to the standby >> before closing the replica

Re: [HACKERS] Clean switchover

2013-06-12 Thread Andres Freund
Hi, On 2013-06-12 07:53:29 +0900, Fujii Masao wrote: > The attached patch fixes this problem. It just changes walsender so that it > waits for all the outstanding WAL records to be replicated to the standby > before closing the replication connection. Imo this is a fix that needs to get backpatch

Re: [HACKERS] Clean switchover

2013-06-12 Thread Magnus Hagander
On Wed, Jun 12, 2013 at 6:41 AM, Amit Kapila wrote: > On Wednesday, June 12, 2013 4:23 AM Fujii Masao wrote: >> Hi, >> >> In streaming replication, when we shutdown the master, walsender tries >> to send all the outstanding WAL records including the shutdown >> checkpoint record to the standby, an

Re: [HACKERS] Clean switchover

2013-06-11 Thread Amit Kapila
On Wednesday, June 12, 2013 4:23 AM Fujii Masao wrote: > Hi, > > In streaming replication, when we shutdown the master, walsender tries > to send all the outstanding WAL records including the shutdown > checkpoint record to the standby, and then to exit. This basically > means that all the WAL rec

Re: [HACKERS] Clean switchover

2013-06-11 Thread Mark Kirkwood
On 12/06/13 13:15, Stephen Frost wrote: * Fujii Masao (masao.fu...@gmail.com) wrote: The attached patch fixes this problem. It just changes walsender so that it waits for all the outstanding WAL records to be replicated to the standby before closing the replication connection. Seems like a goo

Re: [HACKERS] Clean switchover

2013-06-11 Thread Stephen Frost
* Fujii Masao (masao.fu...@gmail.com) wrote: > The attached patch fixes this problem. It just changes walsender so that it > waits for all the outstanding WAL records to be replicated to the standby > before closing the replication connection. Seems like a good idea to me.. Rather surprised that

[HACKERS] Clean switchover

2013-06-11 Thread Fujii Masao
Hi, In streaming replication, when we shutdown the master, walsender tries to send all the outstanding WAL records including the shutdown checkpoint record to the standby, and then to exit. This basically means that all the WAL records are fully synced between two servers after the clean shutdown