John Drescher wrote:
> On Sat, Jan 3, 2009 at 2:26 PM, Dan Langille <dan AT langille DOT org> wrote:
>> Eduardo J. Ortega U. wrote:
>>> Hi, all:
>>>
>>> I am considering bacula for backing up a server whose primary role is
>>> PostgreSQL. My question is, is bacula appropriate for taking online
>>> postgres backups (considering that a filesystem backup when the
>>> database is running is a badf solution) ?
>> Look at PITR (Point In Time Recovery).  This may be acceptable to you.
>>
> Sounds interesting. I did not know about that.
> 
> BTW, the postgresql manual has a few different methods and a very
> detailed explanation of each.
> 
> http://www.postgresql.org/docs/8.2/static/backup.html

 From that URL, this is the one:

http://www.postgresql.org/docs/8.2/static/continuous-archiving.html

It requires careful testing.  If you do it wrong, you have nothing that 
you can restore from.

------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users