Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore error with out of memory - Mailing list pgsql-general

From Kevin Grittner
Subject Re: pg_restore error with out of memory
Date
Msg-id 20121214202411.80060@gmx.com
Whole thread Raw
In response to pg_restore error with out of memory  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: PgSQL 9.1: Warning - error 10061 on Windows, no error on Linux - but connection is broken
Next
From: Edson Richter
Date:
Subject: Re: PgSQL 9.1: Warning - error 10061 on Windows, no error on Linux - but connection is broken