Force update_process_title=on in crash recovery? - Mailing list pgsql-hackers

From Thomas Munro
Subject Force update_process_title=on in crash recovery?
Date
Msg-id CA+hUKGKECzTweoYTfHT4i4AqOxZta1ZoGqWVG9CyedpJidBh2A@mail.gmail.com
Whole thread Raw
Responses Re: Force update_process_title=on in crash recovery?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

Based on a couple of independent reports from users with no idea how
to judge the progress of a system recovering from a crash, Christoph
and I wondered if we should override update_process_title for the
"recovering ..." message, at least until connections are allowed.  We
already do that to set the initial titles.

Crash recovery is a rare case where important information is reported
through the process title that isn't readily available anywhere else,
since you can't log in.  If you want to gauge  progress on a system
that happened to crash with update_process_title set to off, your best
hope is probably to trace the process or spy on the files it has open,
to see which WAL segment it's accessing, but that's not very nice.



pgsql-hackers by date:

Previous
From: Ajin Cherian
Date:
Subject: Re: [HACKERS] logical decoding of two-phase transactions
Next
From: Peter Eisentraut
Date:
Subject: Re: Collation versioning