Re: Error while recovering a database

From: nconway(at)klamath(dot)dyndns(dot)org (Neil Conway)
To: jsarmiento(at)camaralima(dot)org(dot)pe
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error while recovering a database
Date: 2002-07-24 14:28:19
Message-ID: 20020724142819.GA14859@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)rogers(dot)com>
PGP Key ID: DB3C29FC

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2002-07-24 14:39:50 Re: Postgres 7.3
Previous Message Elielson Fontanezi 2002-07-24 14:21:18 Postgres 7.3