Skip site navigation (1) Skip section navigation (2)

Re: Planning hot/live backups?

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Steve Poe <steve(dot)poe(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Planning hot/live backups?
Date: 2008-03-24 20:43:58
Message-ID: 47E8128E.1060600@zeut.net (view raw or flat)
Thread:
Lists: pgsql-performance
Steve Poe wrote:
> The owners of the animal hospital where I work at want to consider live/hot
> backups through out the day so we're less likely to lose a whole
> day of transaction.  We use Postgresql 8.0.15. We do 3AM
> backups, using pg_dumpall, to a file when there is very little activity.



You probably want to look into PITR, you can have a constant ongoing 
backup of your data and never lose more than a few minutes of data.  The 
overhead isn't all the big especially if you are shipping the log files 
to a separate server.


In response to

Responses

pgsql-performance by date

Next:From: paul riversDate: 2008-03-24 21:22:49
Subject: Re: Planning hot/live backups?
Previous:From: Campbell, LanceDate: 2008-03-24 20:39:32
Subject: Re: Planning hot/live backups?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group