Dan Langille wrote:
> 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.
>   
Hello!
PostrgreSQL-8.3 can even warm-backup - take a look.

ps. IMHO - PITR is the best way for database backup. You can spread it
to more then one place.
ps2. Consider: https://developer.skype.com/SkypeGarage/DbProjects/SkyTools

-- 
Andrzej Zawadzki

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