Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group