Re: [GENERAL] verifying database integrity?

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Valerie Mates <popcorn(at)tir(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] verifying database integrity?
Date: 1999-06-08 18:21:21
Message-ID: 375D5F21.14A1BB7@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Valerie Mates wrote:
>
> Hi -- Some clod turned off the power to my customer's computer -- a Linux
> box with a Postgres server on it -- while it was running. Ever since then,
> certain PostgreSQL queries have been very slow. We wonder how to tell if
> the database was damaged. Is there a program we can run to check the
> integrity of the database? (And is this the right list for me to ask this
> question on?)

Rebuild your indices.
Run vacuum verbose.

Vadim

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 1999-06-08 18:23:07 PostgreSQL, Inc: The Mission Statement ...
Previous Message The Hermit Hacker 1999-06-08 18:18:35 New Support Level: Per Incident