RE: PostgreSQL Backup Strategies
| От | Alvaro Aguayo Garcia-Rada |
|---|---|
| Тема | RE: PostgreSQL Backup Strategies |
| Дата | |
| Msg-id | aqm0ckut7fsf67hqeupu7k74.1519268886459@email.android.com обсуждение исходный текст |
| Ответ на | PostgreSQL Backup Strategies (Luis Marin <luismarinaray@gmail.com>) |
| Ответы |
Re: PostgreSQL Backup Strategies
|
| Список | pgsql-admin |
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 ?В списке pgsql-admin по дате отправления: