PLEASE STOP SENDING - NOT INTERESTEDFrom: Martin Goodson <kaemaril(at)googlemail(dot)com>Sent: Fri, 06 Dec 2019 18:55:43To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>Subject: SSL - automatic entry of certificate passphrase in PostgreSQL 10?Hello.Apologies if this is an easy one, I've been looking around but clearlymy google-fu may be weak :)I've recently been asked to enable ssl support on one of our PostgreSQL10 databases, which I've done. However, the certificate I was givenappears to have been generated using a passphrase, and now during serverstart I'm being prompted (as expected) for that passphrase.I'm concerned that this is going to impact the automatic (re)start ofthe database after server shutdowns, crashes etc. I understand thatthere is functionality to support this in PostgreSQL 11 with thessl_passphrase_command parameter, but I was wondering if there's a wayto emulate this in PostgreSQL 10 or any kind of workaround?Or am I stuck with either requesting a new certificate without thepassphrase or going to PostgreSQL 11?For information, it's a PostgreSQL 10.5 cluster hosted on a VM runningRHEL 7.6.Many thanks!--Martin GoodsonIn bed above we're deep asleep,While greater love lies further deep.This dream must end, the world must know,We all depend on the beast below.