Re: RFC: Add 'taint' field to pg_control. - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: RFC: Add 'taint' field to pg_control.
Date
Msg-id CAMsr+YFosT1jaYT29gX-d3TzUUy4UBOCSHoa+p1pKCByjPPnPQ@mail.gmail.com
Whole thread Raw
In response to Re: RFC: Add 'taint' field to pg_control.  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: RFC: Add 'taint' field to pg_control.
List pgsql-hackers
On 8 March 2018 at 04:58, Robert Haas <robertmhaas@gmail.com> wrote:
On Wed, Feb 28, 2018 at 8:03 PM, Craig Ringer <craig@2ndquadrant.com> wrote:
> A huge +1 from me for the idea. I can't even count the number of black box
> "WTF did you DO?!?" servers I've looked at, where bizarre behaviour has
> turned out to be down to the user doing something very silly and not saying
> anything about it.

+1 from me, too.


My favourite remains an organisation that kept "fixing" an issue by kill -9'ing the postmaster and removing postmaster.pid to make it start up again. Without killing all the leftover backends. Of course, the system kept getting more unstable and broken, so they did it more and more often. They were working on scripting it when they gave up and asked for help.

The data recovery effort on that one was truly exciting. I remember looking at bash history and having to take a short break to figure out how on earth to communicate what was going on.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: PATCH: Configurable file mode mask
Next
From: Peter Geoghegan
Date:
Subject: Re: pgstat_report_activity() and parallel CREATE INDEX (was: Parallelindex creation & pg_stat_activity)