| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Moshe Jacobson <moshe(at)neadwerx(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Need solution for weekly database "snapshot" |
| Date: | 2013-04-23 02:33:52 |
| Message-ID: | CAMkU=1w6j5+5jBXZjxQGmFnLyx3heW0TFixo1t9dLF_Oxgthkw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Monday, April 22, 2013, Moshe Jacobson wrote:
> We have a report in our system that is pulled many times each week, but
> needs to be based off data from Sunday at noon. So every Sunday at noon, we
> back up our main database and restore it into a new reporting snapshot
> database.
>
> The problem is that backing up and restoring the database every week is a
> very costly operation that can take many hours. It brings the system to its
> knees.
>
How do you do normal backups, for disaster recovery purposes? Could you
merge that with your snapshotting needs to reduce the workload on your main
server from two to one?
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | S H | 2013-04-23 02:48:03 | Regarding template1 database |
| Previous Message | bricklen | 2013-04-23 01:59:36 | Re: Error installation of openmolar |