To me PITR looks like a very nice solution for incremental backup and even they can serve as a warm standby. What exactly are the complications you see with WAL archiving?
Are there any nice (official or third party) backup utilities for postgres? I have a database which is several GB, so pg_dumping it to file and then bzipping2 every hour is not really the way to go. I've read a little about using WAL for incremental backup, but it sounds a little complicated and *very* user-error prone.
(Not sure if this is the right place for it, but i really think that PG's developers should consider including a viable backup utility in the next version)
thanks.
-- Eduardo J. Ortega - Linux user #222873 "No fake - I'm a big fan of konqueror, and I use it for everything." -- Linus Torvalds
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster