Database corruption

Posted on
Fri Aug 10, 2018 6:37 am
lochnesz offline
Posts: 288
Joined: Oct 01, 2014
Location: Stockholm, Sweden

Database corruption

I run SQLite as database with SQL Logger. Every time there is a power cut, the database gets corrupted. Is there a difference between SQLite and PostgreSQL regarding how well they handle power cuts/unexpected shoutdowns?

Thanks!

Peter

Posted on
Fri Aug 10, 2018 6:46 am
matt (support) offline
Site Admin
User avatar
Posts: 18464
Joined: Jan 27, 2003
Location: Texas

Re: Database corruption

Yes. I'm pretty sure you won't have any problems with PostgreSQL in that regards. It is significantly more robust.

Image

Posted on
Fri Aug 10, 2018 6:48 am
lochnesz offline
Posts: 288
Joined: Oct 01, 2014
Location: Stockholm, Sweden

Re: Database corruption

I'll change to PostgreSQL then.

Thanks!

Posted on
Fri Aug 10, 2018 9:00 am
jay (support) offline
Site Admin
User avatar
Posts: 14408
Joined: Mar 19, 2008
Location: Austin, Texas

Re: Database corruption

Or get a UPS for your Indigo Server Mac and have it do an orderly shutdown when necessary. That would also protect your Mac hardware.

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Posted on
Fri Aug 10, 2018 9:12 am
lochnesz offline
Posts: 288
Joined: Oct 01, 2014
Location: Stockholm, Sweden

Re: Database corruption

jay (support) wrote:
Or get a UPS for your Indigo Server Mac and have it do an orderly shutdown when necessary. That would also protect your Mac hardware.
I have one which is broken and will be replaced, however it is not rare with longer power cuts than a "home" ups can handle in the area.

Skickat från min SM-G960F via Tapatalk

Posted on
Fri Aug 10, 2018 9:25 am
jay (support) offline
Site Admin
User avatar
Posts: 14408
Joined: Mar 19, 2008
Location: Austin, Texas

Re: Database corruption

But UPSs with USB ports can be connected to the Mac and the Mac can then perform an orderly shutdown (which will avoid the corruption issue) when the battery on the UPS gets low.

Jay (Indigo Support)
Twitter | Facebook | LinkedIn

Posted on
Fri Aug 10, 2018 9:36 am
lochnesz offline
Posts: 288
Joined: Oct 01, 2014
Location: Stockholm, Sweden

Re: Database corruption

Yes, the new ups will have a USB port for sure.

Skickat från min SM-G960F via Tapatalk

Posted on
Fri Aug 10, 2018 4:48 pm
siclark offline
Posts: 378
Joined: Jun 13, 2017
Location: UK

Re: Database corruption

Depending on how most history you have in the corrupt sqlite db and how much you want to keep it, you may have some luck with Karl's utilities and fixing the corruption, then migrating to postgres app. It worked for me several times. Take a long time to run though

Either way there almost needs to be a indigo newbie guide that explains that the 30 mins to set up postgres app right at the start is really worth it to avoid this pain later. I can't recommend it enough.


Sent from my iPhone using Tapatalk

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 0 guests