X-Original-To: pgsql-www-postgresql.org@postgresql.org
Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id C78DE9FB210;
	Thu, 14 Sep 2006 12:07:23 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 90178-06; Thu, 14 Sep 2006 15:07:19 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from havoc.unixathome.org (havoc.unixathome.org [66.154.98.130])
	by postgresql.org (Postfix) with ESMTP id F2BFF9FB202;
	Thu, 14 Sep 2006 12:07:18 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by havoc.unixathome.org (Postfix) with ESMTP id 712105647B;
	Thu, 14 Sep 2006 08:07:17 -0700 (PDT)
X-Virus-Scanned: by amavisd-new at unixathome.org
Received: from havoc.unixathome.org ([127.0.0.1])
	by localhost (havoc.unixathome.org [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id H+NBGW9Y9DYU; Thu, 14 Sep 2006 08:06:54 -0700 (PDT)
Received: from bast.unixathome.org (bast.unixathome.org [70.26.229.230])
	by havoc.unixathome.org (Postfix) with ESMTP id CAC4856431;
	Thu, 14 Sep 2006 08:06:54 -0700 (PDT)
Received: from [10.55.0.99] (wocker.unixathome.org [10.55.0.99])
	by bast.unixathome.org (Postfix) with ESMTP id 53C01B820;
	Thu, 14 Sep 2006 11:06:52 -0400 (EDT)
From: "Dan Langille" <dan@langille.org>
To: "Marc G. Fournier" <scrappy@postgresql.org>
Date: Thu, 14 Sep 2006 11:06:52 -0400
MIME-Version: 1.0
Subject: Re: backup infrastructure
CC: pgsql-www@postgresql.org
Message-ID: <450937CC.15405.6058100@dan.langille.org>
In-reply-to: <20060913180808.X36880@ganymede.hub.org>
References: <45081FAC.22347.1BF48B3@dan.langille.org>
X-mailer: Pegasus Mail for Windows (4.31)
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Content-description: Mail message body
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=
X-Spam-Level: 
X-Archive-Number: 200609/78
X-Sequence-Number: 10656

On 13 Sep 2006 at 18:27, Marc G. Fournier wrote:

> On Wed, 13 Sep 2006, Dan Langille wrote:
> 
> > On 6 Sep 2006 at 15:30, Dan Langille wrote:
> >
> >> Gidday folks,
> >>
> >> One way I can contribute my services to the project is in the form of
> >> backup services. You tell me what files need to be backed up from what
> >> servers, and it'll be done on the frequency required.
> >>
> >> Restores can be arranged for those that have admin access.  We can
> >> keep a designated number of backups online, for immediate access.
> >> Older backups will be stored offline.
> >>
> >> Bacula is my tool of choice.  Let me know how I can help.
> >
> > Is the lack of response a verification that no help is required or
> > did I pick a bad time?
> 
> What is needed on the vServer side of things?  A client, I assume?  And 
> how much data is it safe to backup?  postgresql.org is up to 24G in size, 
> and growing ... :)

Yes, it is a client.  In the FreeBSD ports tree, it is 
sysutuils/bacula-server.

I can just as easily mirror static data as opposed to backing up 
dynamic data.

> We're in the process of setting up a full backup to a remote server *just 
> in case*, but that will include *all* files, so that we could fail over as 
> required ... so I'm not sure whether or not there would be a benefit to 
> 'per file backups', but I'm not against it either if others here feel that 
> this would help ...

Once your current rush subsides, and there is slight pause, let me 
know.

-- 
Dan Langille : Software Developer looking for work
my resume: http://www.freebsddiary.org/dan_langille.php