Re: creando backup con barman

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 postgres(at)10(dot)56(dot)13(dot)191
;;
;; ; 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 postgres(at)10(dot)56(dot)13(dot)191:/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 (pgsql-es-ayuda(at)postgresql(dot)org)
Para cambiar tu suscripcin:
http://www.postgresql.org/mailpref/pgsql-es-ayuda