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. — 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
