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