On Fri, Dec 28, 2007 at 12:06:42PM -0500, Josh Harrison wrote: > I also thought abt having 2 setups for backup and replication so that even > when slony fails I will always have the standby server (WAL shipping) to > help me out. Ok, but do realise that what this form of redundancy provides you with is two independent paths for different kinds of failure. It may also mean you have more complicated troubleshooting procedures. I'm not advising not to do it; I'm rather advising you to think carefully about what problems you think you're solving, and what potential problems you are adding by taking this approach. > I have another question regarding this. I also want to write these to the > tape. Right now we have a cron job doing level 0,1,2,... backups of the > other servers to the tape regularly. What is the good way to include > postgres server backup to tape? If you're going to use WAL shipping anyway, then I'd do fairly regular full backups plus WAL archiving. This is outlined completely in the manual in section 23.3. A ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
