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.


How to setup a regular PostgreSQL database backup

Admin ERP
am28.08.16, 13:42 496 Ansichten

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.)


Admin ERP

--Admin ERP--
Simplify-ERP® – digitale Transformation für Handelsunternehmen – Wapsol GmbH
| 2 1 3
Skopje, Mazedonien, ehem. jugoslawische Republik
--Admin ERP--
Admin ERP
An 28.08.16, 13:42

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.

Kommentar hinzufügen

Bleiben Sie informiert

Über diese Community

Diese Community ist für Profis und begeisterte Benutzer unserer Produkte und Dienstleistungen. Teilen und diskutieren Sie die besten Inhalte und neue Marketing-Ideen, stärken Sie Ihr berufliches Profil und werden Sie gemeinsam bessere Vermarkter. Leitfaden


1 Verfolger


Fragestellung: 28.08.16, 13:42
Gesehen: 496 -mal
Zuletzt aktualisiert: 28.08.16, 13:42