From owner-freebsd-questions@FreeBSD.ORG  Mon Oct 24 17:02:12 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 7DF0916A41F
	for <freebsd-questions@freebsd.org>;
	Mon, 24 Oct 2005 17:02:12 +0000 (GMT)
	(envelope-from pergesu@gmail.com)
Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.203])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 2304843D48
	for <freebsd-questions@freebsd.org>;
	Mon, 24 Oct 2005 17:02:12 +0000 (GMT)
	(envelope-from pergesu@gmail.com)
Received: by zproxy.gmail.com with SMTP id 40so650266nzk
	for <freebsd-questions@freebsd.org>;
	Mon, 24 Oct 2005 10:02:11 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=V7H9wVWE98hQLFCC6HMprrntc6k9oQTdw0ZYk88BfGfzBcXzkGM2w3vwq6lbQdVXM2H/tJ7pbsO26mdIjDEY6zHU5cygojF2DaT6XFDlt/rx7VduPz6Jq9rJKa0LTsaZgO1O04ACeeTprPvcGKTUs5rRW6W4Jnki/VSdTIbjRig=
Received: by 10.36.252.77 with SMTP id z77mr7044116nzh;
	Mon, 24 Oct 2005 10:02:11 -0700 (PDT)
Received: by 10.36.47.5 with HTTP; Mon, 24 Oct 2005 10:02:11 -0700 (PDT)
Message-ID: <810a540e0510241002l56e9e0d1ra4c4f949da4a8fb9@mail.gmail.com>
Date: Mon, 24 Oct 2005 11:02:11 -0600
From: Pat Maddox <pergesu@gmail.com>
To: FreeBSD Questions <freebsd-questions@freebsd.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Subject: Backing up postgresql data
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 24 Oct 2005 17:02:12 -0000

I've got postgresql 8 running on my system, and want to do nightly
backups of the database.  I took a look at the docs, and there are a
few methods of doing backups - pg_dump, file system level, and using
WAL.  I just want to be able to rsync my data every night, maybe every
few hours, so that I can recover it if there are any problems...so
what's the best way to do this.  Are there any scripts or utilities
available to make my life easy?

Thanks,
Pat