WAL Shipping + checkpoint

From: Sébastien Lardière <slardiere(at)hi-media(dot)com>
To: pgsql-general(at)postgresql(dot)org, skytools-users(at)pgfoundry(dot)org
Subject: WAL Shipping + checkpoint
Date: 2009-08-25 16:11:28
Message-ID: 4A940D30.4090300@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I've a cluster ( Pg 8.3.7 ) with WAL Shipping, and a few hours ago, the
master had to restart.

I use walmgr from Skytools, which works very well.

I have already restart the master without any problem, but today, the
slave doesn't work like I want. The field "Time of latest checkpoint"
from the pg_controldata on the slave keep the same values, but WAL File
are processed correctly.

I try to restart the slave, but, after processed again all the WAL
between "Time of latest checkpoint" and, it does nothing else, latest
checkpoint stay at the same value.

I don't know if it's important ( i think so ), and I can't fix it.

Is anybody have an idea ?

thanks,

--
Sébastien Lardière

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcus Engene 2009-08-25 16:16:51 somewhat slow query with subselect
Previous Message Scott Frankel 2009-08-25 16:02:02 Re: view table pkey values