aqui envio todas mis configuraciones y mis condiciones 1- servidor donde esta corriendo barman y además las base de datos a las que quiero hacerle los backup IP: 10.56.13.190 2- servidor donde quiero almacenar los backup IP: 10.56.13.191
3- archivo /etc/barman.conf que esta en el servidor .190 ; Barman, Backup and Recovery Manager for PostgreSQL ; http://www.pgbarman.org/ - http://www.2ndQuadrant.com/ ; ; Main configuration file [barman] ; Main directory barman_home = /var/lib/barman/main ; System user barman_user = barman ; Log location log_file = /var/log/barman/barman.log ; Default compression level: possible values are None (default), bzip2, gzip or custom ;compression = gzip ; Pre/post backup hook scripts ;pre_backup_script = env | grep ^BARMAN ;post_backup_script = env | grep ^BARMAN ; Pre/post archive hook scripts ;pre_archive_script = env | grep ^BARMAN ;post_archive_script = env | grep ^BARMAN ; Directory of configuration files. Place your sections in separate files with .conf extension ; For example place the 'main' server section in /etc/barman.d/main.conf ;configuration_files_directory = /etc/barman.d ; Minimum number of required backups (redundancy) ;minimum_redundancy = 0 ; Global retention policy (REDUNDANCY or RECOVERY WINDOW) - default empty ;retention_policy = ; Global bandwidth limit in KBPS - default 0 (meaning no limit) ;bandwidth_limit = 4000 ; Immediate checkpoint for backup command ;immediate_checkpoint = false ; Enable network compression for data transfers ;network_compression = false ; Identify the standard behavior for backup operations: possible values are ; exclusive_backup (default), concurrent_backup ;backup_options = exclusive_backup ;; ; 'main' PostgreSQL Server configuration [main] ;; ; Human readable description ;; description = "Main PostgreSQL Database" ;; ;; ; SSH options ssh_command = ssh [email protected] ;; ;; ; PostgreSQL connection string conninfo = host=10.56.13.191 user=postgres ;; ;; ; Minimum number of required backups (redundancy) ;; ; minimum_redundancy = 1 ;; ;; ; Examples of retention policies ;; ;; ; Retention policy (disabled) ;; ; retention_policy = ;; ; Retention policy (based on redundancy) ;; ; retention_policy = REDUNDANCY 2 ;; ; Retention policy (based on recovery window) ;; ; retention_policy = RECOVERY WINDOW OF 4 WEEKS 4- configuración del postgresql.conf en .190 wal_level = archive archive_mode = on archive_command = 'rsync -a %p [email protected]:/var/lib/postgresql/9.3/main/pg_xlog/%f' Marcos M. Martínez Pérez Universidad de las Ciencias Informáticas ------------------------ Una amistad verdadera no es ser inseparables, es ser capaz de separarse y no cambiar. VII Escuela Internacional de Verano en la UCI del 30 de junio al 11 de julio de 2014. Ver www.uci.cu - Enviado a la lista de correo pgsql-es-ayuda ([email protected]) Para cambiar tu suscripci�n: http://www.postgresql.org/mailpref/pgsql-es-ayuda
