a small proposal for avoiding foot-shooting

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема a small proposal for avoiding foot-shooting
Дата
Msg-id 87hc4yzfnm.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответы Re: a small proposal for avoiding foot-shooting  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Append major version number and for libraries soname major
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Append major version number and for libraries soname major