On Aug 20, 2014, at 5:22 PM, Dimitri Maziuk <dmaz...@bmrb.wisc.edu> wrote:
> On 08/20/2014 03:34 PM, Dan Langille wrote: >> >> On Aug 19, 2014, at 8:59 AM, Jonathan Bayer <linuxguruga...@gmail.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
