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
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 |