Re: Out of memory error on pg_restore

["Guillaume Lelarge" <guillaume.lelarge@xxxxxxxxx>]

8 Mar 2006 07:31:19 -0800, Nik <XLPizza@xxxxxxxxx>:
> [...]
> 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.