From: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Backup Method |
Date: | 2015-07-03 12:13:55 |
Message-ID: | VisenaEmail.c8.90e7840748db21f1.14e53d4be0a@tc7-visena |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
På fredag 03. juli 2015 kl. 11:59:49, skrev howardnews(at)selestial(dot)com <
howardnews(at)selestial(dot)com <mailto:howardnews(at)selestial(dot)com>>:
Hi everyone,
I am reaching the point with my database backups where the backups are
taking too long, and starting to interfere with running of the system
during the day. So I am looking for a bit of sage advice as to how to
proceed.
For a typical server, I have a single database cluster with multiple
database that I backup nightly using sequential pg_dumps to NFS.
So what I am looking for is a backup regime with less impact that will
run overnight but faster or less impact than the pg_dump.
Would a file system backup be the better option in PITR format, or is
pg_dumpall more efficient than pg_dump?
Look forward to your advice.
Use Barman http://www.pgbarman.org/
We're continuously backing up a 1.5TB cluster without any problems. Full PITR
with a window of 1 week.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
From | Date | Subject | |
---|---|---|---|
Next Message | Ibrahim Edib Kokdemir | 2015-07-03 12:40:29 | Re: Fwd: PostgreSQL & VMWare |
Previous Message | howardnews@selestial.com | 2015-07-03 12:08:37 | Re: Backup Method |