|
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 |
