Re: restoring a file system backed-up data dir

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: Luki Rustianto <lukirus(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: restoring a file system backed-up data dir
Date: 2006-10-12 20:32:03
Message-ID: 20061012203203.GA28647@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2006-10-12 20:34:50 Windows install problem (was: Postgre 8.0 Installation - Issues)
Previous Message Scott Marlowe 2006-10-12 20:31:50 A query planner that learns