[mythtv-users] PostgreSQL

[Brian Wood]

On Jul 2, 2006, at 8:49 PM, 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.
>
> Dan.

If you set up your UPS properly you do not have to worry about a  
"long" outage.

The UPS should send a message to the system when it gets to a  
specified amount of time left on the batteries which initiates a  
controlled shutdown of the system, including the database.

Just be sure that if you use your network to send such a message the  
routers, switches, hubs etc. that are needed to make the network  
operate are connected to the UPS. Generally a USB connection from the  
UPS to the system is best.

I know this is more or less obvious, but I wondered about your  
concern for the length of the outage.