@shopify/shopify-app-session-storage-postgresql : error: no pg_hba.conf entry for host

[scraper095]

Issue summary

I tried to change the session storage from prisma to my postgresql,
I am using the same connection string as in the app itself, where everything works as expected.
In this case, i get the error:

error: no pg_hba.conf entry for host x, user y, database z, no encryption

as if it's ignoring ssl totally.
I have certs set up and use ssl_mode=require in my db string.

• @shopify/shopify-app-* package and version:2.0.2
• Node version:v18.18.2
• Operating system:mac

Expected behavior

Should set up the session storage normally via ssl.

Can't connect

Steps to reproduce the problem

1. Set app sessionStorage as PostgreSQLSessionStorage
2. Try to connect it with ssl

[scraper095]

update:
ended up patching the package with this solution:
#437

[github-actions]

This issue is stale because it has been open for 90 days with no activity. It will be closed if no further action occurs in 14 days.

[lmartins]

Looks like this is still a problem with the latest version 3.0.0. Any options other than patching the library?

[github-actions]

We're labeling this issue as stale because there hasn't been any activity on it for 60 days. While the issue will stay open and we hope to resolve it, this helps us prioritize community requests.

You can add a comment to remove the label if it's still relevant, and we can re-evaluate it.