Postgres Pro
Downloads
Home   >   mailing lists

Re: Skip checkpoint on promoting from streaming replication - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Skip checkpoint on promoting from streaming replication
Date
Msg-id CAHGQGwFFoQEOaUV65Brgr3mhGOY+bcCpgWWyCzjp1SDyRctKyQ@mail.gmail.com
Whole thread Raw
In response to Re: Skip checkpoint on promoting from streaming replication  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Responses Re: Skip checkpoint on promoting from streaming replication
List pgsql-hackers
Tree view 
On Mon, Jun 18, 2012 at 5:42 PM, Kyotaro HORIGUCHI
<horiguchi.kyotaro@lab.ntt.co.jp> wrote:
> What do you think about this?

What happens if the server skips an end-of-recovery checkpoint, is promoted to
the master, runs some write transactions, crashes and restarts automatically
before it completes checkpoint? In this case, the server needs to do crash
recovery from the last checkpoint record with old timeline ID to the latest WAL
record with new timeline ID. How does crash recovery do recovery beyond
timeline?

Regards,

-- 
Fujii Masao

pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: pgsql_fdw in contrib
Next
From: Alvaro Herrera
Date:
Subject: Re: Allow WAL information to recover corrupted pg_controldata