I delete my live prod database and have no backup

tehaisperlis

Hazmi Irfan

Posted on February 20, 2021

I delete my live prod database and have no backup

Welp. That just happen. I just deleted my live production database and I don't have a backup.

Yesterday I completed my new website Logname and decided to tell everyone I can about the website(Reddit, Hackernews etc).

After a day has passed, I want to see how many people register. Me being lazy without admin interface I figured I can login to postgres and query it directly.

I hosted it on heroku so I can just use this command heroku pg:psql <database-name> --app <app-name>

I already run this on terminal so I quickly go to previous history and press enter when I see pg command.

I forgot that earlier I had run this command heroku pg:reset <database-name> --confirm <app-name>

So now my database has successfully reset and I have lost all of my user if any.

Honestly I am mad as hell right now and I feel ashamed to people who tried to use my website.

One of the reason I build this website is so that user can rely on this website to maintain their info for a long time because resume is not something u need often but urgent when needed.

To all who register to give the website a try, I'm really sorry but you need to register and insert the data again but rest assured that this won't happen again.

💖 💪 🙅 🚩
tehaisperlis
Hazmi Irfan

Posted on February 20, 2021

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related