Menu

#19 Encrypted connections for pooler

Development Queue
open
nobody
Pooler (3)
5
2012-06-03
2011-04-11
No

Addition of a new option in postgresql.conf called encrypt_connection that will
allow the pooler to create encrypted connections to other nodes of the cluster.

This parameter can be a simple switch on/off.
This feature is a prerequisite for cluster security.

Discussion

  • Michael Paquier

    Michael Paquier - 2011-04-11

    Support of SSL protocol would need a certain effort to be implemented.
    Now PGXC pooler returns to postmaster child only a socket number which is used to send or read some data.

    In libpq, there is SSL support but most of the APIs need PGConn structures to work properly.
    It is necessary to do direct calls to libssl as the data present in child is only the socket number.

    There is always the solution to write and read data directly from pooler but this is absolutely to avoid as this will hugely impact performance.

     
  • Koichi Suzuki

    Koichi Suzuki - 2012-06-03
    • milestone: --> Development Queue
     
  • mason_s

    mason_s - 2012-06-03

    Just noting that I think it is probably better to have data nodes accessible only on an internal subnet and not have to worry about encrypted connections to data nodes. Coordinators can still accept encrypted connections, however, including coord-coord.

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.