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: | Raw Message | Whole Thread | 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 |