Signed SSL Certificate Errors with postgresql database (all self hosted)

It’s not localhost, but certbot do have a guide Certificates for localhost - Let's Encrypt

I use two hooks one to finalize and one to take that certificate and create one that Postgres can use.