Unable to Connect to PostgreSQL from R-ECREATE Service
sachinrohit-vtech
PROOP

a year ago

Hi Railway Support,

I'm encountering a connection issue from my R-ECREATE service when trying to run npx prisma db pull. The build fails with the following error:

Error: P1001 Can't reach database server at autorack.proxy.rlwy.net:49158 Please make sure your database server is running at autorack.proxy.rlwy.net:49158.

Environment variables are properly loaded, and the Prisma schema is configured correctly. This is affecting the deployment of my service, and I suspect the Postgres instance might be unreachable or not running as expected.

Could you please assist in resolving this issue?

Thanks,
Megha

Solved

5 Replies

jake
EMPLOYEE

a year ago

Where is that URL coming from? I don't see it anywhere in your project

Status changed to Awaiting User Response Railway • 12 months ago

sachinrohit-vtech
PROOP

a year ago

Hi Jake,

Thanks for the follow-up!

The URL autorack.proxy.rlwy.net:49158 is the public pgpool URL provided by Railway for external PostgreSQL access. This is the endpoint exposed in the DATABASE_PUBLIC_URL environment variable on our PG-POOL service.

We’re using this public URL to connect Prisma to the managed PostgreSQL instance from outside the Railway environment.

Please let us know if there's any configuration change or downtime on that proxy endpoint — we’ve verified the schema and env variables are set up correctly on our side.

Thanks again,
Megha

Status changed to Awaiting Railway Response Railway • 12 months ago

parmstar
EMPLOYEE

a year ago

Are you still having an issue here?

Status changed to Awaiting User Response Railway • 11 months ago

sachinrohit-vtech
PROOP

a year ago

Yes we are still facing issues in Connecting with PGPool, when we saw PGPool logs we are seeing too many clients already error

Can you help us in resolving this , is there any settings which we can change to resolve this issue

Status changed to Awaiting Railway Response Railway • 11 months ago

brody
EMPLOYEE

a year ago

Hello,

I am able to connect to pgpool just fine, meaning this is an application or configuration level issue on your side, unfortunately, due to volume we are only able to answer questions that are strictly related to the Railway platform or product.

We wish you all the best as you debug this configuration issue.

Best,
Brody

+11

Status changed to Awaiting User Response Railway • 11 months ago

Railway
BOT

7 months ago

This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!

Status changed to Solved Railway • 7 months ago

Loading...