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

Re: tape backups

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: Ben <bench(at)silentmedia(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: tape backups
Date: 2006-12-23 18:20:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
I think you might want to do incremental backups so a better approach to
that as you mentioned too will be WAL files. For details you can refer to

Shoaib Mir
EnterpriseDB (

On 12/23/06, Ben <bench(at)silentmedia(dot)com> wrote:
> Hi everybody,
> I'm trying to find a good solution to making backups to tape, where I
> want to define "good" as:
> - easy to use, like pg_dumpall, BUT
> - not in a single file, so I don't backup my entire database cluster
> with every differential backup
> As I understand my backup program (Bacula) if a file changes at all
> between differential backups then it gets backed up again in its
> entirety. That seems pretty reasonable. So now I'm trying to figure
> out how to get my postgres dump to end up in files in such a way that
> little change in data means few file changes. But if there's no
> native tool to do that (and it seems like there isn't) then setting
> up something like that sounds like it might be a pain, as would
> restoring from it.
> Am I going about this the wrong way? Would it just be easier to do a
> full pg_dumpall for my full backups and then build up a list of WAL
> files with each differential? How do other people do it?
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?

In response to


pgsql-general by date

Next:From: orgDate: 2006-12-23 18:28:35
Subject: Re: Clustering & Load Balancing & Replication
Previous:From: BenDate: 2006-12-23 18:13:29
Subject: tape backups

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