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.

11 Replies

projectID: 2397ca9e-3cc9-4715-a02c-d2be99c3dedf


brody
EMPLOYEE

a year 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


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
EMPLOYEE

a year ago

because it's less secure


brody
EMPLOYEE

a year ago

how would you do that? the database is using an internally self-signed certificate


brody
EMPLOYEE

a year ago

that is only available on the Pro plan


what's the username/pwd? postgres user/ postgres pwd or pguser/pgpassword ?

1259257814514143500


think it worked 🙂


brody
EMPLOYEE

a year ago

fwiw both username and password variables are the same, one is a reference to the other, they are just there for backwards compatibility


Loading...