X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id E2CD4537F2
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Fri, 25 Mar 2005 13:30:38 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 69684-09
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Fri, 25 Mar 2005 13:30:35 +0000 (GMT)
Received: from fs3.ft.fo (mail-gw.ft.fo [212.55.40.2])
	by svr1.postgresql.org (Postfix) with ESMTP id B5639537F4
	for <pgsql-admin@postgresql.org>; Fri, 25 Mar 2005 13:30:33 +0000 (GMT)
Received: from FT_DOM-MTA by fs3.ft.fo
	with Novell_GroupWise; Fri, 25 Mar 2005 13:30:35 +0000
Message-Id: <s244127b.021@fs3.ft.fo>
X-Mailer: Novell GroupWise Internet Agent 6.5.3 
Date: Fri, 25 Mar 2005 13:30:00 +0000
From: "John Jensen" <jrj@ft.fo>
To: <jday@gisolutions.us>, <pgsql-admin@postgresql.org>
Subject: Re: Backup
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.083 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200503/415
X-Sequence-Number: 16913

Hi,
I have a 61Gig base at the moment and do a full online backup each
night.
It's not really that much of a strain so I haven't bothered with cooking
up a scheme for differential backups. Using my simple scripts it takes
one hour and in my case I end up with 2.5Gigs (compressed) worth of
backup files. The backup claims two cpu's for the hour that the job runs
but on a multi-cpu box it's not that much trouble.

My scripts are:
#! /bin/sh
if test $# -lt 2; then
  echo "Usage: dbbackup <basename> <filename>"
else
  /home/postgres/postgresql/bin/pg_dump -h $HOSTNAME $1 | gzip -f - |
split --bytes 600m - $2.
fi

and
if test $# -lt 2; then
  echo "Usage: dbrestore <basename> <filename>"
else
  cat $2.* | gzip -d -f - | /home/postgres/postgresql/bin/psql -h
$HOSTNAME -f - $1
fi

Cheers,

John

>>> "Joseph M. Day" <jday@gisolutions.us> 03/23/05 8:41 PM >>>
It looks like pg_dump is the equivalent of a full backup, but
how do I keep the equivalent of a Incremental, or Differential backup.
 
To keep the same functionality, I will need a full backup once a week,
and a differential once a day.