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](https://cdn.answeroverflow.com/1259252496027750491/image.png)
![No description](https://cdn.answeroverflow.com/1259252496531198096/cleanshot_2024-07-04_at_08.png)
Solution:Jump to 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
8 Replies
Project ID:
2397ca9e-3cc9-4715-a02c-d2be99c3dedf
projectID: 2397ca9e-3cc9-4715-a02c-d2be99c3dedf
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
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 ?
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
what's the username/pwd? postgres user/ postgres pwd or pguser/pgpassword ?
![No description](https://cdn.answeroverflow.com/1259257814514143364/CleanShot_2024-07-06_at_14.16.44.png)
think it worked 🙂
fwiw both username and password variables are the same, one is a reference to the other, they are just there for backwards compatibility