Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iKyDU-00041u-T6 for pgsql-admin@arkaria.postgresql.org; Thu, 17 Oct 2019 05:20:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iKyDT-0004z7-My for pgsql-admin@arkaria.postgresql.org; Thu, 17 Oct 2019 05:20:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iKyDT-0004yv-Cd for pgsql-admin@lists.postgresql.org; Thu, 17 Oct 2019 05:20:51 +0000 Received: from ook.raf.org ([139.99.156.21]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iKyDQ-00019h-2Q for pgsql-admin@postgresql.org; Thu, 17 Oct 2019 05:20:50 +0000 Received: from localhost (localhost [127.0.0.1]) by ook.raf.org (Postfix) with ESMTP id 7E6AF5DD18 for ; Thu, 17 Oct 2019 16:20:43 +1100 (AEDT) X-Virus-Scanned: Debian amavisd-new at ook.raf.org Received: from ook.raf.org ([127.0.0.1]) by localhost (ook.raf.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id CvaWSiwi7vPB for ; Thu, 17 Oct 2019 16:20:42 +1100 (AEDT) Received: by ook.raf.org (Postfix, from userid 1001) id 6467E5DEA4; Thu, 17 Oct 2019 16:20:42 +1100 (AEDT) Date: Thu, 17 Oct 2019 16:20:42 +1100 From: raf To: pgsql-admin@postgresql.org Subject: How to change the TLS certificate/key without restarting the server? Message-ID: <20191017052042.ombzxzwzo7xet47t@raf.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, https://www.postgresql.org/docs/12/ssl-tcp.html says: "Using a passphrase also disables the ability to change the server's SSL configuration without a server restart." How is key TLS key changed without a server restart? Is replacing the server.crt/server.key files enough or is there more to it? And will existing connections continue to use the old key until they disconnect? cheers, raf