zar 2.0.4

Zeroincombenze Archive Replica

Overview

Zeroincombenze® Archive Replica

ZAR stand for Zeroincombenze® Archive Replica. It is a tool kit to backup, restore, replicate files and/or database.

ZAR manages easily backup for Odoo database, keeps last nth copies and purges oldest copies.

Features

• backup and restore odoo database

• backup and restore based on rules by configuration file

• restore database with automatic actions disabled

• multiple copies of database by configuration file

• automatic purging of oldest copies

• configuration based on host name: it works on duplicate host image too

• backup on same host or on remote host

Usage

zar should be execute by postgres user

Execute zar_upd to install and configure. Configuration file is zar.conf Execute zar_bck to do backup or restore, based on host role Execute zar_rest to do restore

To execute in cron, use zar_bck -k

There are avaiable two postgresql facilities:

• pg_db_active

• pg_db_reassign owner

pg_db_active show and kill postgres session. It can kill oldest session out of pool.

pg_db_reassign_owner can reassign owner to database. It reassign the ownership of all objects.

Getting started

Prerequisites

Zeroincombenze tools requires:

• Linux Centos 7/8 or Debian 9/10 or Ubuntu 18/20/22

• python 2.7+, some tools require python 3.6+, best python 3.8+

• bash 5.0+

Installation

For stable version:

pip install zar

For current version:

cd $HOME [e-mail]:zeroincombenze/tools.git cd $HOME/tools ./install_tools.sh

Upgrade

Stable version via Python Package

pip install --upgrade zar

Current version via Git

cd ./tools
./install_tools.sh -pUT
source $HOME/devel/activate_tools

ChangeLog History

2.0.4 (2023-09-08)

• [IMP] Backup filestore

• [FIX] Remote copy to /dev/null

2.0.3 (2023-09-06)

• [FIX] DB name with hyphen (-)

2.0.2 (2023-05-14)

• [IMP] reassing_owner accept db_port

2.0.1 (2023-02-25)

• [IMP] Remote bckdir different from local

2.0.0 (2022-10-20)

• [IMP] Stable version

1.3.35.3 (2021-08-13)

[FIX] pg_db_active: kill process

Credits

Copyright

SHS-AV s.r.l. <https://www.shs-av.com/>

Authors

• SHS-AV s.r.l.

Contributors

• Antonio M. Vigliotti

• Antonio Maria Vigliotti