Re: newbie qs; fixing and checking databases - Mailing list pgsql-admin

From Tom Lane
Subject Re: newbie qs; fixing and checking databases
Date
Msg-id 20585.1034738297@sss.pgh.pa.us
Whole thread Raw
In response to Re: newbie qs; fixing and checking databases  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: newbie qs; fixing and checking databases  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-admin
Bruce Momjian <pgman@candle.pha.pa.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...

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: How do I restore data changes made after the backup?
Next
From: Bhuvan A
Date:
Subject: Re: function in place of sub-select