Skip site navigation (1) Skip section navigation (2)

Re: Restarting standby database have to reaply WAL (redologs)

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Cesar Otero <cesar(dot)otero(dot)souto(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Restarting standby database have to reaply WAL (redologs)
Date: 2007-09-25 18:28:55
Message-ID: 1190744935.4181.510.camel@ebony.site (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

pgsql-admin by date

Next:From: scottbDate: 2007-09-26 16:16:33
Subject: log_duration / log_min_duration_statement differences between 8.1.8 and 8.2.4
Previous:From: Cesar OteroDate: 2007-09-25 17:14:36
Subject: Re: Restarting standby database have to reaply WAL (redo logs)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group