Hello:
I am move to a new production server and am testing my backup and restore procedures. Given a backup created with the follow command C:\>C:\progFiles\PostgreSQL\8.2\bin\pg_dump -Fc -b -C -o -f E:\backupPostgres\benchxx_c20080912.backup -U postgres benchxx_c What is the best way to do a restore of the above backup? I tinkered with a couple of scenarios. The one the gave a clean restore was a) drop the database b) restore using the following: pg_restore -C -d template1 -U postgres "E:\data\postgres\ benchxx_c20080912.backup" Is this the correct way to do a restore? Note: the above E Drives are on different machines. Thanks for your kind assistance. KD
