a small proposal for avoiding foot-shooting - Mailing list pgsql-hackers

From Andrew Gierth
Subject a small proposal for avoiding foot-shooting
Date
Msg-id 87hc4yzfnm.fsf@news-spur.riddles.org.uk
Whole thread Raw
Responses Re: a small proposal for avoiding foot-shooting  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Currently setting "log_error_verbosity = terse" causes all HINT output
to the log file to be suppressed (along with some other stuff).

I propose that this behaviour be changed such that 'terse' is ignored
for all log messages of FATAL or PANIC severity.

The main reason for this is messages like (from xlog.c):
           ereport(PANIC,                   (errmsg("could not locate required checkpoint record"),
errhint("Ifyou are not restoring from a backup, try removing the file \"%s/backup_label\".", DataDir)));
 

The HINT: there is at least as important as the error message, and the
lack of a clear direction to the admin in this case is a gold-plated
invitation to do something stupid that will seriously mess up the data,
such as manually copying back the xlog file that recovery seems to be
asking for at that point.

[This is all based on today's lesson in disaster recovery from the IRC
chan, so it's not theoretical.]

-- 
Andrew (irc:RhodiumToad)


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: [COMMITTERS] pgsql: Append major version number and for libraries soname major
Next
From: Andrew Dunstan
Date:
Subject: Re: [COMMITTERS] pgsql: Append major version number and for libraries soname major