can restore be restart???

[daproud]

All,
I am restoring a table but running out of space in the file system. Can I stop the restore move the files to a larger file system and restart the restore at the point I stopped? The restore has been running almost three days. I am a newbie to Postgres and just following a vendors instructions. A co-worker has heard this is possible but has no information, the vendor is no help and I have not been able to find any information on the web. If this is possible can someone point to a link or provide any information? The OS is FreeBSD version 4.9 release 5 and Postgres version is 7.3.2
Thanks,
Dave

 

[ceco]

how large is your database??

check these options, so you can have much faster restores

http://people.planetpostgresql.org/...ster-database-restores-on-postgresql-8.1.html

keep in mind that after the restore you will have to set them to other values for better working environment (especially fsync is very dangerous to be off on working environment)