3 hours ago
Hello Railway Support Team,
We are using Railway Hobby with an existing PostgreSQL service and Web service in the same staging environment.
Before performing a one-time forward-only database migration, we need to obtain a recoverable backup and independently verify restoration without changing the original database.
Our blockers are:
- Volume backup creation is restricted to Pro.
- We cannot independently verify the SSH gateway's host identity using a Railway-published host key or CA.
- The Dashboard SQL editor adds LIMIT to queries and cannot reliably execute our multi-statement transactional migration.
- The Web service's masked DATABASE_URL does not reveal whether it references the intended PostgreSQL service.
Could you recommend a supported Hobby-plan workflow for:
- Secure, encrypted PostgreSQL logical backup without exposing credentials.
- Independent restoration and verification without modifying the source database.
- A single transactional schema migration after backup recovery is verified.
- Confirming the Web-to-PostgreSQL reference without revealing secrets.
We prefer no public database exposure, no additional paid services, and no changes to production.
No credentials, private keys, database URLs, or customer data are included.
Thank you.
2 Replies
3 hours ago
This thread has been opened as a bounty so the community can help solve it.
Status changed to Open Railway • about 3 hours ago
3 hours ago
You can run a pg_dump command from the Console tab of your postgres service, and use the file browser to download the backup file from the same tab.
3 hours ago
You can also copy the public connection URL from the connect button > public network, and perform a backup using it.