Re: Backup

["Shoaib Mir" <shoaibmir(at)gmail(dot)com>]

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?

---------------
Shoaib Mir
EnterpriseDB (
www.enterprisedb.com)

On 12/13/06, Eduardo J. Ortega <ejortegau(at)cable(dot)net(dot)co > wrote:

Hi there:

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