Re: [SPAM] Re: [GENERAL] VM-Ware Backup of VM safe?
> -Ursprüngliche Nachricht- > Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] Im Auftrag von Moreno Andreo > Gesendet: Mittwoch, 20. September 2017 17:42 > I may be wrong, as I don't know MS SQL Server, but in the way you describe it, > you make me come in mind pg_basebackup(). A VSS writer just prepares a snapshot of the (virtual) machine while pg_basebackup make actually a (safe) copy of the cluster - important differences are that VSS writer 1) is called by the operating system, 2) is much faster and 3) does not need space for a complete backup. But you are right: if you can ensure that pg_basebackup has finished prior to making a backup of the virtual machine, this is certainly safe. Klaus --- Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft. https://www.avast.com/antivirus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [SPAM] Re: [GENERAL] VM-Ware Backup of VM safe?
Il 20/09/2017 17:15, Klaus P. Pieper ha scritto: -Ursprüngliche Nachricht- Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] Im Auftrag von Thomas Güttler Gesendet: Mittwoch, 20. September 2017 10:03 An: pgsql-general@postgresql.org Betreff: [GENERAL] VM-Ware Backup of VM safe? We run a PostgreSQL 9.6 server in a virtual machine. The virtual machine is managed by the customer. He does backup the VM. Is this enough, is this safe? When you run MS SQL Server on Hyper-V / Windows, the SQL Server provides ist own VSS writer responding to a taking a snapshot. This ensures that the image oft he SQL database is in a safe stake when the backup is written. I may be wrong, as I don't know MS SQL Server, but in the way you describe it, you make me come in mind pg_basebackup(). -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general