Re: [HACKERS] Client Connection redirection support for PostgreSQL

2018-10-01 Thread Michael Paquier
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 >

Re: [HACKERS] Client Connection redirection support for PostgreSQL

2018-07-13 Thread Dave Cramer
> > > > 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

Re: [HACKERS] Client Connection redirection support for PostgreSQL

2018-07-13 Thread Andres Freund
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

Re: [HACKERS] Client Connection redirection support for PostgreSQL

2018-07-13 Thread Heikki Linnakangas
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

RE: [HACKERS] Client Connection redirection support for PostgreSQL

2018-03-05 Thread Satyanarayana Narlapuram
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.

Re: [HACKERS] Client Connection redirection support for PostgreSQL

2018-02-14 Thread Robert Haas
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

Re: [HACKERS] Client Connection redirection support for PostgreSQL

2018-02-13 Thread Tom Lane
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

Re: [HACKERS] Client Connection redirection support for PostgreSQL

2018-02-13 Thread Robert Haas
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

RE: [HACKERS] Client Connection redirection support for PostgreSQL

2018-02-12 Thread Satyanarayana Narlapuram
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