On 11/26/2018 11:40 AM, George via Bacula-users wrote:

> Just one more question: when automating the backup of
> all postgresql databases, should I also backup
> template1? I have found that template0 cannot be
> backed up due to how postgresql works but couldn't
> find similar info about template1.

I don't bother with its built-in databases: IME reinstalling postgres
(which restores them) is as fast or faster than restoring from backup.

If you're after high availability-level of backup, set up another server
and run streaming replication to it.
-- 
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu

Attachment: signature.asc
Description: OpenPGP digital signature

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

Reply via email to