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