malthe
Update Readme for SSL Config Option
Heyo, I'm back.
Struggled a bit to disable SSL as it wasn't described in the readme, just thought I'd highlight that for future users :)
The default is currently PREFER so that it will choose SSL if it is available, but accept a non-encrypted connection as well.
Understood, it kept disconnecting for me and then I was scratching my head for a long while before I was like I wonder if it has something to do with SSL and didn't notice it was an option.
Do you know how your PostgreSQL instance is configured with regards to SSL? Like why does it disconnect?
I was first using GCP for a little side project and it was giving me errors with SSL (not sure how to include certificates with this library either) and then setup a Digital Ocean cluster with a similar result.
I’ll see if I can go back into any logs and retrieve them.
On Sun, Apr 24, 2022 at 02:32 Malthe Borch @.***> wrote:
Do you know how your PostgreSQL instance is configured with regards to SSL? Like why does it disconnect?
— Reply to this email directly, view it on GitHub https://github.com/malthe/ts-postgres/issues/55#issuecomment-1107752335, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAHWAM4RV6QFPQ7REFPQTWTVGTTGTANCNFSM5UDNMA2Q . You are receiving this because you authored the thread.Message ID: @.***>
-- Sent from mobile device
GCP would presumably sign the certificate with a well-known root CA, so you should be fine out of the box with that one.
There's been some work since this issue was opened to better document SSL options. I'll close it out and feel free to reopen if there are other questions about how it works.