Re: [HACKERS] Client Connection redirection support for PostgreSQL

> pg_hba.conf is "host based access [control]" . I'm not sure it's really the > right place. I am open to have another configuration file, say routing_list.conf to define the routing rules, but felt it is easy to extend the hba conf file. > But we now have a session-intent stuff though. So we

Re: [HACKERS] Client Connection redirection support for PostgreSQL

> What advantages do you see in doing this in the backend over the current > system where the concerns are separated, i.e. people use connection poolers > like pgbouncer to do the routing? IMHO connection pooler is not great for latency sensitive applications. For small deployments, proxy is

[HACKERS] Client Connection redirection support for PostgreSQL

Proposal: Add the ability to the PostgreSQL server instance to route the traffic to a different server instance based on the rules defined in server's pg_bha.conf configuration file. At a high level this enables offloading the user requests to a different server instance based on the rules

Re: [HACKERS] Supporting Windows SChannel as OpenSSL replacement

Tom, Robert, Microsoft is interested in supporting windows SChannel for Postgres. Please let know how we can help taking this forward. We would love contributing to this either by enhancing the original patch provided by Heikki, or test the changes on Windows. Thanks, Satya -Original

Re: [HACKERS] Reading backup label file for checkpoint and redo location during crash recovery

Thank you! Got it. -Original Message- From: Stephen Frost [mailto:sfr...@snowman.net] Sent: Monday, September 25, 2017 10:57 AM To: Magnus Hagander <mag...@hagander.net> Cc: Satyanarayana Narlapuram <satyanarayana.narlapu...@microsoft.com>; PostgreSQL-development &l

[HACKERS] Reading backup label file for checkpoint and redo location during crash recovery

Hi there, During crash recovery, last checkpoint record information is obtained from the backup label if present, instead of getting it from the control file. This behavior is causing PostgreSQL database cluster not to come up until the backup label file is deleted (as the error message says).

Re: protocol version negotiation (Re: [HACKERS] Libpq PGRES_COPY_BOTH - version compatibility)

-Original Message- From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Robert Haas Sent: Thursday, June 29, 2017 5:18 AM To: Tom Lane Cc: Craig Ringer ; Peter Eisentraut ; Magnus

Re: [HACKERS] Making server name part of the startup message

quires including full cluster_name every time user connect to a different database. Thanks, Satya From: Magnus Hagander [mailto:mag...@hagander.net] Sent: Thursday, June 15, 2017 9:24 AM To: Tom Lane <t...@sss.pgh.pa.us> Cc: Alvaro Herrera <alvhe...@2ndquadrant.com>; Satyan

Re: [HACKERS] Making server name part of the startup message

e in the startup message and will not be included otherwise. Thanks, Satya -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Thursday, June 15, 2017 8:58 AM To: Alvaro Herrera <alvhe...@2ndquadrant.com> Cc: Satyanarayana Narlapuram <satyanarayana.narlapu...@microsoft.com>;

Re: [HACKERS] Optional message to user when terminating/cancelling backend

: Tuesday, June 20, 2017 12:44 PM To: Alvaro Herrera <alvhe...@2ndquadrant.com> Cc: Satyanarayana Narlapuram <satyanarayana.narlapu...@microsoft.com>; Pavel Stehule <pavel.steh...@gmail.com>; Daniel Gustafsson <dan...@yesql.se>; PostgreSQL mailing lists <pgsql-hackers@

Re: [HACKERS] Optional message to user when terminating/cancelling backend

+1. This really helps PostgreSQL Azure service as well. When we are doing the upgrades to the service, instead of abruptly terminating the sessions we can provide this message. Thanks, Satya From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of

Re: [HACKERS] Making server name part of the startup message

-Original Message- From: Andres Freund [mailto:and...@anarazel.de] Sent: Friday, June 16, 2017 10:48 AM To: Tom Lane <t...@sss.pgh.pa.us> Cc: Satyanarayana Narlapuram <satyanarayana.narlapu...@microsoft.com>; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Making serv

[HACKERS] Adding connection id in the startup message

As a cloud service, Azure Database for PostgreSQL uses a gateway proxy to route connections to a node hosting the actual server. Potentially there could be multiple hops (for example client, optional proxy at the client like pgbouncer for connection pooling, Azure gateway proxy, backend server)

[HACKERS] Making server name part of the startup message

As a cloud service, Azure Database for PostgreSQL uses a gateway proxy to route connections to a node hosting the actual server. To do that, the proxy needs to know the name of the server it tries to locate. As a work-around we currently overload the username parameter to pass in the server