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. (For other conf files there's etckeeper) -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------------ 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
