private networking plsql
diegodlpereira
HOBBYOP

9 months ago

Hey everyone! šŸ‘‹

I'm trying to run psql commands against a PostgreSQL service in Railway that has only Private Networking enabled (Hobby plan). Since there's no Shell tab or SSH access, I'm wondering how others usually handle this.

What I’ve tried/considered:

  • Using a helper Docker service that runs psql on startup and logs the output

  • Exploring tools like pgweb or Adminer deployed as a Railway service

  • Temporarily exposing the DB publicly (not ideal)

šŸ” My main goal is to run ad-hoc SQL queries (e.g., inspect schema, test data) from outside, without having public access enabled.

Question: What workarounds or approaches have you used to connect to a private Postgres from outside Railway?

Would love to hear how others solve this. Thanks!

Solved$10 Bounty

8 Replies

diegodlpereira
HOBBYOP

9 months ago

project id dcaa9ad9-d0a7-4e8c-b18f-c6b9d7513652


samgordon
PRO

9 months ago

You want public access without public access?


samgordon
PRO

9 months ago

That seems like a double negative


samgordon
PRO

9 months ago

And SSH access is a thing



samgordon
PRO

9 months ago

Public != anyone can access and upload


diegodlpereira
HOBBYOP

9 months ago

Awesome! The SSH function does the trick to me šŸ˜‰


diegodlpereira
HOBBYOP

9 months ago

Thank youuu


Status changed to Solved brody • 9 months ago


Loading...