Обсуждение: Error while recovering a database

Поиск
Список
Период
Сортировка

Error while recovering a database

От
Jorge Sarmiento
Дата:
While I was recovering a previuos dumped database I got this error:

ERROR:  HASH: Out of overflow pages.  Out of luck.

What does it mean? I got no idea...

thanx in advance!

Jorge S.



Re: Error while recovering a database

От
nconway@klamath.dyndns.org (Neil Conway)
Дата:
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