Re: How to determine a database is intact?

From: Wes <wespvp(at)syntegra(dot)com>
To: Vivek Khera <khera(at)kcilink(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to determine a database is intact?
Date: 2004-09-09 23:43:32
Message-ID: BD6654D4.10D18%wespvp@syntegra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/9/04 3:36 PM, "Vivek Khera" <khera(at)kcilink(dot)com> wrote:

> Gigabytes: 40+ currently (old data is pruned)
> Updates: jillions and jillions
> Inserts: several hundred millions
> Years: 3+
> Corruptions: 0
> Downtime: only for planned OS and Pg upgrades (7.1 -> 7.2 -> 7.4)
> OS: FreeBSD 4.x
> Hardware: Dell PowerEdge rackmount with SCSI hardware RAID
>
> I sleep well at night :-)

That is close to describing ours both size and hardware-wise, although it
will be growing significantly larger than that. I slept well until about a
week ago... The thing had been running for 9 months without a hit until
then.

I did say "most", not "all"... It's good to see specifics on DB's similar
in size to ours.

Wes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gaetano Mendola 2004-09-10 00:38:47 Re: Salt in encrypted password in pg_shadow
Previous Message Ennio-Sr 2004-09-09 23:03:37 Re: Display of text fields