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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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/
>
From | Date | Subject | |
---|---|---|---|
Next Message | org | 2006-12-23 18:28:35 | Re: Clustering & Load Balancing & Replication |
Previous Message | Ben | 2006-12-23 18:13:29 | tape backups |