Re: [GENERAL] VM-Ware Backup of VM safe? - Mailing list pgsql-general

From George Neuner
Subject Re: [GENERAL] VM-Ware Backup of VM safe?
Date
Msg-id 6du4sc9ne7gnts9h95o1d8kufoatsgejmp@4ax.com
Whole thread Raw
In response to [GENERAL] VM-Ware Backup of VM safe?  (Thomas Güttler <guettliml@thomas-guettler.de>)
List pgsql-general
On Wed, 20 Sep 2017 10:03:15 +0200, Thomas Güttler
<guettliml@thomas-guettler.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



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Job
Date:
Subject: [GENERAL] Inserting millions of record in a partitioned Table
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Insert large number of records