Backup strategy for PostgreSQL performance warehouse
Hi all,
what's the recommended backup strategy for performance warehouse stored in a PostgreSQL database?
Our dynatrace server is installed in a VM, can we fully backup the VM on a daily basis, performance warehouse included, with dynatrace operating? It's not necessary to stop dynatrace to backup their performace warehouse?
Regards, Josep Maria
Hi
Sorry for the late reply. Here is feedback from our engineering team which I hope helps:
There should be no problem with your VM backup strategy. Postgre always keeps the file system state consistent - meaning - all data stored to disk asap. So - it would be very very unlikely that your VM backup happens at a time when this state is not consistent and synced to disk. Also - there are different postgre backup strategies - check it out: http://www.postgresql.org/docs/9.3/static/backup.html
I hope this helps
