[mythtv-users] PostgreSQL

Danny Brow dan at fullmotions.com
Mon Jul 3 02:49:08 UTC 2006


I was looking for an alternative to mysql for a reason, I've yet to have
mysql last for longer then a few weeks on any applications that uses it.
I've used a few different applications that use mysql db, they all have
the same issue, power outage is the worst thing that can happen to mysql
and when it does it takes time that I don't have to fix it. Unlike mysql
PostgreSQL is rock solid, I've had a lot power outages, system
shutdowns, user error, anything that can take down a server and
PostgreSQL comes right back up, with no problems. Out of around 200 DB's
running PostgreSQL over the last few years I've only had to restore
twice from back up, once for corruption and the other time from hard
drive failure (system upgrades not included). This is why I want to use
PostgreSQL. MySQL is only good when a system will never turn off or the
db is never shutdown. I'm investing into a UPS for my MythTV box for
just that reason, just hope we don't get a long power outage around
here.

Dan.


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.



More information about the mythtv-users mailing list