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)
954183248Website:
www.ocs.peSent 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 ?
Thanks