Re: VM-Ware Backup of VM safe?

From: George Neuner <gneuner2(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: VM-Ware Backup of VM safe?
Date: 2017-09-20 15:02:03
Message-ID: 6du4sc9ne7gnts9h95o1d8kufoatsgejmp@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 20 Sep 2017 10:03:15 +0200, Thomas Güttler
<guettliml(at)thomas-guettler(dot)de> wrote:

>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?

It is "safe" if the VM is shut down first or if the backup is by
copying a point-in-time snapshot of the VM.

Whether it is "enough" is a matter of opinion. Backing up a VM
basically is the equivalent of imaging a hard drive: it's great if the
filesystem is intact and the image is clean ... otherwise it's not so
good.

If the database files on the VM's "drive" develop errors, those errors
will be preserved in the VM backup.

George

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-09-20 15:14:07 Re: Insert large number of records
Previous Message Job 2017-09-20 14:10:58 Inserting millions of record in a partitioned Table