On Aug 20, 2014, at 5:22 PM, Dimitri Maziuk <dmaziuk AT bmrb.wisc DOT edu> 
wrote:

> On 08/20/2014 03:34 PM, Dan Langille wrote:
>> 
>> On Aug 19, 2014, at 8:59 AM, Jonathan Bayer <linuxgurugamer AT gmail DOT 
>> com> wrote:
>> 
>>> We have a small cluster running Alfresco.  The web software is on 
>>> server1 and the database is on server2.
>>> 
>>> We have Bacula community version 7.0.5
>>> 
>>> Bacula client is installed on server1 for now.  Obviously, server1 can 
>>> access server2's database.
>>> 
>>> I'm wondering how others have solved this problem.  I have a couple of 
>>> options here:
>>> 
>>> 1.  Do a pg_dump on server1 (it has the space) and then backup the dump file
>>> 2.  Do the same on server2 instead
>>> 3.  Set up a PITR backup on server2
>>> 4.  Do a simple file system backup.  This requires shutting down the 
>>> database while the backup is in progress.
>>> 
>>> so, I'm curious.  Any responses?
>> 
>> 
>> I would run the pg_dump on server1.  That way, your copy is not on server2 
>> should server 2 die.
>> 
>> Backup that dump file.
>> 
>> Do not delete the file after the backup.  Keep it available in case it’s 
>> needed.
>> 
>> On a regular basis, rsync that file, and your *.conf file to a few other 
>> safe places. 
>> 
>> Document those locations.
>> 
>> The goal: have the configuration and the database dump available should 
>> server1 die.
> 
> FWIW, I usually pg_dump the schema to a text file and run a script that
> does '\copy ... to csv' for each table. Then commit them to git or rcs
> repository right there. Then rsync the repository to a couple of other
> servers. No bacula needed.
> 
> I don't bother with .conf because so far I didn't need to do any mods
> I'd want saved -- changing listen address and acl doesn't count as worth
> saving.

When I said .conf, I mean bacula-dir.conf, etc.  Keep those files handy, 
outside Bacula backups.
— 
Dan Langille

signature.asc
Description: Message signed with OpenPGP using GPGMail

------------------------------------------------------------------------------
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/

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