R
Railway•5mo ago
Arti Villa

setup a pipedream postgres account with a railway postgres db

I got a postgres server up on railway but I don't know what configurations I need to set in pipedream to get this connection to work. have not added any optional fields and was set to full verification. p.s using this service for the first time. mostly a vercel user i.e don't know much about infra setup.
No description
No description
Solution:
the Postgres databases that are one-click deploys use self signed certificates, as per the instructions in your screenshot you will need to reconnect with skip verification enabled
Jump to solution
8 Replies
Percy
Percy•5mo ago
Project ID: 2397ca9e-3cc9-4715-a02c-d2be99c3dedf
Arti Villa
Arti VillaOP•5mo ago
projectID: 2397ca9e-3cc9-4715-a02c-d2be99c3dedf
Solution
Brody
Brody•5mo ago
the Postgres databases that are one-click deploys use self signed certificates, as per the instructions in your screenshot you will need to reconnect with skip verification enabled
Arti Villa
Arti VillaOP•5mo ago
Oh. It's not recommended. why is that? Can I not provide SSL CA Bundle, SSL Private Key, and SSL Client Certificate? Also what do I set for Use Shared Static IP ?
Brody
Brody•5mo ago
because it's less secure how would you do that? the database is using an internally self-signed certificate that is only available on the Pro plan
Arti Villa
Arti VillaOP•5mo ago
what's the username/pwd? postgres user/ postgres pwd or pguser/pgpassword ?
No description
Arti Villa
Arti VillaOP•5mo ago
think it worked 🙂
Brody
Brody•5mo ago
fwiw both username and password variables are the same, one is a reference to the other, they are just there for backwards compatibility
Want results from more Discord servers?
Add your server