Re: PITR as Online Backup Solution

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