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: bf54be870612231020n2d5eb823neb8335709cf44bce@mail.gmail.com (view raw or flat)
Thread:
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
--> http://www.postgresql.org/docs/current/static/continuous-archiving.html

--------------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

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?
>
>                http://archives.postgresql.org/
>

In response to

Responses

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-2014 The PostgreSQL Global Development Group