Dan Langille wrote: > John Drescher wrote: > >> On Sat, Jan 3, 2009 at 2:26 PM, Dan Langille <d...@langille.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users