2 hours ago
How can I export a PostgreSQL database with pg_dump and test the restore on a separate instance without exposing the database publicly? I’m on the Trial plan, and my work environment cannot resolve ssh.railway.com. Is there a browser-based option or another supported way to do this over the private network?
3 Replies
2 hours ago
Services in the same project and environment can reach your database over the private network at its .railway.internal hostname on port 5432. That means a second PostgreSQL service deployed alongside it can act as your test instance, and a pg_dump run from inside that project can stream directly into it without adding a TCP proxy or exposing anything publicly. See private networking.
The dashboard's in-browser Console and file access use the same SSH connection as the CLI, so they won't work around a network that can't resolve ssh.railway.com.
Built-in volume backups and restores, including the Back Up Now and restore controls, require the Pro plan. On Trial (and Hobby) they return Not Authorized, so the pg_dump route above is the option available to you right now.
Status changed to Awaiting User Response Railway • about 2 hours ago
Railway
Services in the same project and environment can reach your database over the private network at its `.railway.internal` hostname on port 5432. That means a second PostgreSQL service deployed alongside it can act as your test instance, and a `pg_dump` run from inside that project can stream directly into it without adding a TCP proxy or exposing anything publicly. See [private networking](https://docs.railway.com/networking/private-networking). The dashboard's in-browser Console and file access use the same SSH connection as the CLI, so they won't work around a network that can't resolve `ssh.railway.com`. Built-in volume backups and restores, including the Back Up Now and restore controls, require the Pro plan. On Trial (and Hobby) they return Not Authorized, so the `pg_dump` route above is the option available to you right now.
2 hours ago
My work environment cannot reach ssh.railway.com, and I only have an iPhone. On the Trial plan, is there a supported way to run a one-off pg_dump job inside the existing Railway project without SSH, without a public TCP proxy, and without a new paid service? Please share the exact steps if this is possible.
Status changed to Awaiting Railway Response Railway • about 2 hours ago
2 hours ago
We don't have a supported way to run a one-off pg_dump inside your project from an iPhone under all three of those constraints. The dashboard Console and file access use the same SSH connection as the CLI, so they aren't available from a network that can't reach ssh.railway.com, and we don't offer a separate browser-based job runner for this.
Built-in volume backups and restores also aren't available on the Trial plan, so we don't have a Trial option that covers this export-and-test-restore workflow without SSH or a public TCP proxy.
Status changed to Awaiting User Response Railway • about 2 hours ago