From: Decibel! <decibel@decibel.org>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin@postgresql.org
Subject: Re: PITR backup to Novell Netware file server
Date: Tue, 7 Aug 2007 16:51:39 -0500
Message-ID: <20070807215139.GT25704@nasby.net> (raw)
In-Reply-To: <46B87DCD.EE98.0025.0@wicourts.gov>
References: <46B8114E.EE98.0025.0@wicourts.gov>
<20070807182800.GJ25704@nasby.net>
<46B87DCD.EE98.0025.0@wicourts.gov>
On Tue, Aug 07, 2007 at 02:12:29PM -0500, Kevin Grittner wrote:
> > 2) Have archive_command copy to someplace on the database server, and
> > have another process copy from there to both the local backup as well as
> > the central backup.
>
> A possible option; although if the rsync daemon on the file server proves
> reliable, I don't see the benefit over having the archive command make a copy
> on the database server which flows to the file server and from the file server
> back to the central site. I'd rather add the load to the file server than the
> database server.
Yeah, if you can make that work reliably, then I agree it's probably
better.
> > Copying a 16MB file that's already in memory isn't exactly an intensive
> > operation...
>
> That's true for the WAL files. The base backups are another story. We will
> normally have a database vacuum analyze between the base backup and the users
> being in there to care about performance, but that's not always the case --
> sometimes jury trials go late into the night and could overlap with this a
> base backup. And some judges put in a lot of late hours; although they don't
> tend to bang on the database very heavily, they hate to be made to wait.
Ahh... well, that's something where rsync could actually help you since
it allows you to put a bandwidth cap on it. Another option is that some
OSes (FreeBSD for one) will respect process priority when it comes to
scheduling IO as well, so if you nice the backup process it hopefully
wouldn't impact the database as much.
--
Decibel!, aka Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: decibel@decibel.org, Kevin.Grittner@wicourts.gov
Subject: Re: PITR backup to Novell Netware file server
In-Reply-To: <20070807215139.GT25704@nasby.net>
* 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