Re: pg_restore error with out of memory

From: "Kevin Grittner" <kgrittn(at)mail(dot)com>
To: "AI Rumman" <rummandba(at)gmail(dot)com>
Cc: "pgsql-general General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_restore error with out of memory
Date: 2012-12-14 20:24:11
Message-ID: 20121214202411.80060@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

AI Rumman wrote:

> I modified the
> shared_buffer=50 MB
> and
> maintenance_work_mem = 50 MB
>
> But still getting the same error.

I hope you restarted the PostgreSQL server? If so, pg_restore might
just need more RAM than that machine has to deal with that
particular database. You might try a text dump, loaded by psql
instead.

-Kevin

Browse pgsql-general by date

  From Date Subject
Next Message Edson Richter 2012-12-14 20:28:23 Re: PgSQL 9.1: Warning - error 10061 on Windows, no error on Linux - but connection is broken
Previous Message David Johnston 2012-12-14 20:14:28 Re: PgSQL 9.1: Warning - error 10061 on Windows, no error on Linux - but connection is broken