Re: Out of memory error on pg_restore - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Out of memory error on pg_restore
Date
Msg-id d854adec0603100017j68ac1134r@mail.gmail.com
Whole thread Raw
In response to Out of memory error on pg_restore  ("Nik" <XLPizza@gmail.com>)
List pgsql-general
8 Mar 2006 07:31:19 -0800, Nik <XLPizza@gmail.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.

pgsql-general by date:

Previous
From: Michael Louie Loria
Date:
Subject: Re: Run PostgreSQL with Administrator account in Windows
Next
From: ycrux@club-internet.fr
Date:
Subject: Re: PL/pgSQL question