23 days ago
Hello Railway team,
I need assistance recovering/exporting data from a PostgreSQL service that was previously running on my Railway project.
My Railway trial has expired, and the PostgreSQL service is no longer accessible. However, the PostgreSQL persistent volume still appears to exist and is shown as ready.
I am migrating my application from Railway PostgreSQL to Cloudflare D1 and need to safely recover the existing production database data before completing the migration.
I am not requesting ongoing free hosting, and I am not asking Railway to delete, reset, or modify the database or persistent volume.
I would like to know whether Railway can provide a supported way to temporarily restore access to the existing PostgreSQL data, or provide a database export/snapshot, so I can safely recover the data.
The database is approximately 117 MB.
Could you please advise:
Whether the existing PostgreSQL data on the persistent volume can still be recovered.
Whether Railway can temporarily restore database access or provide an export/snapshot.
What the officially supported recovery procedure would be.
Whether this can be done without deleting or recreating the existing PostgreSQL volume.
I would greatly appreciate any assistance in recovering the existing data so I can complete the migration safely.
Thank you.
1 Replies
23 days ago
Your PostgreSQL data is safe. The persistent volume is still attached to the Postgres service, in a ready state, and holds your ~117 MB of data. To regain access, subscribe to the Hobby plan ($5/month, which includes $5 of usage) from your workspace billing page, which will let the Postgres service run again with the existing volume data intact. Once it is running, you can connect and use pg_dump to export everything you need for your migration.
Status changed to Awaiting User Response Railway • 23 days ago
16 days 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 • 16 days ago