Postgres Pro
Downloads
Home   >   mailing lists

Re: restoring a file system backed-up data dir - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: restoring a file system backed-up data dir
Date
Msg-id 20061012203203.GA28647@nasby.net
Whole thread Raw
In response to Re: restoring a file system backed-up data dir  ("Luki Rustianto" <lukirus@gmail.com>)
List pgsql-general
Tree view 
On Wed, Oct 11, 2006 at 11:13:21AM +0700, Luki Rustianto wrote:
> ... so what if the database size is above 20 GB, do we have to do
> pg_dump each at periodics time to get reliable backup?

No, you can also use Point In Time Recovery (PITR).
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: A query planner that learns
Next
From: "Jim C. Nasby"
Date:
Subject: Windows install problem (was: Postgre 8.0 Installation - Issues)