On 01/09/2009 05:14, Yaroslav Tykhiy wrote:
Thanks, I make a restore backup on the slave this morning, and It
works !
Could you detail your solution please, if any? I've seen frozen
pg_controldata output on my standby server for ages and attributed
that to the ancient version of pgsql (8.
On Tue, 2009-09-01 at 13:14 +1000, Yaroslav Tykhiy wrote:
> Could you detail your solution please, if any? I've seen frozen
> pg_controldata output on my standby server for ages and attributed
> that to the ancient version of pgsql (8.0.x) I'm stuck with.
It won't ever work before 8.2
--
On 31/08/2009, at 6:16 PM, Sébastien Lardière wrote:
On 28/08/2009 18:14, Simon Riggs wrote:
On Fri, 2009-08-28 at 17:54 +0200, Sébastien Lardière wrote:
Since this moment, the slave didn't make any checkpoint.
Now, we know why. Thanks a lot !
But how can i fix it ?
Current issue: Rebuild
On 28/08/2009 18:14, Simon Riggs wrote:
On Fri, 2009-08-28 at 17:54 +0200, Sébastien Lardière wrote:
Since this moment, the slave didn't make any checkpoint.
Now, we know why. Thanks a lot !
But how can i fix it ?
Current issue: Rebuild standby from base backup.
Cause: Locate the b
On Fri, 2009-08-28 at 17:54 +0200, Sébastien Lardière wrote:
> Since this moment, the slave didn't make any checkpoint.
>
> Now, we know why. Thanks a lot !
>
> But how can i fix it ?
Current issue: Rebuild standby from base backup.
Cause: Locate the bug in the Index AM that causes it.
Sympto
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
On Fri, 2009-08-28 at 17:55 +0300, Martin Pihlak wrote:
> This is weird, indeed it seems that for some reason the recovery restartpoints
> are not created.
>
> Looking quickly at RecoveryRestartPoint() in xlog.c, there are two cases when
> it
> doesn't do a checkpoint. For one thing, it checks
Sébastien Lardière wrote:
> No, i don't see any change in pg_controldata, but :
>
> there is messages in logfile :
>
> 2009-08-28 10:02:51,129 26717 INFO 000103F70088: Found
> 2009-08-28 10:02:51,169 26717 INFO {count: 1}
> 2009-08-28 10:02:51 CEST [18439]: [1862-1] user=,db= LOG: re
On 27/08/2009 18:11, Martin Pihlak wrote:
There are actually no "real" data changes being made on your master
for some reason. So every time archive_timeout is reached a log full
of no changes is shipped to your slave and applied - and no checkpoint
times are changed for reasons I mentioned above
>> There are actually no "real" data changes being made on your master
>> for some reason. So every time archive_timeout is reached a log full
>> of no changes is shipped to your slave and applied - and no checkpoint
>> times are changed for reasons I mentioned above.
>>
>>
>
> thanks, but we have
On 27/08/2009 00:18, Mark Kirkwood wrote:
Sébastien Lardière wrote:
On 26/08/2009 04:46, Mark Kirkwood wrote:
Sébastien Lardière wrote:
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.
Sébastien Lardière wrote:
On 26/08/2009 04:46, Mark Kirkwood wrote:
Sébastien Lardière wrote:
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
On 26/08/2009 04:46, Mark Kirkwood wrote:
Sébastien Lardière wrote:
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
Sébastien Lardière wrote:
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
14 matches
Mail list logo
