Re: Backup

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
>