do you get that error locally?

no, for local I am using external url for db

so did not got this error

postgresql://postgres:PASSWORD@pgvector.railway.internal:45850/railway

this is my connection string if its of any help. I have replaced actual password with PASSWORD

the following connection string is working

postgresql://postgres:PASSWORD@autorack.proxy.rlwy.net:45850/railway

locally internal networking is not working

you are using the private url locally, you need to use the public url

using public url locally

the issue I am facing is for the one hosted on railway

using internal url

please check this healthcheck endpoint

https://betterfaq-production.up.railway.app/healthz

// src/routes/healthz/+server.js
import { sql } from '$lib/server/db/client';
import { json } from '@sveltejs/kit';

export async function GET() {
    try {
        await sql`SELECT 1'`;
        return json({ status: 'OK' }, { status: 200 });
    } catch (error) {
        // Check if the error is an instance of Error
        const errorMessage = error instanceof Error ? error.message : 'Unknown error';
        return json({ status: 'Service Unavailable', error: errorMessage }, { status: 503 });
    }
}

code for healthcheck endpoint which only checks if db is connected or not

===

just to reiterate, using internal for connecting the application hosted on railway and db is also hosted on railway

may i ask why you showed a screenshot of you attempting to connect to the private url locally?

do you get that error locally?

I mentioned that both are hosted on railway, because you asked this.

sorry, english is not my first language

your database and app are in different projects right? if so, they need to be in the same project

yes, they are different projects.

any way to combine those?

it would be a manual process

thanks, I'll look it up

look what up?

how to do this

you already have, just do it in the correct project this time

got it, thanks

for the future, please read this docs page -