| From: | "Kevin Duffy" <KD(at)wrinvestments(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | pg_restore parameters |
| Date: | 2008-09-12 18:23:52 |
| Message-ID: | DFC309C8A42633419600522FA8C4AE1A560F4D@mail-01.wrcapital.corp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2008-09-12 18:32:07 | Re: Fastest way to restore a database |
| Previous Message | Oleg Bartunov | 2008-09-12 16:02:22 | Re: TSearch2: find a QUERY that does match a single document |