a month ago
Hello Railway Support,
I need urgent help recovering production PostgreSQL data.
Project: spirited-radiance (production)
Project ID: 8073fd28-63fb-461b-8582-b2d79fffc21b
Website: https://khanbabadryfruits.com
API: https://api.khanbabadryfruits.com
WHAT HAPPENED:
- June 11, 2026 ~12:50 PM PKT: postgres-volume hit 100% (5 GB full)
- Postgres crashed: "No space left on device", "recovery mode"
- Website went down — products/categories HTTP 500
WHAT WE DID:
- Upgraded to Pro Plan, resized volume
- PITR restore created: Postgres-restored-20260611-0826
- api-server connected — health check OK: {"ok":true,"status":"ready"}
CURRENT PROBLEM:
- Database connects but ALL data is missing (0 products, 0 categories)
- Website shows "0 products found"
- pgBackRest backup (20260611-082553F) is only ~7 MB — taken AFTER crash, empty DB
- Original production data was ~5 GB before crash
WHAT WE NEED:
Please recover PostgreSQL data from BEFORE June 11 disk-full crash.
Ideal recovery point: June 10, 2026, 11:59 PM PKT
WAL archiving was enabled on original Postgres (WAL_ARCHIVE_* variables set).
Please use WAL archive bucket for PITR if available.
IMPORTANT: Do NOT delete postgres-volume or either Postgres service until recovery confirmed.
This is a live e-commerce business. Please prioritize.
Thank you.
2 Replies
a month ago
This thread has been opened as a public bounty so the community can help solve it. The thread and any further activity are now visible to everyone.
Status changed to Open Railway • 26 days ago
a month ago
i need urgently help
Status changed to Open brody • 26 days ago
a month ago
Hello Railway Support Team,
I urgently need your assistance regarding a serious data loss issue after restoring my project.
My project and PostgreSQL database were restored successfully, and I can see that all database tables still exist. However, the actual data inside those tables appears to be missing.
The affected data includes:
- Products
- Categories
- Blog Posts
- Banners
- Store Content
- Other production data
Before the incident, my store was fully operational and contained a large amount of manually uploaded content. I have spent significant time and effort building this data over many months.
I recently upgraded my Railway plan to the $20/month plan, and after the project restore process, the database structure remained intact, but the records themselves appear to be gone.
Could you please investigate the following:
- Whether the database was restored from the correct snapshot.
- Whether an older backup containing my production data is available.
- Whether the project was connected to a new/empty database during the restore process.
- Whether any automatic migration, reset, or restore operation may have caused the records to disappear.
- Whether Railway can recover the most recent backup containing my original production data.
This is a production e-commerce system, and the missing data includes products, categories, blog posts, and other business-critical content.
Please escalate this case and help me recover the latest available backup containing my original data.
I would greatly appreciate an urgent investigation, as this data represents a substantial amount of work and business value.
Thank you.