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
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 |