pg_restore parameters

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

Responses

Browse pgsql-general by date

  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