Re: WAL files backup

From: "Eduardo J(dot) Ortega" <ejortegau(at)cable(dot)net(dot)co>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: WAL files backup
Date: 2007-02-13 02:56:40
Message-ID: 200702122156.43178.ejortegau@cable.net.co
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

For what i understand, the WAL files only record changes to the database, so
each WAL segment is absolutely different from the previous one. As a matter
of fact, each WAL file is the incremental backup you want to make (provided
you have already taken a base or level 0 backup).

On Monday 12 February 2007 13:42, pedro noticioso wrote:
> hi there
>
> I lightly read this
> http://www.postgresql.org/docs/8.1/static/backup-online.html
>
> and am interested in creating an incremental backup of
> WAL files, but my database is small so each of this
> WAL files must be almost identical to the previous
> one.
>
> Is there a way to incrementally backup so that it
> takes less space?
>
> thanks!
>
>
>
> ___________________________________________________________________________
>_________ Finding fabulous fares is fun.
> Let Yahoo! FareChase search your favorite travel sites to find flight and
> hotel bargains. http://farechase.yahoo.com/promo-generic-14795097
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Eduardo J. Ortega - Linux user #222873
"No fake - I'm a big fan of konqueror, and I use it for everything." -- Linus
Torvalds

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shoaib Mir 2007-02-13 05:16:41 Re: WAL files backup
Previous Message Tom Lane 2007-02-12 21:31:24 Re: pid file problem