Re: [GENERAL] Two Questions Re: Warm Backup

2009-05-02 Thread Terry Lee Tucker
On Saturday 02 May 2009 13:08, Daniel Verite wrote: >Terry Lee Tucker writes > > > Q1: Can we set up a scenario where there is more that one > > warm standby? > > Yes. But you'll have to consider what you want to happen when one > standby is correctly receiving the WAL files and another is

Re: [GENERAL] Two Questions Re: Warm Backup

2009-05-02 Thread Daniel Verite
Terry Lee Tucker writes Q1: Can we set up a scenario where there is more that one warm standby? Yes. But you'll have to consider what you want to happen when one standby is correctly receiving the WAL files and another is not, because the archive_command has to either fail or succee

[GENERAL] Two Questions Re: Warm Backup

2009-05-01 Thread Terry Lee Tucker
Greetings: We are researching implementing a warm backup solution for our existing databases. We have a two node cluster running RH which are connected to a SAN. There is a total of 11 database clusters with the two node linux cluster balancing the load. At the moment, we are not doing any WAL