Change "recycled transaction log" from LOG to DEBUG1
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
NotDashEscaped: You need GnuPG to verify this message
On August 9, Tom Lane wrote regarding "recycled transaction log file"
messages appearing in the server logs:
This is normal behavior. At some point we'll probably knock down the
priority of those messages from LOG to DEBUG...
I'm all for it, for I am tired of seeing those messages in my logs
as well. I'd make a link to Tom's original post, but once again
archives.postgresql.org is not working.
Index: xlog.c
===================================================================
RCS file: /projects/cvsroot/pgsql-server/src/backend/access/transam/xlog.c,v
retrieving revision 1.168
diff -c -r1.168 xlog.c
*** xlog.c 30 Aug 2004 02:54:38 -0000 1.168
--- xlog.c 5 Sep 2004 15:26:43 -0000
***************
*** 2154,2160 ****
true, XLOGfileslop,
true))
{
! ereport(LOG,
(errmsg("recycled transaction log file \"%s\"",
xlde->d_name)));
}
--- 2154,2160 ----
true, XLOGfileslop,
true))
{
! ereport(DEBUG1,
(errmsg("recycled transaction log file \"%s\"",
xlde->d_name)));
}--
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200409051137
-----BEGIN PGP SIGNATURE-----
iD8DBQFBOzNBvJuQZxSWSsgRApOvAKCPoVcSR29wft9RIxk4bi3R5SkahQCg0yKr
ISROl8QXPuh8g16O+zRCeus=
=dFk7
-----END PGP SIGNATURE-----
May as well downgrade the CLOG message as well then.
Chris
Greg Sabino Mullane wrote:
Show quoted text
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
NotDashEscaped: You need GnuPG to verify this messageOn August 9, Tom Lane wrote regarding "recycled transaction log file"
messages appearing in the server logs:This is normal behavior. At some point we'll probably knock down the
priority of those messages from LOG to DEBUG...I'm all for it, for I am tired of seeing those messages in my logs
as well. I'd make a link to Tom's original post, but once again
archives.postgresql.org is not working.Index: xlog.c =================================================================== RCS file: /projects/cvsroot/pgsql-server/src/backend/access/transam/xlog.c,v retrieving revision 1.168 diff -c -r1.168 xlog.c *** xlog.c 30 Aug 2004 02:54:38 -0000 1.168 --- xlog.c 5 Sep 2004 15:26:43 -0000 *************** *** 2154,2160 **** true, XLOGfileslop, true)) { ! ereport(LOG, (errmsg("recycled transaction log file \"%s\"", xlde->d_name))); } --- 2154,2160 ---- true, XLOGfileslop, true)) { ! ereport(DEBUG1, (errmsg("recycled transaction log file \"%s\"", xlde->d_name))); }--
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200409051137-----BEGIN PGP SIGNATURE-----
iD8DBQFBOzNBvJuQZxSWSsgRApOvAKCPoVcSR29wft9RIxk4bi3R5SkahQCg0yKr
ISROl8QXPuh8g16O+zRCeus=
=dFk7
-----END PGP SIGNATURE--------------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
May as well downgrade the CLOG message as well then.
Agreed. I've applied the attached extended patch.
regards, tom lane
*** src/backend/access/transam/slru.c.orig Sun Aug 29 09:54:52 2004
--- src/backend/access/transam/slru.c Sun Sep 5 23:01:57 2004
***************
*** 944,950 ****
if (doDeletions)
{
snprintf(path, MAXPGPATH, "%s/%s", ctl->Dir, clde->d_name);
! ereport(LOG,
(errmsg("removing file \"%s\"", path)));
unlink(path);
}
--- 944,950 ----
if (doDeletions)
{
snprintf(path, MAXPGPATH, "%s/%s", ctl->Dir, clde->d_name);
! ereport(DEBUG1,
(errmsg("removing file \"%s\"", path)));
unlink(path);
}
*** src/backend/access/transam/xlog.c.orig Sun Aug 29 22:57:29 2004
--- src/backend/access/transam/xlog.c Sun Sep 5 23:01:58 2004
***************
*** 2154,2167 ****
true, XLOGfileslop,
true))
{
! ereport(LOG,
(errmsg("recycled transaction log file \"%s\"",
xlde->d_name)));
}
else
{
/* No need for any more future segments... */
! ereport(LOG,
(errmsg("removing transaction log file \"%s\"",
xlde->d_name)));
unlink(path);
--- 2154,2167 ----
true, XLOGfileslop,
true))
{
! ereport(DEBUG1,
(errmsg("recycled transaction log file \"%s\"",
xlde->d_name)));
}
else
{
/* No need for any more future segments... */
! ereport(DEBUG1,
(errmsg("removing transaction log file \"%s\"",
xlde->d_name)));
unlink(path);