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
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
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
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,