Re: VM-Ware Backup of VM safe?

From: "Klaus P(dot) Pieper" <kpi6288(at)gmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: VM-Ware Backup of VM safe?
Date: 2017-09-20 15:15:36
Message-ID: 00be01d33223$509ee0b0$f1dca210$@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Ursprüngliche Nachricht-----
> Von: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] Im Auftrag von Thomas Güttler
> Gesendet: Mittwoch, 20. September 2017 10:03
> An: pgsql-general(at)postgresql(dot)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 am not sure about VM-Ware, but in any case I don't think that PostgreSQL provides anything similar to a VSS writer (neither on Windows nor on Linux), so the answer is most likely "no, it is not safe".

Regards, Klaus

---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Moreno Andreo 2017-09-20 15:41:48 Re: [SPAM] Re: VM-Ware Backup of VM safe?
Previous Message David G. Johnston 2017-09-20 15:14:07 Re: Insert large number of records