------=_Part_49930_6192689.1154482560559
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_49930_6192689.1154482560559
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Below is the result of restoring specific tables from backup made by pgadmin using postgresql 8.1.4 for windows</div>
<div>Note: Same result also applies to linux distribution of postgresql 8.1.4</div>
<div>-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</div>
<div>&nbsp;</div>
<div>C:\Program Files\PostgreSQL\8.1\bin\pg_restore.exe -i -h localhost -p 5432 -U postgres -d bdoors -a -t product -v &quot;E:\db.backup&quot;<br>pg_restore: connecting to database for restore<br>pg_restore: restoring data for table &quot;product&quot;
<br>pg_restore: [custom archiver] out of memory<br>pg_restore: *** aborted because of error</div>
<p>Process returned exit code 1.</p>
<p><br>C:\Program Files\PostgreSQL\8.1\bin\pg_restore.exe -i -h localhost -p 5432 -U postgres -d bdoors -a -t demographics -v &quot;E:\db.backup&quot;<br>pg_restore: connecting to database for restore<br>pg_restore: restoring data for table &quot;demographics&quot;
<br>pg_restore: [custom archiver] out of memory<br>pg_restore: *** aborted because of error</p>
<div>Process returned exit code 1.<br>&nbsp;</div>
<div>-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</div>
<div>&nbsp;</div>
<div>Tested machine: xeon 2.8</div>
<div>Memory: 512</div>
<div>OS: Windows XP SP2 and Fedora Core 5</div>
<div>&nbsp;</div>
<div>Backup DB size: 366,233,780</div>
<div>DB Size: more than 2 gigabytes</div>
<div>Created By: PGADMIN</div>

------=_Part_49930_6192689.1154482560559--