WTH does restoring a full backup take soooooooooo long?

I can’t understand why it takes so long to restore a backup, even of modest size… and restoring my huge 4Gb backup in the move from ODroid to Intel/Proxmox is apparently going to take the rest of my life, in all probability.

Related, but not a duplicate: WTH Is there no progress indication when restoring a backup? - Month of “What the heck?!” - Home Assistant Community

It’s restoring your database, omit the database and it takes 2 minutes.

1 Like

It’s restoring your database, omit the database and it takes 2 minutes.

Why would I want to omit the database from a restore of a full backup? Where’s the continuity there? And in that case, why does it take soooooo long to restore the database with so few system resources being used?

First time experiencing large databases? Large databased + slow computers = slow operations.

I have a 2gb database, when compressed my backups are about a gig. My restore process is about 3 minutes on a NUC I5. If you’re running on a Pi, those speeds will be significantly longer with those sizes.

1 Like

First time experiencing large databases?

Some experience… exceeding 40 years, actually. One of my database technologies sits behind a large proportion of the world’s email servers.

This isn’t particularly large. And the use of system resources is pitiful.

Not a Pi, as I said in my original message. This is an Intel i7 6700, 32Gb RAM, SSDs. CPU usage hovering around 50%, as is RAM usage.

Over 5 hours so far for this restore. No idea when it’s going to end or how long it’s going to take.

By all means, if you know how to optimize the process, lend your expertise. Right now, one of our best manages this system and this is where we are.

I might well do that once I have some post-retirement time. But your previous responses don’t exactly throw open the door and invite or welcome outside help.

I started this thread with a perfectly reasonable complaint, under a nice open forum concept that I thought was aiming to garner useful general feedback that might guide future developments. I linked to another related complaint, the resolution of which might at least give some feedback as to the progress of a long restore.

“That’s just the way it is” and “Don’t use slow hardware” weren’t really helpful responses. Just an observation…

My man, I’m just providing information. It’s up to you to see that as negative or positive information. Nothing in my posts was negative or had any implications in regards to implementation or lack-of implementation.

1 Like

is this time always the same for you?
I experience restoring the same backup sometimes takes minutes, other times takes hours. I don’t know the root cause for this, and yes I am using a pi. And since I only need to restore backups once a year, I voted for the progress bar thing which in my case has more value.

It’s usually the same time for me, but I rarely perform a full restore (once a year). I usually restore specific things that break (like addons), or I roll back if there hasn’t been database changes. A roll back takes 5 seconds.

As I said, this is a machine migration. The uncertain duration and lack of progress feedback makes it rather a difficult operation to plan for.

I was replying to bkbartk who replied to my post.

I think my biggest complaint isn’t the time, is the lack of any indicator of progress. Because genuinely, sometimes it isn’t doing a restore at all, because of something or other, but you don’t know until many hours later when it just hasn’t finished.

2 Likes

Yep, there’s a WTH for a progress bar, go give it a vote

1 Like

Thanks for letting me know! I am in the process of digging through all the WTH that I can find, but in the future when telling someone to vote for a specific thing, it might be helpful to link directly to it…

Sorry, I spend most of my time here searching for links and marking duplicates. Forgive me for not wanting to do it for you.

it’s in the first post of this topic already

the behaviar might be different for a partial restore indeed,
usually, in the past I needed to do a full restore because of of hardware change.

but still, I think adding an indicator would be more useful

Yep, I agree. Although I’m not sure how that would work when the system is actively restarting while it should be posting a progress bar.

Wait, you guys are able to get backups to actually restore?

I tried a few times and found it was easier to restart from scratch than it was to try and figure out why a backup wouldn’t restore. I would LOVE to see some way where you could backup without statistics or whatever balloons the database. I really just care about restoring the configuration and devices so they all match up with their same IDs and everything, but there doesn’t seem to be any customizations available for backups. I’m not sure if the restoration process has been improved at all to allow us to pick what gets restored. I just hope that I never have to restore :frowning: