Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group