| 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: | Whole Thread | Raw Message | 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 |