pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Simon Riggs <simon@2ndquadrant.com>
To: Cesar Otero <cesar.otero.souto@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Restarting standby database have to reaply WAL (redo logs)
Date: Tue, 25 Sep 2007 19:28:55 +0100
Message-ID: <1190744935.4181.510.camel@ebony.site> (raw)
In-Reply-To: <a7aeff880709251014w2e236affofd2fabff5a1520dc@mail.gmail.com>
References: <a7aeff880709250841u749b40a2t3cb401f90b4aa3ae@mail.gmail.com>
	<1190739865.4181.507.camel@ebony.site>
	<a7aeff880709251014w2e236affofd2fabff5a1520dc@mail.gmail.com>

On Tue, 2007-09-25 at 14:14 -0300, Cesar Otero wrote:

> I think that after restarting standby db the first log should be last
> log applied + 1

That isn't how it works, for performance reasons.

We don't make a restartpoint after each file, we do this on the first
usable checkpoint WAL record that we find after checkpoint_timeout
seconds.

-- 
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com




view thread (4+ messages)

Message-ID: <1190744935.4181.510.camel@ebony.site>
Permalink:  ../1190744935.4181.510.camel@ebony.site/
Also on:    postgresql.org/message-id/1190744935.4181.510.camel@ebony.site

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: simon@2ndquadrant.com, cesar.otero.souto@gmail.com
  Subject: Re: Restarting standby database have to reaply WAL (redo logs)
  In-Reply-To: <1190744935.4181.510.camel@ebony.site>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox