Re: error handling in RegisterBackgroundWorker

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: error handling in RegisterBackgroundWorker
Date: 2017-04-11 03:22:38
Message-ID: 30852.1491880958@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Noah Misch <noah(at)leadboat(dot)com> writes:
> On Mon, Apr 10, 2017 at 09:36:59PM -0400, Peter Eisentraut wrote:
>> If history had been different, we could have implemented, say,
>> autovacuum or walreceiver on the background worker framework. I think
>> unifying some of that might actually be a future project. Would it be
>> OK if these processes just logged a warning and didn't start if there
>> was a misconfiguration?

> No. I can't think of any background worker so unimportant that I'd want the
> warning only. Certainly, then, the ones you list are far too important.

Well, I dunno. We allow the system to start without a functioning stats
collector (cf what happens if we fail to create a working loopback
socket). But lack of stats will effectively disable autovacuum. So at
the very least we have some inconsistent decisions here.

Personally I'd err on the side of "starting up degraded is better than
not starting at all". Or maybe we should invent a GUC to let DBAs
express their preference on that?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Osahon Oduware 2017-04-11 03:42:37 PostGIS Raster - Loading MrSID format
Previous Message Peter Eisentraut 2017-04-11 03:06:11 Re: [pgsql-www] Small issue in online devel documentation build