Re: Error while recovering a database - Mailing list pgsql-general

From nconway@klamath.dyndns.org (Neil Conway)
Subject Re: Error while recovering a database
Date
Msg-id 20020724142819.GA14859@klamath.dyndns.org
Whole thread Raw
In response to Error while recovering a database  (Jorge Sarmiento <jsarmiento@ccom.org>)
List pgsql-general
On Wed, Jul 24, 2002 at 09:21:03AM -0400, Jorge Sarmiento wrote:
> While I was recovering a previuos dumped database I got this error:
>
> ERROR:  HASH: Out of overflow pages.  Out of luck.

Don't use hash indexes, they are badly broken.

If you drop the hash index that is causing the error and replace it
with a btree, it should work.

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Jorge Sarmiento
Date:
Subject: Error while recovering a database
Next
From: Andrew Sullivan
Date:
Subject: Re: Postgres 7.3