deleted my postgres database by accident, any way to recover?
title says it all :p
Solution:Jump to solution
but the final answer would be, if you didn't take a database backup yourself and you where responsible for the data loss, the data is unfortunately gone
44 Replies
Project ID:
N/A
is there anyway i can download the logs for a week? i can recover my database from that
maybe try using this:
https://bookmarklets.up.railway.app/log-downloader/
F
do you work for gitlab?
I'm just wondering
nope
its a side project and i was messing with some dangerous sql queries hehe but wanted to recover
alright, "the gitlab employee" is just a reference to the 2017 accident when they deleted production db
its hard to host a database at railway because of the no backup thing
there is a backup template though
Solution
but the final answer would be, if you didn't take a database backup yourself and you where responsible for the data loss, the data is unfortunately gone
@Brody In this article https://blog.railway.app/p/launch-01-next-gen-databases there is mentioned "In the future, we plan to add native support for database backups and high availability by following the same pattern: Add the primitives that can be used by anyone.".
Railway Blog
The Future of Databases is Services
Starting today, it’s now possible to deploy ANY type of database on Railway, including new technologies like PGVector, Chroma, Temporal, etc.
Is there any ETA on when native backups will be made possible?
no sorry I don't have an eta
Hi, unfortunately I'm in the same boat... I had two projects open and deleted my instance of psql from the wrong one. I do still have a volume, 'Postgres data' which is present in my project dashboard and I can 'mount to service'. Is there any way that I can use this to restore the previous data? Thanks in advance for any help!