Re: [PERFORM] pg_restore : out of memory

2008-12-19 Thread sathiya psql
On Thu, Dec 4, 2008 at 7:38 PM, Franck Routier wrote: > Hi, > > I am trying to restore a table out of a dump, and I get an 'out of > memory' error. > > The table I want to restore is 5GB big. > > Here is the exact message : > > adm...@goules:/home/backup-sas$ pg_restore -F c -a -d axabas -t cabmnt

Re: [PERFORM] pg_restore : out of memory

2008-12-18 Thread Craig Ringer
Franck Routier wrote: > Hi, > > I am trying to restore a table out of a dump, and I get an 'out of > memory' error. - Operating system? - PostgreSQL version? - PostgreSQL configuration - work_mem, shared_buffers, etc? > So, here is my question : is pg_restore supposed to eat all memory ? No, bu

[PERFORM] pg_restore : out of memory

2008-12-04 Thread Franck Routier
Hi, I am trying to restore a table out of a dump, and I get an 'out of memory' error. The table I want to restore is 5GB big. Here is the exact message : [EMAIL PROTECTED]:/home/backup-sas$ pg_restore -F c -a -d axabas -t cabmnt axabas.dmp pg_restore: [archiver (db)] Error while PROCESSING TOC