Re: newbie qs; fixing and checking databases

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Rusty Wright <rusty(at)socrates(dot)Berkeley(dot)EDU>, pgsql-admin(at)postgresql(dot)org
Subject: Re: newbie qs; fixing and checking databases
Date: 2002-10-16 06:34:24
Message-ID: Pine.LNX.4.21.0210160726410.20427-100000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, 15 Oct 2002, Tom Lane wrote:

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Rusty Wright wrote:
> >> Are there commands provided with postgresql for checking the databases
> >> and also for repairing them?
>
> > We don't have checks because thing rarely break.
>
> Or at least: there are seldom any programmable-in-advance patterns to
> our failures. We prefer to put our efforts into preventing problems
> rather than cleaning up after 'em...

Does this question mean that there known, detectable data integrity (not
referential integrity) problems with MySQL?

Wondering because it seems an odd question to me and it could be a factor in a
descision, although the number of MySQL installations out there one would have
to there is no problem or all those web sites surely would be terribly unhappy.

[Note, I have no intention of starting a DB war this is a genuine interest from
a complete MySQL newbie who's got to look at it on a best tool for the project
basis.]

--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shridhar Daithankar 2002-10-16 06:39:34 Re: [HACKERS] [GENERAL] Postgres-based system to run .org registry?
Previous Message Andreas Schmitz 2002-10-16 06:22:41 Re: problems dumping