En Sat, 31 Aug 2002 23:27:08 -0400 (EDT) Bruce Momjian <[EMAIL PROTECTED]> escribió:
> I am trying to find when WAL log files are rotated. The message is: > > 2002-02-11 21:18:13 DEBUG: recycled transaction log file 0000000000000005 > > and it is printed in MoveOfflineLogs(), and MoveOfflineLogs() is only > called by CreateCheckPoint(), but I can't see where CreateCheckPoint() > is called in normal operation. I see it called by CHECKPOINT, and on > startup and shutdown, and from bootstrap, but where is it called during > normal backend operation. I see it on TruncateCLOG(), src/backend/access/transam/clog.c; that is called by vacuum code. Also on CheckPoinDataBase(), macro in src/backend/postmaster/postmaster.c (this is called on a periodic basis AFAIU) HTH -- Alvaro Herrera (<alvherre[a]atentus.com>) One man's impedance mismatch is another man's layer of abstraction. (Lincoln Yeoh) ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html