Re: [GENERAL] warm standby question

2013-03-01 Thread Albe Laurenz
Sebastian Böhm wrote: > I have a primary server (9.1), which does wal archiving like this: > > wal_level = hot_standby > archive_mode = on > archive_command = 'test ! -f /home/autobackup/wal/%f && cp %p > /home/autobackup/wal/%f' > > > then I have a warm standby with this configuration in recov

Re: [GENERAL] Warm Standby question

2009-02-03 Thread Erik Jones
On Feb 1, 2009, at 4:47 AM, Thomas Kellerer wrote: Hi, (Note: I have never used log shipping before, I'm just interested in the concepts, so I'm might be missing a very important aspect) I was reading the blog entry about HA and warm standby: http://scale-out-blog.blogspot.com/2009/02/simp

Re: [GENERAL] Warm Standby question

2009-02-02 Thread Thomas Kellerer
Thanks for the answer. I see the point with the backup :) Regards Thomas Scot Kreienkamp, 02.02.2009 16:19: Probably can. But you're talking about disabling off-host archiving. The whole point behind this is prevention in case a host hard drive fails... if it fails and you don't use off-host

Re: [GENERAL] Warm Standby question

2009-02-02 Thread Scot Kreienkamp
Probably can. But you're talking about disabling off-host archiving. The whole point behind this is prevention in case a host hard drive fails... if it fails and you don't use off-host archiving then you've lost the files you need to rebuild the database along with the original database. Thanks,