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: (view raw, whole thread or download thread mbox)
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
> 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.
> ---------------------------(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 

In response to


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-2017 The PostgreSQL Global Development Group