Re: disaster recovery

From: Alex Satrapa <alex(at)lintelsys(dot)com(dot)au>
To: Craig O'Shannessy <craig(at)ucw(dot)com(dot)au>
Cc: "Pgsql (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: disaster recovery
Date: 2003-11-28 02:18:34
Message-ID: 3FC6B07A.4070603@lintelsys.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Craig O'Shannessy wrote:
> Never had a kernel panic? I've had a few. Probably flakey hardware. I
> feel safer since journalling file systems hit linux.

The only kernel panic I've ever had was when playing with a development
version of the kernel (2.3.x). Never played with development kernels
since then - I'm a user, not a developer.

All the outages I've experienced so far have been due to external
factors such as (in order of frequency):
- Colocation facility technicians repatching panels and
putting my connection "back" into the wrong port
- Colo facility power failure (we were told they had dual
redundant diesel+battery UPS, but they only had one, the
second was being installed "any time now")
- End user's machines crashing
- Client software crashing
- Colo facility techs ripping power cables or network
cables while "cleaning up" cable trays
- Hard drive failure (hard, fast and very real - one
revolution the drive was working, the next it was a
charred blackened mess of fibreglass, silicon and
aluminium)

I have to admit that in none of those cases would synchronous vs
asynchronous, journalling vs non-journalling or *any* file system
decision have made the slightest jot of a difference to the integrity of
my data.

I've yet to experience a CPU failure (touch wood!).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Randolf Richardson 2003-11-28 04:44:22 Re: Open source data modeling tools for PostgreSQL
Previous Message Christopher Browne 2003-11-28 02:06:25 Re: Postgresql on file system EXT2 or EXT3