[mythtv-users] PostgreSQL

[Stuart Johnston]

Danny Brow wrote:
> 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.

You might want to try setting the flush option on your mysql server. 
That should help avoid data inconsistencies when the server goes down 
unexpectedly.

http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html