BUGS: pg_restore custom archiver out of memory

From: "Jan Cruz" <malebug(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUGS: pg_restore custom archiver out of memory
Date: 2006-08-02 01:36:00
Message-ID: 493da2780608011836n64499e0dj86010bf7bbbb8714@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Below is the result of restoring specific tables from backup made by pgadmin
using postgresql 8.1.4 for windows
Note: Same result also applies to linux distribution of postgresql 8.1.4
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

C:\Program Files\PostgreSQL\8.1\bin\pg_restore.exe -i -h localhost -p 5432
-U postgres -d bdoors -a -t product -v "E:\db.backup"
pg_restore: connecting to database for restore
pg_restore: restoring data for table "product"
pg_restore: [custom archiver] out of memory
pg_restore: *** aborted because of error

Process returned exit code 1.

C:\Program Files\PostgreSQL\8.1\bin\pg_restore.exe -i -h localhost -p 5432
-U postgres -d bdoors -a -t demographics -v "E:\db.backup"
pg_restore: connecting to database for restore
pg_restore: restoring data for table "demographics"
pg_restore: [custom archiver] out of memory
pg_restore: *** aborted because of error
Process returned exit code 1.

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Tested machine: xeon 2.8
Memory: 512
OS: Windows XP SP2 and Fedora Core 5

Backup DB size: 366,233,780
DB Size: more than 2 gigabytes
Created By: PGADMIN

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-08-02 04:10:41 Re: Fwd: [NOVICE] Trigger and Recursive Relation ?
Previous Message Brian Hurt 2006-08-01 21:15:38 BUG #2561: Manual is wrong: You can't grant a group to public