Need solution for weekly database "snapshot"

From: Moshe Jacobson <moshe(at)neadwerx(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Need solution for weekly database "snapshot"
Date: 2013-04-22 15:58:58
Message-ID: CAJ4CxLmJYyJCbb5iu06HdsnwLnk4zrb=DabEPoDhMsthj523NQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Unfortunately the report touches a lot of the database, so it would be
unreasonable to try to add versioning to the data the report pulls.

Is there an easier way of maintaining a snapshot of our database that can
be accessed throughout the week?

Thanks for any suggestion.

--
Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe(at)neadwerx(dot)com | www.neadwerx.com

"Quality is not an act, it is a habit." -- Aristotle

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2013-04-22 16:14:45 Re: Need solution for weekly database "snapshot"
Previous Message Alfonso Afonso 2013-04-22 15:57:16 Re: using text search