setup a pipedream postgres account with a railway postgres db

artivilla

HOBBYOP

2 years ago

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

artivilla

HOBBYOP

2 years ago

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

brody

EMPLOYEE

2 years 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

artivilla

HOBBYOP

2 years ago

Oh. It's not recommended. why is that?

artivilla

HOBBYOP

2 years ago

Can I not provide SSL CA Bundle, SSL Private Key, and SSL Client Certificate?

artivilla

HOBBYOP

2 years ago

Also what do I set for Use Shared Static IP ?

brody

EMPLOYEE

2 years ago

because it's less secure

brody

EMPLOYEE

2 years ago

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

brody

EMPLOYEE

2 years ago

that is only available on the Pro plan

artivilla

HOBBYOP

2 years ago

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

1259257814514143500

artivilla

HOBBYOP

2 years ago

think it worked 🙂

brody

EMPLOYEE

2 years ago

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