pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (2+ messages)

Message-ID: <37D9EC69.8FC94FB0@krs.ru>
Permalink:  ../37D9EC69.8FC94FB0@krs.ru/
Also on:    postgresql.org/message-id/37D9EC69.8FC94FB0@krs.ru

 · 

reply

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