Re: [GENERAL] warm standby server stops doing checkpoints after a while

2007-05-31 Thread Frank Wittig
Tom Lane schrieb: > Are you sure the master is checkpointing? Yes. I double checked using pg_controldata on the master. On both servers checkpoint_segments is set to 16 and checkpoint_timeout is 300 seconds default. There were two messages in the logs of the master that checkpointing happened too

Re: [GENERAL] warm standby server stops doing checkpoints after a while

2007-05-31 Thread Tom Lane
Frank Wittig <[EMAIL PROTECTED]> writes: > The problem is that the slave server stops checkpointing after some > hours of working (about 24 to 48 hours of conitued log replay). Hm ... look at RecoveryRestartPoint() in xlog.c. Could there be something wrong with this logic? /* * Do nothi

[GENERAL] warm standby server stops doing checkpoints after a while

2007-05-31 Thread Frank Wittig
Hello list, I have a problem regarding running a warm standby server as described in the postgresql 8.2 documentation. I set up two servers. Both running PostgreSQL 8.2.3-1PGDG on Fedora Core 6 (x86_64). (Master driven by AMD Opteron / Slave running on Intel Xeon) The master server copys its WAL