Welcome!

This community is for professionals and enthusiasts of our products and services. Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.

0

How to setup a regular PostgreSQL database backup [关闭]

提供于
Administrator
18-4-16 上午7:09 81 浏览次数

讨论 被关闭了 原因: 不是一个真正的帖子

by
Administrator
2018年04月16日 07时14分08秒

I'm not familiar with PostgreSQL database administration , so I figured I might ask for help from someone more knowledgeable on the subject. What would you recommend in order to setup a regular (daily) OpenERP database backup? Ideally, this would be done without stopping the database (hot backup). Is it possible to setup incremental backups, e.g., one weekly reference backup and daily incremental backups? Are there any automation scripts available I might use? (I'm using Ubuntu Server.)


0

Administrator

--Administrator--
2532
| 1 0 1
Scranton, 美国
--Administrator--
Administrator
18-4-16 上午7:09

I use the following setup:

  1. Backup-Script
  2. Housekeeping script (deletes backups which are older than 30 days)
  3. Create daily cronjobs in to run Backup and Housekeeping Script. The backup runs daily at 1am and the housekeeping job runs daily at 5am.

随时了解

关于这个社区

这个社区是为专业人士和我们的产品和服务的爱好者。分享并讨论最好的内容和新的营销思路,建立自己的专业简介,并成为一个更好的营销合作。 阅读指南

问题工具

1 关注者

统计数据

问: 18-4-16 上午7:09
看到: 81 时间
最后更新: 18-4-16 上午7:14