Re: Out of memory error on pg_restore

From: "Guillaume Lelarge" <guillaume(dot)lelarge(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Out of memory error on pg_restore
Date: 2006-03-10 08:17:09
Message-ID: d854adec0603100017j68ac1134r@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

8 Mar 2006 07:31:19 -0800, Nik <XLPizza(at)gmail(dot)com>:
> [...]
> psql: ERROR: out of memory
> DETAIL: Failed on request of size 32.
>

I also have this kind of error (out of memory) during the restoration
of objects on my database. I use a 8.1.2 pg_dump on a 7.1.1 PostgreSQL
server. Size of the dump is approx 20GB. I restore it using the 8.1.2
pg_restore on a 8.1.2 PostgreSQL server. And I finaly receive a "out
of memory" error. I don't think there is trigger on pg_largeobject.

What can be the cause of this one ? I will try with the 8.1.3 release
but I don't see a related fix on the release notes.

Thanks.

--
Guillaume.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ycrux 2006-03-10 09:11:40 Re: PL/pgSQL question
Previous Message Chris 2006-03-10 02:59:13 Re: questions?