]> granicus.if.org Git - postgresql/commit
Try to log current the query string when a backend crashes.
authorRobert Haas <rhaas@postgresql.org>
Fri, 21 Oct 2011 17:26:40 +0000 (13:26 -0400)
committerRobert Haas <rhaas@postgresql.org>
Fri, 21 Oct 2011 17:26:40 +0000 (13:26 -0400)
commitc8e8b5a6e20bf471d83059aebe64bca16f184057
tree2c346104aa4579489126b5eceee07080aafda017
parent980261929f2b8c40d6be1979ff81c943cad907b3
Try to log current the query string when a backend crashes.

To avoid minimize risk inside the postmaster, we subject this feature
to a number of significant limitations.  We very much wish to avoid
doing any complex processing inside the postmaster, due to the
posssibility that the crashed backend has completely corrupted shared
memory.  To that end, no encoding conversion is done; instead, we just
replace anything that doesn't look like an ASCII character with a
question mark.  We limit the amount of data copied to 1024 characters,
and carefully sanity check the source of that data.  While these
restrictions would doubtless be unacceptable in a general-purpose
logging facility, even this limited facility seems like an improvement
over the status quo ante.

Marti Raudsepp, reviewed by PDXPUG and myself
src/backend/postmaster/pgstat.c
src/backend/postmaster/postmaster.c
src/backend/utils/adt/ascii.c
src/include/pgstat.h
src/include/utils/ascii.h