On Fri, Jul 13, 2018 at 04:20:15PM -0400, Dave Cramer wrote:
> However it would be far better to have a startup parameter which indicated
> that we wanted to connect to a read only database. At that point
> pools could redirect to a secondary. Given the proliferation of cloud based
>
>
>
>
> One thing where I can see a feature like this being quite helpful is
> planned failovers, reducing the time to reconnect (for existing
> connections) and rediscover (for new connections, which need to
> write). But that'd require that the redirect needs to be able to be sent
> in an
On 2018-07-13 23:00:04 +0300, Heikki Linnakangas wrote:
> On 05/03/18 22:18, Satyanarayana Narlapuram wrote:
> > Please see the attached patch with the comments.
> >
> > Changes in the patch:
> > A client-side PGREDIRECTLIMIT parameter has been introduced to control
> > the maximum number of
On 05/03/18 22:18, Satyanarayana Narlapuram wrote:
Please see the attached patch with the comments.
Changes in the patch:
A client-side PGREDIRECTLIMIT parameter has been introduced to control
the maximum number of retries.
BE_v3.1 sends a ProtocolNegotiation message. FE_v3.1
Please see the attached patch with the comments.
Changes in the patch:
A client-side PGREDIRECTLIMIT parameter has been introduced to control
the maximum number of retries.
BE_v3.1 sends a ProtocolNegotiation message. FE_v3.1 downgrades to v3.0
upon receipt of this message.
On Tue, Feb 13, 2018 at 5:23 PM, Tom Lane wrote:
> Robert Haas writes:
>> -- might need some defense against the redirected-to server getting
>> the same password as was sent to the original server. Is that a
>> security risk? Does HTTP have a rule
Robert Haas writes:
> -- might need some defense against the redirected-to server getting
> the same password as was sent to the original server. Is that a
> security risk? Does HTTP have a rule about this?
Without having read any of the previous discussion ... I'd say
On Mon, Feb 12, 2018 at 1:56 PM, Satyanarayana Narlapuram
wrote:
> I simplified the patch and for now just allowed one server. Please find the
> attached patches, and the commit message.
This patch --
-- doesn't include nearly sufficient documentation
t.com>
Cc: Satyanarayana Narlapuram <satyanarayana.narlapu...@microsoft.com>;
PostgreSQL-development <pgsql-hack...@postgresql.org>
Subject: Re: [HACKERS] Client Connection redirection support for PostgreSQL
On Thu, Nov 2, 2017 at 4:33 PM, Craig Ringer <cr...@2ndquadrant.com