6 hours ago
Hello Railway Support,
I need help recovering my PostgreSQL database.
My PostgreSQL service is currently showing NO DEPLOYMENT, but the existing attached volume is still present:
- Project:
secure-presence - Environment:
production - Service:
Postgres - Volume:
postgres-volume - Mount path:
/var/lib/postgresql/data - Storage used: approximately 120 MB / 500 MB
- Volume status: Ready
When I click Deploy database, Railway reports “There was an error deploying database” and no deployment is created.
The Railway CLI also confirms that the service has no active deployment, and volume file access is unavailable because an active deployment is required.
My trial has expired and Railway is asking me to pay for the Agent. I would like to avoid incurring a charge if possible.
Please help restore/redeploy the existing PostgreSQL service using the existing postgres-volume. Please do not delete, detach, replace, or initialize the existing volume, as it contains my production database.
My goal is to recover the database and create a PostgreSQL backup so I can migrate the application to another hosting provider.
Thank you.
5 Replies
6 hours ago
Your trial has ended and the workspace now has no plan, which is why deploys, including the Postgres redeploy, are being refused. There is no free option from this state. Subscribing to Hobby ($5/month, which includes $5 of usage) from the billing page is how services get running again.
Once the subscription is active, we automatically redeploy the deployments that were stopped for the trial ending. For Postgres that is a new deployment of the existing service using its previous deployment, not a new database. The attached postgres-volume is mounted, and nothing is created, replaced or restored. If Postgres does not come back on its own, clicking Deploy on the service works normally once the plan is active. After it is running, you can connect with its connection variables and take a pg_dump for your migration.
Status changed to Awaiting User Response Railway • about 6 hours ago
5 hours ago
Hello Railway Support,
I understand that my trial has ended and that the normal way to bring the PostgreSQL service back online is to subscribe to the Hobby plan.
Unfortunately, my available payment method is being rejected, so I am currently unable to activate the plan.
My concern is that the existing PostgreSQL service contains production data belonging to my clients who use my CBE school results system. The data includes learners' records, examination results, marks, classes, and other important school information.
The existing postgres-volume is still present and showing approximately 120 MB, and I do not want the database or volume to be deleted, replaced, initialized, or detached.
I urgently need access to the existing data so that I can recover it and ensure that my clients' information is not lost.
Could Railway Support please provide a way to temporarily access or export the existing PostgreSQL data from the existing volume, even if the service cannot be kept running permanently?
I am only requesting recovery of the data that is already stored on my existing volume. I am not asking Railway to create a new database.
This data is important to my clients, and I would greatly appreciate any recovery option you can provide.
Thank you.
Status changed to Awaiting Railway Response Railway • about 5 hours ago
5 hours ago
Your postgres-volume is still attached to the Postgres service and reads Ready with about 120 MB used, so nothing has been deleted or detached. We don't offer a way to open the volume or export its data on your behalf; reading it requires a running Postgres deployment.
Getting Postgres running again needs an active Hobby subscription, and that requires a bank-issued credit or debit card. Prepaid and virtual cards are not accepted. If your bank is declining the card, only your bank can tell you why, so the fix is either your bank approving the charge or a different bank-issued card. Retrying the same card won't change the result. Once the plan is active, Postgres redeploys on the existing volume and you can run a pg_dump with its connection variables.
Status changed to Awaiting User Response Railway • about 5 hours ago
Railway
Your `postgres-volume` is still attached to the Postgres service and reads Ready with about 120 MB used, so nothing has been deleted or detached. We don't offer a way to open the volume or export its data on your behalf; reading it requires a running Postgres deployment. Getting Postgres running again needs an active Hobby subscription, and that requires a bank-issued credit or debit card. Prepaid and virtual cards are not accepted. If your bank is declining the card, only your bank can tell you why, so the fix is either your bank approving the charge or a different bank-issued card. Retrying the same card won't change the result. Once the plan is active, Postgres redeploys on the existing volume and you can run a `pg_dump` with its connection variables.
5 hours ago
Thank you for clarifying.
I understand that the existing postgres-volume is still intact and that access to the data requires a running Postgres deployment.
Since the volume contains production data belonging to my clients, is there any possibility of a one-time data-recovery exception, temporary deployment, or other recovery mechanism that would allow me to export the existing database before the volume reaches its retention deadline?
I am not asking Railway to create a new database or restore data from somewhere else. I only need to recover the data that is already stored on my existing postgres-volume.
If a temporary deployment requires payment, could you please confirm whether there is any alternative specifically for recovering customer-owned data before it is permanently deleted?
I would be very grateful for any recovery option you can provide.
Status changed to Awaiting Railway Response Railway • about 5 hours ago
5 hours ago
We're not able to temporarily reactivate a service, grant read-only access to a stopped volume, or run a database dump for you on accounts whose trial has ended, even for a one-time recovery. The way back to your data is subscribing to Hobby on the billing page. Once the subscription is active, stopped deployments are redeployed and any volume still attached to the service is mounted, so you can run pg_dump yourself with its connection variables.
Subscriptions are paid by credit card, so getting the plan active depends on a card that your bank approves.
Status changed to Awaiting User Response Railway • about 5 hours ago