Re: PITR as Online Backup Solution - Mailing list pgsql-admin

From Simon Riggs
Subject Re: PITR as Online Backup Solution
Date
Msg-id 1141408830.27729.512.camel@localhost.localdomain
Whole thread Raw
In response to Re: PITR as Online Backup Solution  ("Andy Shellam" <andy.shellam@mailnetwork.co.uk>)
Responses Re: PITR as Online Backup Solution
List pgsql-admin
On Fri, 2006-03-03 at 10:23 +0000, Andy Shellam wrote:

> Then you would have to find a method of telling the script
> that you wish to bring the database up and it will exit and allow PGSQL to
> come up at the current state with the latest data.

> Replication sounds like a better option

If you want auto failover, then you will need a package that detects
that accurately and can initiate any required actions, whatever method
you choose of keeping multiple systems in sync.

IMHO auto failover needs *extensive* testing and failure analysis to
make it more robust and practically useful than manual failover, so is
not quite the magic bullet it may appear.

Best Regards, Simon Riggs


pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: PITR as Online Backup Solution
Next
From: "Thomas F. O'Connell"
Date:
Subject: Re: PITR as Online Backup Solution