Re: [GENERAL] pg_restore error with out of memory

2012-12-14 Thread Kevin Grittner
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

Re: [GENERAL] pg_restore error with out of memory

2012-12-14 Thread AI Rumman
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.

Re: [GENERAL] pg_restore error with out of memory

2012-12-13 Thread Kevin Grittner
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