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.
(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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|