Re: Need solution for weekly database "snapshot"
| От | Moshe Jacobson |
|---|---|
| Тема | Re: Need solution for weekly database "snapshot" |
| Дата | |
| Msg-id | CAJ4CxLmBQREidAV3WqvNtpt3wyn6oeOtttqFn_8GPx2=4t10=A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Need solution for weekly database "snapshot" (Karsten Hilbert <Karsten.Hilbert@gmx.net>) |
| Ответы |
Re: Need solution for weekly database "snapshot"
Re: Need solution for weekly database "snapshot" |
| Список | pgsql-general |
On Mon, Apr 22, 2013 at 12:14 PM, Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
Not bad, but the transaction logs would fill up the file system. Besides, it would not be worth it to set up a whole database cluster just for this purpose.
> We have a report in our system that is pulled many times each week, butSetup a slave.
> 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.
Any alternatives?
--
Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering
Nead Werx, Inc. | Manager of Systems Engineering
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@neadwerx.com | www.neadwerx.com
moshe@neadwerx.com | www.neadwerx.com
"Quality is not an act, it is a habit." -- Aristotle
В списке pgsql-general по дате отправления: