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 t
I modified the
shared_buffer=50 MB
and
maintenance_work_mem = 50 MB
But still getting the same error.
On Thu, Dec 13, 2012 at 7:36 PM, Kevin Grittner wrote:
> AI Rumman wrote:
>
> I am going to restore a 6 Gb database in my development machine
> which is running on Centos 5.6 with memory 1 GB.
AI Rumman wrote:
I am going to restore a 6 Gb database in my development machine
which is running on Centos 5.6 with memory 1 GB.
> pg_restore: out of memory
> pg_restore: finished item 8570 TABLE DATA entity
> pg_restore: [archiver] worker process failed: exit code 1
> I set postgresql.conf as