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
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 |