I need to test and create a procedure to restore
databases.
Why not just use pg_dump?
See http://manual.intl.indoglobal.com/ch06s07.html - it's really easy. This is how we copy from production to testing and development and how we do nightly backups.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================