From: Vadim Mikheev <vadim@krs.ru>
To: Wayne Piekarski <wayne@senet.com.au>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Fast Backups With pg_dump
Date: Sat, 11 Sep 1999 13:45:13 +0800
Message-ID: <37D9EC69.8FC94FB0@krs.ru> (raw)
References: <199909110513.OAA15799@helpdesk.senet.com.au>
Wayne Piekarski wrote:
>
> Currently, I am running the pg_dump program every hour to produce backups
> of the database, and then storing them in case something fails or I need
> recover something.
>
> However, the backups are quite large, and the CPU gets really thrashed a
> lot doing the COPY as it has to make lots of function calls (as mentioned
> in a previous email of mine to hackers) and I wanted to avoid this if
> possible.
>
> What would be really neat is if you could do something like, give me a
> dump of all rows changed since the last backup, sortof like a diff file,
> so I make a full backup at the start of the day, and then just store
> deltas for the rest of the day. I know that postgres can keep track of
> this kind of stuff because the MVCC allows it to make a consistent
> snapshot of the dbms even while updates are occuring, so is this kind of
> idea possible (or does it already exist?)
I implement transaction logging for 6.6 - you will be able
to do incremental backup by copying log file.
Vadim
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: vadim@krs.ru, wayne@senet.com.au
Subject: Re: [SQL] Fast Backups With pg_dump
In-Reply-To: <37D9EC69.8FC94FB0@krs.ru>
References: <199909110513.OAA15799@helpdesk.senet.com.au> <37D9EC69.8FC94FB0@krs.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox