Re: Backups / replication - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Backups / replication
Date
Msg-id 201006151256.14249@hal.medialogik.com
Whole thread Raw
In response to Backups / replication  (Oliver Kohll - Mailing Lists <oliver.lists@gtwm.co.uk>)
List pgsql-general
On Tuesday, June 15, 2010, "Oliver Kohll - Mailing Lists"
<oliver.lists@gtwm.co.uk> wrote:
> Are either of those two likely? Any other suggestions? Another question
> is will the replication coming in v9.0 change things and would it be
> worth holding off until then? In particular Command Prompt's PITR tools
> look useful for restoring to a particular point in time, will these
> still work or will there be equivalents?

PITR in recent versions allows restoration to any point in time after the
base backup was created, assuming you have the WAL logs from that point
forward.

--
"No animals were harmed in the recording of this episode. We tried but that
damn monkey was just too fast."

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Inconsistency with LIKE and SIMILAR TO
Next
From: Josh Kupershmidt
Date:
Subject: Re: How to emulate password generation in PHP with PlpgSQL?