Sorry I have no book to recommend, but my recommendation will always pass through pg_basebackup, which will perform a full backup of you running database without needing to stop anything, and will also(with adequate args) add all transactiins committed zuring the backup to the backup itself.
I do myself use pg_basebackup and a simple shellscript to do automated backups of a production system.
I've also heard about pgbarman, but have no knowledge on it.
Regards,
Alvaro Aguayo
Jefe de Operaciones
Open Comb Systems E.I.R.L.
Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103 | RPC: (+51) 954183248
Website: www.ocs.pe
Sent from my Sony Xperia™ smartphone
---- Luis Marin wrote ----
I do myself use pg_basebackup and a simple shellscript to do automated backups of a production system.
I've also heard about pgbarman, but have no knowledge on it.
Regards,
Alvaro Aguayo
Jefe de Operaciones
Open Comb Systems E.I.R.L.
Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103 | RPC: (+51) 954183248
Website: www.ocs.pe
Sent from my Sony Xperia™ smartphone
---- Luis Marin wrote ----
Dear Friends,
Please, somebody knows a good
source of information about PostgreSQL 9 backup strategies for
production systems, if you have read a good book with this subject,
could you share the author and name of the book ?