Skip site navigation (1) Skip section navigation (2)

Re: Backup

From: "John Jensen" <jrj(at)ft(dot)fo>
To: <jday(at)gisolutions(dot)us>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Backup
Date: 2005-03-25 13:30:00
Message-ID: s244127b.021@fs3.ft.fo (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)gisolutions(dot)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.


pgsql-admin by date

Next:From: Donald FraserDate: 2005-03-25 14:30:15
Subject: problem with connection logging
Previous:From: Lee WuDate: 2005-03-25 04:41:44
Subject: Re: pg_dump, pg_restore, insert vs copy

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group