Incremental backup with RSYNC or something?

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Incremental backup with RSYNC or something?
Date: 2011-11-13 11:38:05
Message-ID: CAFWfU=v936p3JYFpFt0n-UxtzArwfqW3Se7hP9DSc8fiYz90iw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

I currently have a cronjob to do a full pgdump of the database every
day. And then gzip it for saving to my backup drive.

However, my db is now 60GB in size, so this daily operation is making
less and less sense. (Some of you may think this is foolish to begin
with).

Question: what can I do to rsync only the new additions in every table
starting 00:00:01 until 23:59:59 for each day?

Searching google leads to complex things like "incremental WAL" and
whatnot, or talks of stuff like pgcluster. I'm hoping there's a more
straightforward core solution without additional software or PHD
degrees.

Many thanks for any ideas!
PK

Responses

Browse pgsql-general by date

  From Date Subject
Next Message alextc 2011-11-13 11:45:35 Re: Error with Application Stack Builder 3.0.0
Previous Message John R Pierce 2011-11-13 09:31:22 Re: Error with Application Stack Builder 3.0.0