Re: newbie qs; fixing and checking databases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: 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 03:18:17
Message-ID: 20585.1034738297@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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...

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bhuvan A 2002-10-16 04:43:37 Re: function in place of sub-select
Previous Message Tom Lane 2002-10-16 03:03:58 Re: How do I restore data changes made after the backup?