Re: recovery_connections cannot start (was Re: master in standby mode croaks)

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Simon Riggs" <simon(at)2ndQuadrant(dot)com>, "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc: "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>, "Fujii Masao" <masao(dot)fujii(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: recovery_connections cannot start (was Re: master in standby mode croaks)
Date: 2010-04-23 19:56:17
Message-ID: 4BD1B5110200002500030D61@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon Riggs <simon(at)2ndQuadrant(dot)com> wrote:

> So we're proposing adding parameters to simplify things for users?

I think it's a matter of having parameters which do simple, clear
things; rather than magically interacting to guess what the user
wants. What do you want to log? How many connections to you want
to allow for streaming it? What's your script for sending it in
archive file format? Is archiving turned on at the moment? Let's
have GUC for each question, rather than having to work backwards
from what you want to which combination of GUC settings gets you to
that, or at least as close as the magic interpretation allows.

> I don't think fiddling is going to improve things significantly
> from a usability perspective, especially at the last minute.

If it involves changing the internal variables in a dangerous way,
perhaps we should settle for whatever we have at the moment. If
it's a matter of how they get set from the GUCs, that doesn't sound
very risky to me. Perhaps there are combinations which were
previously disallowed which would need to be tested, but are there
any other risks?

> [ad hominem digression]

Please, can we keep it to the merits? It sounds like there are
several reasonable use-cases which could be handled by HS/SR except
for how our GUCs are set up for it. Why limit the uses to a subset
of where it can be useful? I'm extraordinarily busy right now,
which is why my skimming of these threads didn't alert me to the
problem sooner. For that I apologize.

-Kevin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-04-23 19:57:00 Re: recovery_connections cannot start (was Re: master in standby mode croaks)
Previous Message Simon Riggs 2010-04-23 19:38:10 Re: recovery_connections cannot start (was Re: master in standby mode croaks)