• Tom Lane's avatar
    Allow SSL configuration to be updated at SIGHUP. · de41869b
    Tom Lane authored
    It is no longer necessary to restart the server to enable, disable,
    or reconfigure SSL.  Instead, we just create a new SSL_CTX struct
    (by re-reading all relevant files) whenever we get SIGHUP.  Testing
    shows that this is fast enough that it shouldn't be a problem.
    
    In conjunction with that, downgrade the logic that complains about
    pg_hba.conf "hostssl" lines when SSL isn't active: now that's just
    a warning condition not an error.
    
    An issue that still needs to be addressed is what shall we do with
    passphrase-protected server keys?  As this stands, the server would
    demand the passphrase again on every SIGHUP, which is certainly
    impractical.  But the case was only barely supported before, so that
    does not seem a sufficient reason to hold up committing this patch.
    
    Andreas Karlsson, reviewed by Michael Banck and Michael Paquier
    
    Discussion: https://postgr.es/m/556A6E8A.9030400@proxel.se
    de41869b
libpq-be.h 6.91 KB