Re: [Skytools-users] WAL Shipping + checkpoint

On 28/08/2009 17:13, Simon Riggs wrote:
>> Another check is "is it safe to do a checkpoint". This is logged with DEBUG2, so
>> it should be visible if you set the logging level accordingly.
>>
> This seems like the most likely cause. I would guess that one of your
> GiST indexes has a corruption in it and is preventing a restartpoint
> from taking place. That has happened previously.
>
>

You're right.

On the master, we had an error about a gist index on a ltree column :

Aug 25 09:07:02 eurovox-bdd postgres[5575]: [18-1]
user=eurovox,db=eurovox_db PANIC:  failed to add item to index page in
"appels_entrants_arbo_key"

The cluster try to restart ( it fail ), i had to force to stop.

Since this moment, the slave didn't make any checkpoint.

Now, we know why. Thanks a lot !

But how can i fix it ?

--
Sébastien Lardière